MySQL monitoring error

[vsmjoao]

Hi, I'm trying to monitor a MySQL database using the standard template that Zabbix provides. However, I am experiencing some issues when I go to collect the data.

I followed the entire tutorial on the Zabbix website (https://www.zabbix.com/br/integratio...7YMDTECwcScSOw) and it still doesn't work. When I do the collection test through mysql.ping, the error is returned: "Item does not allow parameters."


I am using the following specifications to host the MySQL database:

CentOS Linux release 8.4.2105
mysql.x86_64 8.0.26-1.module_el8.4.0+915+de215114

mysql-common.x86_64 8.0.26-1.module_el8.4.0+915+de215114
mysql-errmsg.x86_64 8.0.26-1.module_el8.4.0+915+de215114
mysql-server.x86_64 8.0.26-1.module_el8.4.0+915+de215114
php-mysqlnd.x86_64 7.4.24-1.el8.remi
php-pecl-mysql.x86_64 1.0.0-0.23.20190415.d7643af.el8.remi.7.4

[tim.mooney]

Hi, I'm trying to monitor a MySQL database using the standard template that Zabbix provides. However, I am experiencing some issues when I go to collect the data.

I followed the entire tutorial on the Zabbix website (https://www.zabbix.com/br/integratio...7YMDTECwcScSOw) and it still doesn't work. When I do the collection test through mysql.ping, the error is returned: "Item does not allow parameters."

The error message "Item does not allow parameters" strongly points to some kind of error with how the custom item type "mysql.ping" is configured. Based on the instructions you followed, that item (and probably some others) would be defined in the "template_db_mysql.conf" that you copied into /etc/zabbix/zabbix_agentd.d/ in Step 2. Verify that file is present on the client in question, verify it's readable by the zabbix agent. Make sure the agent on that system has been restarted, as recommended in Step 2.

[cyber]

If it already says "Item does not allow parameters", then agent knows about UserParameter or it would say "Unsupported item key".
So it something with the Userparameter, that it does not like...
Last time I had to use UserParameters (but it was a while ago), I also had to add "UnsafeUserParameters=1" to agent config also, or it would fail with those wildcards...

[vsmjoao]

I updated my Zabbix Agent to version 6.0 and the connection test went well. However, on Zabbix Server it still doesn't work. I think it must be something related to the version. My Zabbix Server is at Version 5.4.8. Is there any way around this?