MySQL install problem

os07

I'm trying to install ZenPhoto for a client. I've lots of these before, but the MySQL connection - which I can easily make via any MySQL front end - doesn't seem to work with ZenPhoto. Here are the 4 parameters:

$conf['mysql_user'] = "correctusername";
$conf['mysql_pass'] = "correctpassword";
$conf['mysql_host'] = "mysql5.s000.somewebserver.com";
$conf['mysql_database'] = "client_portfolio";

These settings work fine in other MySQL apps, but not in ZenPhoto. The host name is the one specified by the ISP - and it works in other apps. The database name has an underscore in it, and I have tried using it without the underscore - also no go. What am I missing? TIA for your collective wisdom!

sbillard

What version of zenphoto are you using? The current version nightly builds have fixed a few problems dealing with special characters in the database name.

What does the setup program report? Normally with the current version of zenphoto you do not edit the zpconfig.php file directly, these parameters are supplied during the setup.

os07

ZenPhoto v.1.15 - freshly downloaded.

ZP reports: "Could not connect to the MySQL server. Check the user, password, and database host in your zp-config.php file and try again."

I'm familiar with the way the install works - this is the first one I've attempted that didn't just work right off the bat.

I will try the nightly build and report back.

Thanks for your help!

os07

Hi. Nightly build doesn't seem to work for me.

I deleted the entire ZP install and reinstalled 1.1.5 - same result as initially.

This is truly odd: I can access the db via almost ANY MySQL tool I have with these same settings - so I know that the user, password, host name and db name are correct.

I'm sort of under the gun with the site in question; all the rest of the coding is abou done. I'm a bit chagrined that the ZP install isn't just routine.

os07

Hi. Nightly build doesn't seem to work for me.

I deleted the entire ZP install and reinstalled 1.1.5 - same result as initially.

This is truly odd: I can access the db via almost ANY MySQL tool I have with these same settings - so I know that the user, password, host name and db name are correct.

I'm sort of under the gun with the site in question; all the rest of the coding is about done. I'm a bit chagrined that the ZP install isn't just routine.

pavve1

$conf['mysql_user'] = "****_****";

$conf['mysql_pass'] = "*******";
$conf['mysql_host'] = "localhost";
$conf['mysql_database'] = "****_******";

// If you're sharing the database with other tables, use a prefix to be safe.
$conf['mysql_prefix'] = "";

This is from zp-config of my working trial installation of 1.1.5

os07

Thanks for your suggestions - still no go.

I think that the problem lies in the designation of the MySQL host. I checked with the ISP in question, and my connection via SQLyog also verifies that the proper specification for the MySQL host is "mysql5.s123.somewebserver.com" and not "localhost".

I have set up ZP on other websites with no installation issues whatever, so I'm at a loss as to why this one refuses to install. What about the setting for the port? SQLyog auto-senses 3307, but I think the default is 3306. Is there a place in ZP where this is listed?

os07

FIXED! It WAS a host designation problem, after all. I went back and re-read the ISP's MySQL FAQ. It seems that while "mysql5.s123.somewebserver.com" is the correct designation for REMOTE access into the db, the proper specification for LOCAL (the server itself, i.e.) is "localhost:/tmp/mysql5.sock".

My bad - I was thinking "remote" client and I should have been thinking "local" client.
Works just fine! Thanks to all for your suggestions.