ibawolf
09-03-2005, 18:11
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
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