MySQL External Checks don't work with 2.0 agent

[ucs75]

Recenly upgraded to 2.0.2 server from 1.8.

If I update the zabbix_agentd to version 2.0.2, my external checks stop working. I've also tried using the pre-compiled 2.0 agent from the download page. If I use v1.8 zabbix_agentd, it works fine.

Operating System info:

# uname -a
Linux ftlx005.mydomainname.com 2.6.18-128.1.10.el5.xs5.5.0.51xen #1 SMP Wed Nov 11 08:31:24 EST 2009 x86_64 x86_64 x86_64 GNU/Linux

Relevant portion of zabbix_agentd.conf:

UserParameter=mysql.ping,mysqladmin -uroot -h127.0.0.1 ping|grep alive|wc -l
UserParameter=mysql.uptime,mysqladmin -uroot -h127.0.0.1 status|cut -f2 -d":"|cut -f1 -d"T"
UserParameter=mysql.threads,mysqladmin -uroot -h127.0.0.1 status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql.questions,mysqladmin -uroot -h127.0.0.1 status|cut -f4 -d":"|cut -f1 -d"S"
UserParameter=mysql.slowqueries,mysqladmin -uroot -h127.0.0.1 status|cut -f5 -d":"|cut -f1 -d"O"
UserParameter=mysql.qps,mysqladmin -uroot -h127.0.0.1 status|cut -f9 -d":"
UserParameter=mysql.version,mysql -V

If anyone has been able to get this to work, I'd love some help!

Thanks

[ucs75]

Test (failed)

On a hunch, I revised the external check definitions in the zabbix_agentd.conf file.

The original definitions were taken from the Zabbix documentation, and although they worked with v1.8 they DO return numbers with whitespace before and after them. The revised version (below) returns correct values WITHOUT whitespace. Unfortunately, it doesn't make a difference. Agent v2.0x still does not work.

UserParameter=mysql.ping,mysqladmin -uroot -h127.0.0.1 ping|grep alive|wc -l
UserParameter=mysql.uptime,mysqladmin -uroot -h127.0.0.1 status|cut -f2 -d":"|cut -f2 -d" "
UserParameter=mysql.threads,mysqladmin -uroot -h127.0.0.1 status|cut -f3 -d":"|cut -f2 -d" "
UserParameter=mysql.questions,mysqladmin -uroot -h127.0.0.1 status|cut -f4 -d":"|cut -f2 -d" "
UserParameter=mysql.slowqueries,mysqladmin -uroot -h127.0.0.1 status|cut -f5 -d":"|cut -f2 -d" "
UserParameter=mysql.qps,mysqladmin -uroot -h127.0.0.1 status|cut -f9 -d":"|cut -f2 -d" "
UserParameter=mysql.version,mysql -V