Configuracion de ODBC en Zabbix 7.0

# cat /etc/odbcinst.ini 
# Example driver definitions

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description     = ODBC for PostgreSQL
# Driver          = /usr/lib/psqlodbcw.so
# Setup           = /usr/lib/libodbcpsqlS.so
Driver64        = /usr/lib64/psqlodbcw.so
Setup64         = /usr/lib64/libodbcpsqlS.so.2
FileUsage       = 1

# Driver from the mysql-connector-odbc package in Fedora >=29
# Setup from the unixODBC package
[MySQL]
Description     = ODBC for MySQL 8
# mysql-connector-odbc package provides shared libraries with "w" or "a" suffix.
# 'w' stands for 'wide' or 'unicode' character set, 'a' stands for 'ANSI'
# Symlinks used in the configuration below lead to the 'w' variant by default
# Driver          = /usr/lib/libmyodbc8.so
Driver64        = /usr/lib64/libmyodbc8w.so
FileUsage       = 1


# Driver from the freetds-libs package
# Setup from the unixODBC package
[FreeTDS]
Description     = Free Sybase & MS SQL Driver
# Driver          = /usr/lib/libtdsodbc.so
# Setup           = /usr/lib/libtdsS.so
Driver64        = /usr/lib64/libtdsodbc.so
Setup64         = /usr/lib64/libtdsS.so.2
Port            = 1433


# Driver from the mariadb-connector-odbc package
# Setup from the unixODBC package
[MariaDB]
Description     = ODBC for MariaDB
# Driver          = /usr/lib/libmaodbc.so
Driver64        = /usr/lib64/libmaodbc.so
FileUsage       = 1

[Oracle ODBC driver]
Description     = Oracle ODBC driver
Driver          = /usr/lib/oracle/19.19/client64/lib/libsqora.so.19.1
Setup           =
FileUsage       =
CPTimeout       =
CPReuse         =
Driver Logging  = 7

Verificamos los drivers instalados

# repoquery --installed -l freetds-libs | egrep "*.so$"
/usr/lib64/libtdsodbc.so

# repoquery --installed -l unixODBC | egrep "*.so$"
/usr/lib64/unixODBC/libodbcmyS.so
/usr/lib64/unixODBC/libodbcpsqlS.so
/usr/lib64/unixODBC/libtdsS.so

# repoquery --installed -l mariadb-connector-odbc | egrep "*.so$"
/usr/lib64/libmaodbc.so

# repoquery --installed -l postgresql-odbc | egrep "*.so$"
/usr/lib64/psqlodbc.so
/usr/lib64/psqlodbca.so
/usr/lib64/psqlodbcw.so

# repoquery --installed -l mysql-connector-odbc | egrep "*.so$"
/usr/lib64/libmyodbc8a.so
/usr/lib64/libmyodbc8w.so