Zabbix :: MySQL is not getting performance in graph

[arye]

Hi All,

I have been trying to get Zabbix to monitor MariaDB MySQL.
I have followed instructions as mentioned in several tutorials I found online.. and still can't get any info.
I am using:
CentOS Linux release 7.4.1708 (Core)
Zabbix 3.4.3
On the Zabbix server:
mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1
and also on the secondary monitored server, I have the same.

When I go to graphs - I can't see anything on the two graphs provided with the MySQL template.
MySQL bandwidth and MySQL operations not getting any data at all.

I don't Have firewalld enabled on any server and all the servers are in the same segment.

I have created my.cfg file and added user and password for mysql and mysqladmin command.

I would be happy if someone can tell me where did I went wrong and maybe I did not completed the MySQL configuration as I should have been.

Thanks for your help.
Best,
Arye

[kaspars.mednis]

I have created my.cfg file and added user and password for mysql and mysqladmin command.

have you put this file in zabbix home directory ?

less /etc/passwd | grep zabbix

does zabbix user has read rights on this file ?

can you test is with

su - zabbix

and then

mysql

Regards,
Kaspars

[Pitons]

Hi arye

I think your problem is in path set in
/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

open it and change
HOME=/var/lib/zabbix to HOME=/etc/zabbix

also make shure you create [.my.cnf] at that same folder
/etc/zabbix/.my.cnf

don't forget to restart agent after changes.