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 |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
# 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 | |||
[Oracle | |||
[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 | 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 | ||
| Line 18: | Line 41: | ||
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 | |||
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