Member
Member
jgianoglio   2007-08-28, 16:07
#1

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

Administrator
Administrator
acrylian   2007-08-28, 16:45
#2

Are you sure about the database name? Do you really have already an active database? You need to do that before zenphoto setup.

From your zp-config-file I would guess that the name of your database would be "h41mysql41".
Have you tried that?

Member
Member
jgianoglio   2007-08-28, 18:04
#3

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?

Administrator
Administrator
acrylian   2007-08-28, 18:56
#4

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".

Member
Member
jgianoglio   2007-08-28, 19:38
#5

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!

Member
Member
thinkdreams   2007-08-28, 22:29
#6

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.

Member
Member
jgianoglio   2007-08-29, 12:55
#7

Up and running!
I called GoDaddy and they switched me to a Linux server. Problem solved.
Thanks!

Member
Member
thinkdreams   2007-08-29, 22:50
#8

Cool. Glad to hear everything is good. Let us know if you need further assistance.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.