-
Problem report
-
Resolution: Commercial support required
-
Trivial
-
None
-
6.0.42
Steps to reproduce:
- Deploy zabbix-agent 5.2
- Install ODBC client unixODBC 2.3.11 in Zabbix Server
- Configure driver mysql
- Apply template in host, but don´t work
Result:
when trying to connect to the mysql database via the web interface, it returns an error.
- Cannot connect to ODBC DSN: [SQL_ERROR]:[IM005][0][[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed]|[HY000][517][[unixODBC][MySQL][ODBC 9.0(a) Driver]Wrong libmysqlclient library version: 30317. MyODBC needs at least version: 40100]
it connects from the server console without any problems
odbcinst -j
unixODBC 2.3.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
isql -v test
---------------------------------------
| Connected! |
| sql-statement |
| help [tablename] |
| echo [string] |
| quit |
---------------------------------------
SQL>
The MSSQL Server it´s in a windows Server,
Please, What can I do to resolver this problem?
Thanks.