Problem with install.php
 

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.

Edit your php.ini and try setting

register_long_arrays to ON

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.

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

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

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

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!

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.

:) 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.

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

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

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.

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?

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.