Sorry to beat a dead horse, but I've read all of the relevant forum threads and I'm still banging my head against the wall with this. I'm new to PHP, MySQL and Xen Photo, so please, be gentle!
I've downloaded the latest release of ZP, made the changes to the zp-config.php file (and took off the .example extension). I've uploaded (via FTP) all of the folders and files to my server, which is hosted through GoDaddy.
The problem is that when I go to the setup (www.justperfectonline.com/zenphoto/zen/setup.php) it gives me the following error:
MySQL Error: Could not connect to the database server. Check your zp-config.php file for the correct Host, User name, and Password.
I tried changing the MySQL host in the zp-config file from "local host" to "h41mysql41.secureserver.net" which is what Godaddy tells me the MySQL database host name is.
Here is my zp-config.php file (minus the passwords):
I've tried uncommenting the last 2 lines (// define('WEBPATH', '/zenphoto'); // define('SERVERPATH', 'd:\hosting\jimandpam') but that doesn't work.
My PHP info can be found at http://www.justperfectonline.com/phpinfo.php
I believe my server uses IIS, but I'm not sure (my knowledge is limited on that front).
Please help me fix what is probably an obvious mistake-- and excuse my dim-witedness!
Thank you!
Jim
I have already created the database, which is named "whoohaaracing"
It did not set up any tables or anything in the database, just created it and set a username and password.
The following database information is from my GoDaddy hosting control center/Database Management panel:
Host Name: h41mysql41.secureserver.net
Database Name: whoohaaracing
Database Version: 4.1
Description: WhoohaaGallery
User Name: whoohaaracing
Any ideas?
You did everything right. Maybe still just a typo in password?...just guessing I am sure you already checked this a dozen times. I am very sorry I have no idea what the mistake might be. I do neither know your host nor do I have experience with IIS servers. I hope that someone of the others can help you.
I forgot: I tried to look at your phpinfo.php but the "page is not found".
Sorry- I put the wrong URL to the PHP info file. Here's the real McCoy:
http://www.justperfectonline.com/zenphoto/phpinfo.php
Thanks for looking!
safe mode is on. that presents a lot of problems for zenphoto operating properly. that may just be the issue, although i don't remember it not actually stopping you from connecting to a mysql server, you usually get other errors instead. (double checking the password is a good idea). this is something that is host configured, and must be turned off on your host's end. The PHP developers even have not so good things to say about safe mode:
http://www.php.net/manual/en/features.safe-mode.php
Safe mode essentially is a solution to shared server security issues, and is not the right way to go about it. It breaks a lot of applications. The best solution is to find a host that doesn't use safe mode. At worst, zenphoto won't work properly with it on.
Up and running!
I called GoDaddy and they switched me to a Linux server. Problem solved.
Thanks!
Cool. Glad to hear everything is good. Let us know if you need further assistance.