Database Issues?

[DrakeHS]

Hi,

My company purchased supportsuite 1st of February. The guy who was supposed to set all of this up left us a couple of weeks later without completing the installation. My boss has now given me the task of completing this and getting it up and running. It is currently to the part where you run the setup/setup.php from the browser. When I enter this i get the following error:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\support\includes\functions.php on line 421

I am assuming that this means there is an issue between PHP and MYSQL. After a lot of research I cannot figure it out. Any ideas? I am about ready to pull out what is left of my hair.

Thanks

[eiden]

Well this page is the first that pops up in google:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

What Client API version of the MySQL library are you using? You can find this out with phpinfo()

My version is 5.0.37

[DrakeHS]

Thanks for the quick reply. After a little more looking after my post I did find the information shown in your link. I gave it a try and it still didn't make a difference. The Client API version is 3.23.49.
Do I just need to start all over? The version of PHP that is installed is 4.4.4 and the version of MySQL is 4.1. Should this work ok?

Again thanks for the help.

[Sheep]

http://dev.mysql.com/downloads/connector/php/
update the client mysql connector to the 4.1 version

Why should I download the PHP mysql/mysqli extensions from mysql.com and not from php.net? The binary distribution of mysql.com is based on the latest MySQL Client libraries. Only the libraries used for the mysql.com distributions contain the latest bug fixes and can use all the features of the MySQL Server versions 4.1.21 and 5.0.27.
The PHP 5.1 distribution that is available on php.net is linked against an old version of the MySQL Client API library. The mysql and mysql extensions from php.net are based on the MySQL Client API version 4.1.7. The MySQL Client API versions used for the mysql.com downloads are 4.1.21 and 5.0.27.
We recommend to use the MySQL Client API version that matches the MySQL Server version. For the MySQL Server 5.0.27 you should use the MySQL Client API 5.0.27 (mysql.com download) but not 4.1.7 (php.net download). For example, mysqli_stmt_bind_param() will fail when you try to access a DECIMAL column on a MySQL 5.0.27 server if you use old versions of the MySQL Client API, like the php.net downloads do.

[DrakeHS]

Thanks for the reply. I will take a look at this and let you know how it goes.

[DrakeHS]

OK....I have looked through and tried everything I have read and nothing has helped. So I started from scratch (I think). I removed sql and reinstalled. I created a new database with user from the command line interface. When I go into the setup of support suite it won't connect to the database and I get the following error at the top of the page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in c:\inetpub\wwwroot\support\includes\functions.php on line 421

What does this mean? I hope I'm not screwing things up more.

Thanks for the help.

[craigbrass]

Have you set a password for the root user? If so you will need to use it as according to that error, you are currently not doing so.

[DrakeHS]

Thanks for all the help and I apologize if this seems to simple. However I haven't messed around with MySQL before. I did forget to edit the config.php file before uploading. I edited this file and now get a different error when trying to run the setup.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dhs_user'@'localhost' (using password: YES) in c:\inetpub\wwwroot\support\includes\functions.php on line 421

The functions.php file is not a normal editable file so I can't go in and see what is causing the error. I am assuming it has something to do with the way PHP and MySQL is trying to connect. As per the previous posts I find that when running phpinfo under MySQL it still shows the client API version as 3.23.49. Is this what could be causing the problem? Any more help would be appreciated.

Thanks
Mike

[DrakeHS]

OK...

Quick update. From my last post I noticed that the username is wrong (too many hours). So now I am back to the beginning error as in my first post. I have looked at the Sheeps post in upgrading in upgrading the api client version. However after following the steps it still shows the old version when running phpinfo. I even went as far as installing MySql 5.

Any ideas?

Thanks
Mike

[eiden]

Try this:
Download the MySQL GUI-tools: http://dev.mysql.com/downloads/gui-tools/5.0.html

Open MySQL Administrator. Type in the username (root), password and hostname to your server and click on the "OK"-button.

Click on "Startup Variables" in the list to the left. Click on the "Security" tab. Check the "Use old password" and click on "Apply changes".

Restart the server.
Go to "Service Control" in the list to the left. Click on the "Stop Service" button. After the server has stopped, start it again.

Click on "User Administration" in the list to the left. Select the user (under "Users Accounts") you have specified in "config.php". Clear both the password fields, type in the password, and click on "Apply changes".

[DrakeHS]

HHHOOOOAAAAAHHHHH!!!!!!

I finally got past the final dreaded error!! OK so I haven't gone through the rest of the setup before posting this but I am at least farther along than I have been. Eiden, your last post did it.

I want to thank everyone who posted their help here. I really appreciate. At least now I know where to go for help.

Thanks again!!
Mike

[Jamie Edwards]

Hi Mike,

I am glad to hear you have it sorted, and thanks to everyone for your time spent helping Mike.

[eiden]

Glad that I could help