mysql.status[*] giving null values

[isaacpm]

Hi,

I'm trying to get the MySQL UserParameter working and I'm not being very successful.

Installed latest Zabbix a few days ago.

I've got two main sections in the userparameter_mysql.conf.
The default ones:

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -uzabbix -N | awk '{print $2}'

A second one with the mysql.size[*] and the custom ones which I've got from the documentation and forums, and I can't paste or it doesn't allow me to post the message because of too many links......


The only two parameters that work are the version and ping, the other custom ones don't even appear in the items section.
The default ones with the[*] part are not working, appearing as disabled because of a null value provided.
I've modified the default parameter, which wasn't working at first to the above one.
Which gives me a result when I substitute the $1 by a value from the items, ie: Bytes_received

I am not sure on what to check next, other than start adding the other items from the custom userparameters. But I'd like to keep the default status[*] one as it seems tidier.
This is the output of the execution of a status command:



Any ideas?

Thanks

[tchjts1]

This post should be able to help you: https://www.zabbix.com/forum/showthread.php?t=40870