UserParameter=mysql not working with 1.6

[clubbing80s]

Hi
I have installed zabbix 1.6 on my server and created a template for mysql items
except that the mysql items report back as "not supported" ..

The Items are configured as per the manual ..

so what could I have missed


all the commands can be run as the zabbix user
zabbix_agentd.conf
UserParameter=mysql.ping,mysqladmin -uroot ping|grep alive|wc -l
UserParameter=mysql.uptime,mysqladmin -uroot status|cut -f2 -d":"|cut -f1 -d"T"
UserParameter=mysql.threads,mysqladmin -uroot status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql.questions,mysqladmin -uroot status|cut -f4 -d":"|cut -f1 -d"S"
UserParameter=mysql.slowqueries,mysqladmin -uroot status|cut -f5 -d":"|cut -f1 -d"O"
UserParameter=mysql.qps,mysqladmin -uroot status|cut -f9 -d":"
UserParameter=mysql.version,mysql -V

[sybex]

Hi, ..

i think the Items in the frontend are wrong configured.

They have to be like this:

mysql.ping

in my zabbix 1.6 they was like this: mysql[ping]

check this ...

after the change in the frontend the items are working fine in my zabbix.

[clubbing80s]

this is my item .... cant see a reason for it not working ??


Description MySQL is alive
Type ZABBIX Agent
Key mysql[ping]
Type of information numeric (float)
Units
Use multiplier dont use
Update interval (in sec) 60
Flexible intervals (sec) No flexible intervals
New flexible interval Delay 50 Period 1-7,00:00-23:59
Keep history (in days) 90
Keep trends (in days) 365
Status Active
Store value As is

[sybex]

Hi, ...

try to change the Key from:

mysql[ping]

to

mysql.ping

because that [] is meaning a variable value and needs in UserParameter a value like this mysql[*]

and only a point mysql.ping means directly a function, so you have configure UserParameter like this mysql.ping


someone have to correct me if i'm wrong ...

[Kees Jan Koster]

Well, I ran into a similar issue. I could not even get trivial user parameters to work, not even when testing locally (i.e. no server involved).

Here is the bug report.

Kees Jan

[linuxdan]

Same issue.

I'm having the same issue as Kees. Does anyone know of a good way to test user parameters? I'm running 1.6.1 on RHEL4. Oh and linking to a bug report that requires a login isn't all that helpful.

Well, I ran into a similar issue. I could not even get trivial user parameters to work, not even when testing locally (i.e. no server involved).

Here is the bug report.

Kees Jan

[tchjts1]

*bump*

Anyone getting their mysql userparameters to work in 1.6.1?

I have them configured the same in the frontend as in the userparameter statements, but no go.

[tchjts1]

Anyone? Beuhler...Beuhler...

[Fatima R R Tonon]

Problems with UserParameter

Yes, I had problems with the multiple parameters.
Zabbix Configuration file:

UserParameter=tot[*],/etc/zabbix/scripts/processa_quota.sh $1 $2 $3 $4

Implementation of command using shell

[root@corp]# /usr/local/zabbix-1.6.1/bin/zabbix_agentd -t tot[0,0,100,pr.ex.br]
tot [m|ZBX_NOTSUPPORTED]

This script worked in version 1.4.6 !!!

[bogdar]

I uncomment just an example line:

UserParameter=system.test,who|wc -l

and executed test:

~# zabbix_agentd -t system.test
system.test [m|ZBX_NOTSUPPORTED]

~# grep zabbix /etc/passwd
zabbix:x:1004:1004:Zabbix:/dev/null:/dev/null

[richlv]

see http://www.zabbix.com/forum/showthread.php?p=41852 for my attempts at finding out "wtf".