database monitor: odbc connection error

[shinmorpheus]

Hi guys,

i'm tryng to configure some database check on zabbix.
I've configured all 15 ODBC monitoring (zabbix.com) but when i perform the item test i cannotct connect to odbc dsn:

• Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][2066][[unixODBC][MySQL][ODBC 5.3(a) Driver]Connection failed due to wrongly configured compression algorithm]

zabbix server 6.04
ubuntu lts 20.04

remote database mariadb 10.5.15

isql test
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>


odbc.ini
[test]
Description = MySQL test database
Driver = mysql
Server = 10.0.2.111
User = test
Password = pippo123
Port = 3306
Database = test

odbcinst.ini
[mysql2]
Driver=/usr/local/lib/libmyodbc5w.so
UsageCount=1


how i need to configure the compression?

thanks
Daniel

[mysql]
Driver=/usr/local/lib/libmyodbc5a.so
UsageCount=1