-
Problem report
-
Resolution: Won't fix
-
Trivial
-
None
-
None
-
None
I've followed this instructions to configure mysql (mariadb) plugin with Zabbix agent 2: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_agent2?at=release/5.4
Replication discovery doesn't work and I got this error: Cannot fetch data: Error 1227: Access denied; you need (at least one of) the SUPER, SLAVE MONITOR privilege(s) for this operation.
I've configured according to instruction with these macros:
- {$MYSQL.DSN} => unix:/run/mysqld/mysqld.sock
- {$MYSQL.USER} => zbx_monitor
- {$MYSQL.PASSWORD} => *******
No edits on /etc/zabbix/zabbix_agent2.d/plugins.d/mysql.conf file.
Monitoring user has "REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW" privileges and doesn't working. I've tried also to set SUPER and REPLICATION SLAVE privileges but I still got error.
I've MariaDB 10.11. Any suggestion?
Thanks
Stefano