Client doesn't support authentication protocol requested by.

[Pumpi]

Trying again Cacti 0.85 on W2K IIS 5.0 I get this error message when trying to run Cacti :

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\cacti\lib\adodb\drivers\adodb-mysql.inc.php on line 318

Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

I'm running the IIS in CGI mode.

Any ideas what is going wrong ?

Pumpi

[Pumpi]

No ideas ??

raX

[Lux]

I ran into something similar last week. My problem was that I had mistyped the database name into my Cacti configuration file. This probably isn't your problem, but it doesn't hurt to look.


Mike

[Pumpi]

Check this config and everythink seems to be ok but the error stays

[bulek]

Does this problem description match your configuration?
http://www.mysql.com/doc/en/Old_client.html

- Piotr

[Xphu]

Hi,

I had the same problem. Please return to the earlier mysql 4.0.17-nt.

That´s because of the "old" PHP and MySql versions dont match with authentication. Promlem is solved later with PHP 5


xphu

[Pumpi]

Thanks for answering - going back to old mysql version

[Stoo]

I have been using mysql 4.1, and get this problem. It is fixed by reading
http://www.mysql.com/doc/en/Old_client.html . Below is what I chose to do.

Add the following option to your my.cnf file in the [mysqld] section:

Code: Select all

[mysqld]
# other options here
old-passwords

Stop and start mysqld:

Code: Select all

service mysql restart

Use your mysql client to log in:

Code: Select all

mysql -u root -p mysql

Convert your password to the old password format (<16 chars):

Code: Select all

UPDATE mysql.user SET Password = OLD_PASSWORD('cactipass') where User="cactiuser";

Code: Select all

flush privileges;