Advertising:

Configuracion de ODBC en Zabbix 7.0: Difference between revisions

From Zabbix-ES
Jump to navigation Jump to search
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  # Example driver definitions
  # Example driver definitions
   
   
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
  [PostgreSQL]
  [PostgreSQL]
  Description    = ODBC for PostgreSQL
  Description    = ODBC for PostgreSQL
  # Driver          = /usr/lib/psqlodbcw.so
  Driver          = /usr/lib64/psqlodbcw.so
  # Setup          = /usr/lib/libodbcpsqlS.so
  Setup          = /usr/lib64/libodbcpsqlS.so.2
  Driver64        = /usr/lib64/psqlodbcw.so
  Driver64        = /usr/lib64/psqlodbcw.so
  Setup64        = /usr/lib64/libodbcpsqlS.so.2
  Setup64        = /usr/lib64/libodbcpsqlS.so.2
  FileUsage      = 1
  FileUsage      = 1
   
   
  [MySQL ODBC 8.4 Unicode Driver]
  [MySQL]
  DRIVER=/usr/lib64/libmyodbc8w.so
  DRIVER=/usr/lib64/libmyodbc8w.so
  UsageCount=1  
  UsageCount=1  
   
   
   
   
  # Driver from the freetds-libs package
  [MariaDB]
  # Setup from the unixODBC package
Description    = ODBC for MariaDB
Driver         = /usr/lib64/libmaodbc.so
Driver64        = /usr/lib64/libmaodbc.so
FileUsage      = 1
   
  [FreeTDS]
  [FreeTDS]
  Description    = Free Sybase & MS SQL Driver
  Description    = Free Sybase & MS SQL Driver
  # Driver          = /usr/lib/libtdsodbc.so
  Driver          = /usr/lib64/libtdsodbc.so
  # Setup          = /usr/lib/libtdsS.so
  Setup          = /usr/lib64/libtdsS.so.2
  Driver64        = /usr/lib64/libtdsodbc.so
  Driver64        = /usr/lib64/libtdsodbc.so
  Setup64        = /usr/lib64/libtdsS.so.2
  Setup64        = /usr/lib64/libtdsS.so.2
Line 28: Line 32:
   
   
   
   
# Driver from the mariadb-connector-odbc package
  [Oracle]
# 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
  Description    = Oracle ODBC driver
  Driver          = /usr/lib/oracle/19.19/client64/lib/libsqora.so.19.1
  Driver          = /usr/lib/oracle/19.19/client64/lib/libsqora.so.19.1

Latest revision as of 13:10, 17 August 2024

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

[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib64/psqlodbcw.so
Setup           = /usr/lib64/libodbcpsqlS.so.2
Driver64        = /usr/lib64/psqlodbcw.so
Setup64         = /usr/lib64/libodbcpsqlS.so.2
FileUsage       = 1


[MySQL]
DRIVER=/usr/lib64/libmyodbc8w.so
UsageCount=1 


[MariaDB]
Description     = ODBC for MariaDB
Driver          = /usr/lib64/libmaodbc.so
Driver64        = /usr/lib64/libmaodbc.so
FileUsage       = 1


[FreeTDS]
Description     = Free Sybase & MS SQL Driver
Driver          = /usr/lib64/libtdsodbc.so
Setup           = /usr/lib64/libtdsS.so.2
Driver64        = /usr/lib64/libtdsodbc.so
Setup64         = /usr/lib64/libtdsS.so.2
Port            = 1433


[Oracle]
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