Why didn't MySQL Template DB items work on a Linux Slackware server?

[cesarsj]

The MySQL DB Template, present in Zabbix 4.X; Is it for Linux?

Following are the relative messages I found in zabbix_server.log:

32283:20190918:143338.453 item "server:mysql.ping" became not supported: Unsupported item key.
32283:20190918:143339.470 item "server:mysql.status[Bytes_received]" became not supported: Unsupported item key.
32283:20190918:143340.477 item "server:mysql.status[Bytes_sent]" became not supported: Unsupported item key.
32283:20190918:143341.541 item "server:mysql.status[Com_begin]" became not supported: Unsupported item key.
32283:20190918:143342.546 item "server:mysql.status[Com_commit]" became not supported: Unsupported item key.
32283:20190918:143343.563 item "server:mysql.status[Com_delete]" became not supported: Unsupported item key.
32283:20190918:143344.586 item "server:mysql.status[Com_insert]" became not supported: Unsupported item key.
32283:20190918:143345.709 item "server:mysql.status[Com_rollback]" became not supported: Unsupported item key.
32283:20190918:143346.721 item "server:mysql.status[Com_select]" became not supported: Unsupported item key.
32283:20190918:143347.734 item "server:mysql.status[Com_update]" became not supported: Unsupported item key.
32283:20190918:143348.762 item "server:mysql.status[Questions]" became not supported: Unsupported item key.
32283:20190918:143350.142 item "server:mysql.status[Slow_queries]" became not supported: Unsupported item key.
32283:20190918:143351.171 item "server:mysql.status[Uptime]" became not supported: Unsupported item key.
32284:20190918:143501.062 item "server:mysql.version" became not supported: Unsupported item key.

OS: Slackware X64
Kernel: 4.4.172
MySQL 15.1 . 10.0.26-MariaDB using readline 5.1

By the way, I would like to monitor the buffer pool, and none of these items strike me as correct. How could I monitor the buffer pool in Zabbix?

[gbiondi]

Hi,
from Genoa, Italy.. me too...

[Atsushi]

4.X is 4.0, 4.2 or 4.4?
Suppose you are using a template "Template DB MySQL" from 4.0 or 4.2 to infer from the logs.
Is a file in which UserParameter for using “Template DB MySQL” is set in the directory included in the configuration file of Zabbix agent?
Is the environment configured so that the commands used in UserParameter can be executed without a password by placing a .my.cnf file in the home directory of the zabbix user?

ex. /var/lib/zabbix/.my.cnf

[client]
user = zabbix
password = password

Check the contents of the file(userparameter_mysql.conf).

[cesarsj]

I created .my.cnf in /etc/zabbix/, I put the three parameters in this file, I also copied useparameter_mysql.conf to /etc/zabbix/zabbix_agentd/ and it still isn't working yet. What else may be missing?

[Atsushi]

Check the log file. There should be a message that can help you identify the cause.