Mysql ping

[bdub]

Hello all,

I am running zabbix 1.1b9.

I have been trying to implement a trigger on a host of mine to tell me if mysql has stopped running. My trigger reads as follows:

{testbed:mysql[ping].max(300)}=0

the relevant section of my agent conf file reads as follows:

UserParameter=mysql.ping,mysqladmin -u<username> ping|grep alive|wc -l

However, it does not show up under monitoring->overview, and when I'm under configuration->hosts->triggers and click on my expression, the graph that comes up just says 'No Data'.

Any ideas what's wrong?

Please let me know if I can provide some more relevant information.

Thanks much,


brian

[krusty]

You have to set the password into the zabbix_agentd.conf file.

Use this:
UserParameter=mysql.ping,mysqladmin -u<username> -p<password> ping|grep alive|wc -l

[bdub]

I just changed my agentd.conf to read

UserParameter=mysql.ping,mysqladmin -uroot -p<mypassword> ping|grep alive|wc -l

And after watching it for about an hour, it still collects no data.

I'm positive that agentd is actually running...

brian@testbed:/etc/zabbix$ ps -ef | grep zabbix
zabbix 20985 1 0 Apr28 ? 00:03:55 zabbix_agentd
zabbix 20986 20985 0 Apr28 ? 00:00:00 zabbix_agentd
zabbix 20987 20985 0 Apr28 ? 00:00:00 zabbix_agentd
zabbix 20988 20985 0 Apr28 ? 00:00:00 zabbix_agentd
zabbix 20989 20985 0 Apr28 ? 00:00:00 zabbix_agentd
zabbix 20990 20985 0 Apr28 ? 00:00:00 zabbix_agentd
zabbix 30818 12442 0 07:29 pts/1 00:00:00 grep zabbix

Any other ideas as to what could be wrong?