Problem with install.php

jwhance · March 14th, 2005, 07:12 AM

After installing PHP, MySQL, and PhotoPost as instructed, I am attempting to run install.php.

I get the "Welcome to PhotoPost" install screen with the "Click here to start a fresh install -->" link.

But when I click that link the browser refreshes and returns to the same thing.

Chuck S · March 14th, 2005, 10:18 AM

Edit your php.ini and try setting

register_long_arrays to ON

jwhance · March 14th, 2005, 10:30 AM

Ok, we're past that issue. I gave up on PHP 5.0.3 (you may want to make a note of that) and went back to V4.

I'm now at the point where MySQL is being accessed and I'm getting:

I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.

I do have MySQL installed and have a user "photopost" and have double checked the password.

I can connect to MySQL from the MySQL administrator control panel so it seems that part is OK.

jwhance · March 14th, 2005, 11:45 AM

You should pay me for finding these answers for you. Here's the problem:

1) install.php does not do any MySQL error reporting. So the real issue is hidden. So adding a call to mysql_error() gives the hint:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

2) At least that is something that can be found on the MySQL documentation site:

http://dev.mysql.com/doc/mysql/en/old-client.html

The problems here from my viewpoint are:

1) You don't say that this might be a problem in your instructions.
2) You don't say to use a specific version of MySQL.
3) You don't report this error and leave your customers in confusion.

Regards,

Joe

Chuck S · March 14th, 2005, 02:07 PM

Of course we use mysql error reporting what do you think this is

Quote:

I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.

Your issue is simple the mysql info your using is incorrect. Either the host database name username or password are incorrect.

thechameleon · March 14th, 2005, 03:58 PM

Actually, neither of those are the problem I don't think, having experienced this myself, the problem is either I don't think jwhance gave full access permissions to that database for the "photopost" user:

http://dev.mysql.com/doc/mysql/en/adding-users.html

OR, much more likely, he has not modified his user's mysql account per this article:

http://forums.mysql.com/read.php?11,6400,6701#msg-6701

Hope this helps!

Chuck S · March 14th, 2005, 04:29 PM

Well I see what your saying and yes if you dont give the user permissions to the database the issue is still the same. The user info to the database is wrong.

thechameleon · March 14th, 2005, 05:06 PM

Touché! I am pretty sure though it is the second issue with the password... I don't understand it (not familiar enough with MySQL) but it worked for me when I was having the same errors... I guess it is a SQL 4.1 and older client API issue...which is also a PHP 4.3.10 issue which is compiled with an older MySQL client API.

jevindme · March 14th, 2005, 05:21 PM

I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.

I am sure that you have checked the password and still it doesn't work
Under Windows try WINMYSQLADMIN and make my.ini file
Search Windows directory to my.ini and what you see is a password who I bett you did'nt know '

Place this in user and pass in config-ini and YEP its works. Seems WHICH user installed MySql....Administrator or User with Admin priveleges Very strange

More problems....I will help you

Chuck S · March 14th, 2005, 06:34 PM

Make sure to clear all cookies and cache and try again.

jwhance · March 15th, 2005, 12:48 PM

No, the problem was not the user permissions or the password. Please see the MySQL information at:

http://dev.mysql.com/doc/mysql/en/old-client.html

As I referenced it above. It seems that you are using "old" client methods from MySQL's point of view and the fix they describe solved the issue.

jwhance · March 15th, 2005, 12:50 PM

And just to defend my reputation here. The install.php script does NOT report the MySQL error details, it simply says there was an error.

MySQL said: "Client does not support authentication protocol requested by server; consider upgrading MySQL client"

And no amount of config file twiddling would have resolved this issue.

Is it possible that the version of MySQL that I'm using:

MySQL 4.1 -- Generally Available (GA) release (recommended)

is NOT fully compatible with PhotoPost?

thechameleon · March 15th, 2005, 01:48 PM

Thank you, that article you mentioned specifically mentions the password fix as a possible solution. So in fact, that was exactly the problem... and I listed what exactly the solution was, which is modifying your user password to the older hash algorithim. Apparently you can also modify the mysql server install to include the older hash, but given your inexperience with MySQL and my own, changing the password of your account to the old style seems the easiest.