Discussion thread for official Zabbix Template DB MySQL

[JulioQc]

Since upgraded MySQL from 8.0 to 8.4.2 LTS the key

db.odbc.get[get_replication,"{$MYSQL.DSN}"]

returns unsupported

Cannot execute ODBC query: [SQL_ERROR]:[42000][1064][[MySQL][ODBC 9.0(w) Driver][mysqld-8.4.2]You have an error in your SQL syntax; check the manual that corresponds to your MySQL ]

Everything else with the template works fine. I don't use replication so no impact for my context.

Zabbix Server 7.0.4 
Zabbix Agent 7.0.4
ODBC Driver 9 for MySQL Server
MySQL 8.4.2

[dylanb]

Anyone successful in getting the MySQL plugin working with Zabbix Server 7.4, Agent2 7.4 on Debian 12.11? Seems the mysql plugin isn't part of the repo and I can't figure out how to enable it without compiling manually.

[sdousley]

Hi All

I have recently installed the Zabbix Agent (from the Ubuntu 26 repositories) but it didn't create the /var/lib/zabbix-agent folder, so I am unsure exactly as to where I should be putting the

.my.cnf

file.

I tried to create the folder and file, but that didn't seem to help at all. Does anyone know what is needed to get this operational on Ubuntu 26?