5

I can't get every result from the Zabbix default Template App MySQL. The error is:

Not supported by zabbix agent

I already setup zabbix_agent.conf and included my.cnf. What other settings do I need to configure, for Zabbix Agent to monitor MySQL Server?

Sagar
  • 9,456
  • 6
  • 54
  • 96
pico
  • 247
  • 3
  • 9
  • 20
  • What happens when you test a MySQL item using "zabbix_agentd -t ..."? Does it work? Are you using the correct agent configuration file (it should be zabbix_agentd.conf instead of zabbix_agent.conf)? What user parameter definitions have you included there? – asaveljevs Jan 15 '16 at 07:13

1 Answers1

7

  1. Check that your zabbix_server config file is including the /etc/zabbix/zabbix_agentd.d/*.conf :

    vi /etc/zabbix/zabbix_agentd.conf

    (you will find at almost the end of file: Include =/etc/zabbix/zabbix_agentd.d/*.conf)

  2. Check where your zabbix_mysql config is :

    vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

  3. If you'll find it for example: HOME=/var/lib/zabbix then create that directory if it does not exist: 

    mkdir /var/lib/zabbix

  4. change your position to that directory and create/edit .my.cnf file:

    cd /var/lib/zabbix
vim .my.cnf

    add the following : 

    [mysql]
user=zabbix
password=zabbix
host=localhost

[mysqladmin]
user=zabbix
password=zabbix
host=localhost

    Then save.

I presume you already have a mysql username=zabbix and password=zabbix with all privileges.

Restart mysql: 

    service mysqld restart

Now connect to your zabbix gui and check the values coming from mysql (Monitoring--> Latest data)

YellowStrawHatter
  • 856
  • 7
  • 16