Problems with MySLQ Template

[ninyo]

Hi

im trying to monitorize one MySQL using Template_app_MySQL. I configured the host, and modifiy the zabbix_agentd.conf for MySQL uncomenting the lines:

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

From Zabbix web, i get:

"Not Supported" "Not supported by ZABBIX agent".

From logs, i get this:

"3363:20091125:151248 Parameter [mysql[ping]] is not supported by agent on host [ZABBIX Server] Old status [0]"

I can not see were is the problem. Any suggestions?

[MrKen]

Did you remember to restart the zabbix_agentd?

You should be able to test this by running the commands from the command line:

[root@zabbix zabbix]# mysqladmin -uroot -pPASSWORD ping|grep alive|wc -l
1

Any error message? (Access denied . . . )

MrKen

[ninyo]

Thanks for the reply

>Did you remember to restart the zabbix_agentd?

Yes, it has been restarted after every change on zabbix_agentd.conf

>You should be able to test this by running the commands from the command line:
>[root@zabbix zabbix]# mysqladmin -uroot -pPASSWORD ping|grep alive|wc -l
1

Works OK. No error messages. All the commands works OK from command line

>Any error message? (Access denied . . . )

MrKen
__________________
Disclaimer: All of the above is pure speculation

[MrKen]

So this is the Zabbix Server that you are monitoring. Are you already monitoring other paramaters successfully (i.e Template_Linux)?

If you can run those commands from the command line, then they should work in zabbix, assuming you are already successfully monitoring that host.

Try disabling the host, count to ten, then re-enable the host.

------
Timeout - just doing some checking. What version of zabbix are you using?
Seems there was some problem with Userparameters in 1.6.1 & 1.6.2

http://www.zabbix.com/forum/showthread.php?t=11560

[ninyo]

>So this is the Zabbix Server that you are monitoring. Are you already monitoring other paramaters successfully (i.e Template_Linux)?
Yes, Template_Linux works OK.

If you can run those commands from the command line, then they should work in zabbix, assuming you are already successfully monitoring that host.

>Try disabling the host, count to ten, then re-enable the host.
I will try.... it does not work

------
>Timeout - just doing some checking. What version of zabbix are you using?
>Seems there was some problem with Userparameters in 1.6.1 & 1.6.2
Im using zabbix 1.6.7 server and client.

Im monitoring zabbix mysql, is this relevant?. Have anyone a guide to monitor MySQL from Zabbix? Have to configure anything else than this parameters on Zabbix_agend.conf on the client?

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

[ninyo]

Ok, i found it.

On the template, the KEY appears as: mysql[xxxxx], but if you change it to mysql.xxxxxx, it works perfect.

Extrange situation....

[MrKen]

Thanks for reporting back with the good news.

Actually I just enabled the UserParameters, linked the template, and guess what? Not supported by ZABBIX agent. (That was before you replied)

It's late Friday afternoon here, so I was going to leave it till Monday, but now you managed to solve the problem. Great!!

MrKen