Advertising:
Configuracion de ODBC en Zabbix 7.0: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Monitorizacion por ODBC== # dnf install -y unixODBC # dnf install -y mariadb-connector-odbc # dnf install -y postgresql-odbc # dnf install -y epel-release # dnf install -y freetds # dnf install -y https://download.oracle.com/otn_software/linux/instantclient/1919000/oracle-instantclient19.19-basic-19.19.0.0.0-1.el9.x86_64.rpm # dnf install -y https://download.oracle.com/otn_software/linux/instantclient/1919000/oracle-instantclient19.19-odbc-19.19.0.0.0-1.el9.x86_...") |
No edit summary |
||
Line 1: | Line 1: | ||
== | # 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] | [Oracle ODBC driver] | ||
Description = Oracle ODBC driver | Description = Oracle ODBC driver | ||
Line 18: | Line 52: | ||
Driver Logging = 7 | 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 |
Revision as of 13:05, 17 August 2024
# 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