Zabbix-Server Unable to Start - MySQL Connection Issue

[server-specialists]

Hi Guys,

Hope someone can help. I'm stumped.

I am seeing the following error in the zabbix-server.log:

Failed to connect to database: Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Checking for Zabbix Version:
server-specialists:~# zabbix_server -v
ZABBIX Server (daemon) v1.1 (2 Juna 2006)
Compilation time: Jun 7 2006 20:08:56

I'm running MySQL 5.0.32

Can anyone point me in the correct direction in resolving this? Thank you in advance.

Regards,
John Z.

[server-specialists]

I checked my mysql logs and see the following:

070320 10:44:45 64 Connect root@localhost on zabbix
64 Query select @@version_comment limit 1
64 Query show tables
64 Quit
65 Connect Client does not support authentication protocol requ
ested by server; consider upgrading MySQL client

Any ideas?

[James Wells]

Greetings,

Failed to connect to database: Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Right off the bat, it appears that you are using a version of zabbix_server that was compiled for MySQL 4.x, but are actually using MySQL 5.x

I recommend recompiling your zabbix_server, using the correct, MySQL 5.x, libraries.

Additionally, I recommend upgrading from Zabbix 1.1 to Zabbix 1.1.6, there are a lot of big fixes your are missing.

[server-specialists]

James,

I believe you are right on the spot. I was able to get around the mysql issues with updating the zabbix user to use the OLD_PASSWORD algo.

I installed Zabbix using apt-get, I thought I set the source.list to use the zabbix repo so Im confused as to how I got an old version. Moving on.

Thanks for the insight.

[server-specialists]

So I reinstalled zabbix 1.1.6 from source. Compiled, it starts fine but now when I access the domain.com/zabbix Im getting:

Error connecting to database [Access denied for user 'www-data'@'localhost' (using password: NO)]

[James Wells]

Error connecting to database [Access denied for user 'www-data'@'localhost' (using password: NO)]

This means that the UI is not configured correctly. Look in the UI/include/db.inc.php file for the configuration.

[condor]

It might not be what you think...

I had a similar problem last summer. (I am running Zabbix on MySQL version 5.current)

Here is what I found out. More current versions of MySQL are a bit less forgiving on localhost logins. You can see this if you use the MySQL Admin GUI to connect to your MySQL instance. Add a "localhost" as a host for the user's login.

You can test this from the shell with:

mysql -u username -p

This will force it to your username on localhost and prompt for the password. If it detonates and won't let you in from localhost -you can use the admin GUI or do something like this: (borrowed from mysql manual on their site)

The percent sign is all servers -so you can do user@localhost

GRANT ALL PRIVILEGES ON your_database.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION \G

Additionally, the MaxDB versions of MySQL 5, and perhaps the latest MySQL 5.x servers want the longer hash key. The DBDBI wants the shorter version. (I discovered this using Webmin on my MaxDB instance -there is a checkbox that is essentially "use the old password method" -which I think is 64 and not 128 in length).

Make your user at the 64 bit key and then you can reset to 128 bits.

Myriad of issues with DBDBI before I figured out there was nothing wrong at all -just the crypto level of the password was not good for the database connector.

I am sure you can patch DBDBI and make it work at 128 instead of 64.

Yet, these will toss similar errors depending on how you call the connector.

Just thought I'd forward that piece of personal cussin' and fussin' along.