Getting error from MySQL

[ibawolf]

Hi everyone.

I found out about Zabbix when I read the article "The Watcher Knows" in the March issue of "Linux System Administrator". It looks like a very impressive product, but I'm having a problem.

I selected a server to run a test with (single cpu, 2.8 Ghz Xeon with RedHat Enterprise Linux 3). For the database I used the MySQL that was distributed with RHEL3. The rpm utility shows:

> rpm -qa | grep -i mysql
mysql-devel-3.23.58-1
perl-DBD-MySQL-2.1021-3
MySQL-client-4.1.9-0
libdbi-dbd-mysql-0.6.5-5
MySQL-server-4.1.9-0
MySQL-python-0.9.1-6
MySQL-Max-4.1.9-0

I started up the MySQL server, created a MySQL user (actually 2) 'zabbix'@'localhost' and 'zabbix'@'%'. Both with the same password (just like the docs at mysql.com said).

I created a database called 'zabbix'.

I used create/mysql/schema.sql and create/data/data.sql to create and preload the tables in the zabbix database.

I configured the source with 'configure -with-mysql -with-net-snmp -enable-static (the last because I was going to distribute the code to machines that had an earlier version of MySQL client and libraries loaded.) and then ran 'make'.

I created /etc/zabbix/zabix_suckerd.conf and configured it with the hostname, database name, username and password for my MySQL server.

However, when I attempt to run zabbix_suckerd, I get the following result:

[root bin]# ./zabbix_suckerd
[root bin]# Failed to connect to database: Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Anyone have ideas why this is and what I can do to fix this?

Thanks in advance for all your help.

Ron

[cool_camel]

Try the link below may be will help you

http://rimuhosting.com/howto/mysqlinstall.jsp

# set a password# Note we use old-password (not password) so the password is set using the 'old' format.# The 'old' format seems to be more compatible with other apps (e.g. php)

/usr/bin/mysqladmin -u root old-password "$rootpasswd"
/usr/bin/mysqladmin -u root -h `hostname` old-password "$rootpasswd"