Advertising:
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 [MySQL ODBC 8.4 Unicode Driver] DRIVER=/usr/lib64/libmyodbc8w.so UsageCount=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