No support for Application.MySQL in 1.1beta6

[krusty]

Hi, i want to use the items from Application.MySQL. I have added the items to my zabbixserver host to get infromation about the mysql database. But even i changed the status to monitored and i refesh the page i got not supported. Have anyone an idea why?
For your infromation i uncomment the following lines in zabbix_agentd.conf

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

[Alexei]

Have you restarted ZABBIX agent?

[krusty]

Have you restarted ZABBIX agent?

Yes, do you mean zabbix_agent oder zabbix_agentd? I restarted zabbix_agentd.

[Alexei]

Yes, I mean zabbix_agentd. Can you run these command in command line under user 'zabbix'?

[krusty]

i got this error

zabbix@suse:/var/lib/mysql> /etc/init.d/zabbix_agentd start
Starting zabbix_agentd startproc: cannot stat /proc/24995/exe: Permission denied
                                                                      failed
zabbix@suse:/var/lib/mysql>

but if i look with ps -A the prozesstree, i see that zabbix_agentd is running.

24997 ?        00:00:00 zabbix_agentd
24998 ?        00:00:00 zabbix_agentd
24999 ?        00:00:00 zabbix_agentd
25000 ?        00:00:00 zabbix_agentd
25001 ?        00:00:00 zabbix_agentd
25002 ?        00:00:00 zabbix_agentd

[elkor]

well, that's kind of odd.
can you stop it?

what user are you doing this as? zabbix should be started as root as it assumes the zabbix user after startup.

[krusty]

well, that's kind of odd.
can you stop it?

yes i can stop it but i can't start it.

what user are you doing this as? zabbix should be started as root as it assumes the zabbix user after startup.

i use user zabbix

[elkor]

start it as root (or use sudo to root) and see if you still have problems

[krusty]

yes i have the same problem

[yopito]

No support for Application.MySQL in 1.1beta6: invalid data type

Hello,

I have the same problem with the use of mysql.qps as defined below in zabbix_agentd.conf (this is the default value supplied by the zabbix distribution):

UserParameter=mysql.qps,mysqladmin -uroot status|cut -f9 -d":"

In fact, the zabbix_agentd binary is working nice, but it seems to send this data as string and not as number:

% zabbix_agentd -p |grep "mysql.qps"
mysql.qps                                     [[B]s[/B]| 24.599]

And my ZABBIX server expects "numeric (float)" as data type ....

The same happens with mysql.threads, that make me think that the zabbix_agentd send every UserParameter returns as string datas .....

Does it means that the ZABBIX server does not handle well UserParameter "functions" or is it coming from zabbix_agentd ???

my 0.02 EUR

Regards,

Yopito

[yopito]

Re: No support for Application.MySQL in 1.1beta6: invalid data type

sorry,

I forgot to post the relevant error of zabbix_server in my previous post:

22911:20060217:085457 Type of received value [ 31.904] is not suitable for [mysql.qps@amnesix]

Perharps is it the space " " just before the value (31.904) that let think zabbix server that this is not a numeric (float) value ?

[sfds]

Perharps is it the space " " just before the value (31.904) that let think zabbix server that this is not a numeric (float) value ?

Hello
I solved this problem adding another cut at the end of the lines

Example

UserParameter=mysql.threads,mysqladmin -uroot status|cut -f3 -d":"|cut -f1 -d"Q"| cut -f2 -d" "

It worked for me on FC4 and Zabbix 1.1beta6

[krusty]

i will check it on monday. Thanks for your tip.

[ryanboyce]

Fixed custom User Parameters for MySQL

Using v1.1beta8

The User Parameters for MySQL monitoring in a default install in zabbix_agentd.conf didn't work. To get them to work I had to change them to this:

UserParameter=mysql.ping[*],/usr/local/mysql/bin/mysqladmin -uXXXX -pXXXX ping|grep alive|wc -l]


And then in the front end my key is:
mysql.ping[*]
mysql.slowqueries[*]
etc. etc.