Phpauction2.0

[awhfy99]

Hi folks!

I created the database, the database user, and added the user to the db.

--------------------------------------------

djscoll_auction (Privileges: ALL PRIVILEGES)

 

Connection Strings

Perl $dbh = DBI->connect("DBI:mysql:djscoll_auction:localhost","djscoll_auction","<PASSWORD HERE>");

PHP $dbh=mysql_connect ("localhost", "djscoll_auction", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("djscoll_auction");

-----------------------------------------

 

 

 

When I run the script, I get a host of errors (which is better than I was originally getting)

 

 

Please select : Create new database Use existing database

Database host : localhost

Database name : djscoll_auction

Database username : djscoll_auction

Database password : my password

Admin E-Mail : my email

Site name : djscollectables.com

Site URL : full path of my site

 

Since this is just an add-on to my site, I am not sure whether to show the url to the site or to the index.php that will call the auction software (or if it even makes a difference, as I have tried both and neither changes the outcome).

 

I have attached a txt file showing the error output. I thought that it may be a chmod problem, so I did the whole thing as 777, which didn't help. Any suggestions would be greatly appreciated.

[TCH-Don]

Where did you get the script?

 

I see the option

Please select : Create new database Use existing database

 

What happens when you selected Use existing database?

[borfast]

Moving to a more appropriate forum for organization.

[awhfy99]

Hi Rock Sign ,

 

I paid for a download of the phpauction2.1 software many, many months ago and finally figured out a use for it (it's not another auction). The script for installation was included but the documentation is almost non-existent. One of the team members of osCommerce's developement project had an ad on his site so I contributed to their cause.

 

Anyway, silly me, after I thought I had tried every combination, it dawned on me that I hadn't. I finally did get the script to run, and the db installed. Thanks for taking the time to respond though.

 

I do have another related question, but I don't know if it would be better to ask it on the proper forum or just do an add-on here. Oh well, if it needs to be moved, sorry! Here it is: What would be the code to get a cron job running (auctionupdate.c) so that the closed items are handled correctly? I have several test items floating in never-never land. They show to be closed on the item's template but not in MySQL, and I think all that is needed is to run that c script.

Thanks in advance!

Dennis

[TCH-Bruce]

I would guess that auctionupdate.c is a "C" source file and you would not be able to run it in it's current form. It would require being compiled first. Since you don't have shell access you cannot compile it yourself.

 

If you have the Linux compiled version of that source file you could set up a cron job using cPanel to run it.

[awhfy99]

Thanks, I just noticed that there is a build.sh script that will compile it, but I can't run it do to the shell restrictions that are in place. Would the help desk be able to assist me in this, since I can't access the shell?

Which brings to mind another another minor inconvienence, since I have thousands of small images in my image folder. To remove any of them, I have to view the whole directory, instead of being able to use the ls command (via my FTP program). It once worked but doesn't seem to be doing so now. Is there any possibility of getting limited access to the shell, as that would help a bunch? I have tried the file manager through cPanel, but it is not any faster than the FTP way.

[TCH-Dick]

Which brings to mind another another minor inconvienence, since I have thousands of small images in my image folder. To remove any of them, I have to view the whole directory, instead of being able to use the ls command (via my FTP program). It once worked but doesn't seem to be doing so now. Is there any possibility of getting limited access to the shell, as that would help a bunch? I have tried the file manager through cPanel, but it is not any faster than the FTP way.

What FTP program are you using? I have no problem running the ls command. I tried it from the command lina and my FTP program. Most FTP programs are made to allow the average user to use FTP. For this reason they provide 'File Mask Text Boxes' or something similiar. It works exactly like the ls command, you just don't have to add 'ls'. So if you just wanted to show files that begin with C then just enter C*.

[awhfy99]

It is WS_FTP, the ls command used to work, either with or without any options (-l, -la) but one day I tried it and it came back as a blank screen, and has been doing so ever since. Again, I thought that it may be a permissions issue so I tried the good ol' 777 on the directory, didn't help though. I've been through the options on the FTP program and don't see anything that has changed so I just figured that the use had been restricted.

[TCH-Dick]

I use WS_FTP 9, here is a pic of the file mask and where to add it if it's not already there.

[awhfy99]

Thumbs Up

 

Thanks, that helped a whole bunch!

 

Now to get the source code compiled... I'll then be an almost happy camper . My best guess is to submit a ticket to get it done, then I worry about setting up the cron job.

 

Thanks!

[awhfy99]

Thumbs Up Liz did a fine job on getting the source code compiled. So that leaves me with just one more question (for now, anyway). What code would I use to get the auctionupdate script to run in cron? I tried ./auctionupdate but since nothing seems to come from it, I must assume that's not the way it's done. Kinda thought that if it were incorrect that I would get buried in the error log, guess it hasn't had time to spit them out yet (it's too busy laughing).

[TCH-Bruce]

You will need to put the full path to the script in your cron job. So it will look something like this:

 

/home/cpanelusername/public_html/path-to-script

[awhfy99]

Looks like I need some big time help. Is there a way to manually execute the script to see if it is doing what it's supposed to do? Is there a command that would be entered prior to this to make it work? When I enter the path from my browser, all I get is a notepad view of the files contents, which makes me wonder if that is all that is being produced through cron...Ive been working on this so long that my brain is getting fuzzy. I have tried many combinations and the items have not updated (I am not sure if they are even supposed to do so, since they were closed prior to cron being activated, but that doesn't seem likely). I have the scheduler set for every minute of every day, hoping that by the time I try another combination, that it would be completed (if I did it right) when I got there to check it. So far, it's a big fat zero. I can go into MySQL and change the items status to closed and everything looks as it should, if that makes a difference.

 

Assuming my site = junkyarddogs.com

cPanel username = junkyar

public_html/biggy/cron/update

 

/home/junkyarddogs.com/public_html/biggy/cron/update is what I have entered on the standard cron manager's command line.

 

This is the only one I saw that didn't kick out a ton of 404 errors. Again, I don't know if that is a viable option. Any help will be sincerely appreciated.

[TCH-Bruce]

Is the name of the script "update" or "auctionupdate"? Above you wanted to run ./auctionupdate.

 

The cron command would end with the script name. Sorry, if you renamed it update. Just trying to help.

 

There is no way to run any scripts other than through a cron job.

[awhfy99]

Hi Bruce,

No, that was just what it would have been if the the above example was used (it is still auctionupdate). I thought I was in the right place to check the error output, then I realized that it would be going to my webmail, Duh!

Anyway, they are there in great numbers and are telling me that the number of parameters are incorrect. Anyone having any ideas as to what parameters they are referring to, please clue me in. I don't have access to a Unix manual and I sure could use a little assist on this one.