PDA

View Full Version : coppermine (php script) problem...


jaxxy
09-30-2003, 01:51 AM
Before the server reboot and all that stuff I had Coppermine, a PHP script which utilizes mysql, up and running on my site. After the server reboot, the mysql database I had created was gone and the script no longer worked. I tried making a new db, which seemed to accomplish nothing. I tried re-uploading various files, but I couldn't re-upload the install.php file (there are probably security measures that prevent me from doing this). In frustration, I tried deleting the whole directory to start over from scratch. The files wouldn't delete. I received a "550 access denied" message every time I tried deleting the files. Does anyone have any advice??? :?

thevillageinn
09-30-2003, 02:51 AM
if you are on the rebuilt server, www8 I think it is, the restore of data probably changed the ownership of most of your directories and possibly some files. that is likely the delete issue you are having...check the ownership with a FTP client, or with ensim's file manager. (a ticket at the help desk will resolve this problem if it exists)

also, regarding the mySQL database. did you restore the data from your /var/backup directory into the database you re-created? also, is the mySQL password for your account correct? it probably needs to be reset if you are on the rebuilt server.

jaxxy
10-02-2003, 06:25 PM
i dont know how to check ownership with an FTP client...

also, regarding the mySQL database. did you restore the data from your /var/backup directory into the database you re-created? also, is the mySQL password for your account correct? it probably needs to be reset if you are on the rebuilt server.

did i restore data...i dont understand that = i never made a back-up of my site; i just got it during that back-to-school special. i dont really mind setting up the whole thing again, but i need to be able to delete the files before i do that, and i dont know how.

Nick
10-03-2003, 12:08 AM
hello jaxxy

put in a helpdesk ticket with the database name and how many you had
when you put that in..ill make sure the permissions are right

thevillageinn
10-03-2003, 02:48 AM
jaxxy,
your problems will probably be solved by Joe or Nick when you put in a help desk ticket, but I'll explain what I was referring to, for you or others with a similar problem.


to check ownership with an FTP client:
typically this involves right-clicking on a file and choosing properties or file information. Not all FTP clients offer this functionality, but most do.

to check ownership with ensim file manager:
simply navigate to the desired directory, probably your main html directory (/var/www/html). In the listing of files and directories the second column from the right is "Owner" usually the owner will be "admin" but after a server restoration, you may notice many of the directories are owned by "root". That will prevent you from making various changes.

if you have any problems with file or directory ownership a trouble ticket at the help desk will solve the problem easily.

As far as the back up of the data you had on your site:
in the directory /var/backup there are complete backup files of everything on your site. these files are created nightly, automatically for you. If you had any mySQL databases, there would be back up files in there for them. To restore the mySQL data, you would download the back up file for the database you wish to restore, unzip it, and then utilize the files you just unzipped to run mySQL queries which would create your tables and restore your data. I made a little checklist for this part here in another post in the forum (http://www.hostpc.com/phpbb/viewtopic.php?t=435&postdays=0&postorder=asc&start=30) (4th one down)

Hope that helps you or anyone else...let me know if there are futher questions-
-dan

jaxxy
10-04-2003, 01:54 AM
1. I made a ticket at the help desk
2. You were right; the folder does say "root", not admin.

Thanks for your input, thevillageinn =)

thevillageinn
10-04-2003, 04:32 AM
no problem, I'm glad to help, sorry if I confused you originally.

that ticket at the help desk should take care of the problem for you and get you moving again.

-dan