mysql - ZBX_NOTSUPPORTED

[houseofmore]

I've never been able to get Zabbix to monitor our mysql server -- everything else works fine.

The Items config shows: "Not supported by ZABBIX agent" beside all of the mysql entries. When I enable it, I see:

0117:224053 Requested [mysql[threads]]
13906:20080117:224053 Sending back [ZBX_NOTSUPPORTED]

Etc, in the agent log.

Yet, on the server, as zabbix, if I do:

`/usr/sbin/zabbix_agentd -t mysql.threads`

It works.

All of the mysql commands are uncommented in the zabbix_agentd.conf, remote commands and active checks are enabled.

What am I missing? Does anyone have Mysql checks going on?

We're using 1.4.2 on debian. Thanks!
-Jason

[mjb]

Edit the item key, it should be mysql.thread

[Hichhiker]

I found that many of the mysql monitoring examples come broken out of the box because the output contains a space before a number. I found adding

| tr -d " "

at the end of the line helps. Although personally I have ended up replacing the examples with an active checks script triggered by agentd check that runs "mysqladmin status" once instead of running it for every variable separately

If anyone cares, I can post it.

[siemt74]

Hi,

I got this problem, to resolve it you must edit item keys like that:

mysql[ping] => mysql.ping

[Robert Wagnon]

Please post active check

Hichhiker,

Please post your status check. I'm very interested.

[Hichhiker]

k, here goes:

Add following lines to zabbix_agentd.conf (this is instead of default code)

UserParameter=mysql.version,mysql -V
UserParameter=mysql.status,~zabbix/bin/mysql-status-active

The zip file contains two files, place the into ~zabbix/bin/ directory and make sure they are executable. BTW, I did not write "zabbix_sender.sh", I found it somewhere on this forum - however I did need to modify it to make it work.

Then import the xml file into zabbix and add new template to the host you are monitoring. NOTE: If your hostname in zabbix configuration does not match hostname in UNIX, modify "zabbix_sender.sh" to match.

The way this setup works is that regular passive agent check triggers a script that generates active checks for all mysql parameters and then sends them as active checks. So you will need ability to generate connections in both directions between mysql server and zabbix box.

HTH,

-HH

[rexzhen]

I have the same Issue.

None UserParameter is working when I am testing use zabbix_agentd

for example, after i edit the /etc/zabbix/zabbix_agentd_conf
#zabbix_agentd -t system.test
system.test [m|ZBX_NOTSUPPORTED]

#zabbix_agentd -t mysql.version
mysql.version [m|ZBX_NOTSUPPORTED]


any clue?

Maybe my zabbix_agentd does not take the configure file uner /etc/zabbix ?

[rexzhen]

I use zabbix-1.6.2 under fedora

seam like not the configure file location issue, otherwise the server will not get any info from the agent. all other function is working fine except the UserParameter