Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23208

Mariadb replication with zabbix agent 2

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • None
    • Agent2 plugin (G)
    • 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

            zabbix.support Zabbix Support Team
            stepassia Stefano Passiatore
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: