The zabbix is unable to get the DSN.
Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found and no default driver specified]
ODBC monitoring is YES
17477:20210223:082423.562 SNMP monitoring: YES
17477:20210223:082423.562 IPMI monitoring: YES
17477:20210223:082423.562 Web monitoring: YES
17477:20210223:082423.562 VMware monitoring: YES
17477:20210223:082423.562 SMTP authentication: YES
17477:20210223:082423.562 ODBC: YES
17477:20210223:082423.562 SSH support: YES
17477:20210223:082423.562 IPv6 support: YES
17477:20210223:082423.562 TLS support: YES
odbcinst -j
unixODBC 2.3.9
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
cat /usr/local/etc/odbcinst.ini
[mysql]
Description = ODBC for MySQL
Driver = /usr/local/lib/libmyodbc5w.so
Setup = /usr/local/lib/libmyodbc5S.so
FileUsage = 1
cat /usr/local/etc/odbcinst.ini
[zabbix]
Description = MySQL test database
Driver = mysql
Server = mysql_server_ip
User = zabbix_username
Password = zabbix_password
Port = 3306
Database = zabbix
isql zabbix
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found and no default driver specified]
ODBC monitoring is YES
17477:20210223:082423.562 SNMP monitoring: YES
17477:20210223:082423.562 IPMI monitoring: YES
17477:20210223:082423.562 Web monitoring: YES
17477:20210223:082423.562 VMware monitoring: YES
17477:20210223:082423.562 SMTP authentication: YES
17477:20210223:082423.562 ODBC: YES
17477:20210223:082423.562 SSH support: YES
17477:20210223:082423.562 IPv6 support: YES
17477:20210223:082423.562 TLS support: YES
odbcinst -j
unixODBC 2.3.9
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
cat /usr/local/etc/odbcinst.ini
[mysql]
Description = ODBC for MySQL
Driver = /usr/local/lib/libmyodbc5w.so
Setup = /usr/local/lib/libmyodbc5S.so
FileUsage = 1
cat /usr/local/etc/odbcinst.ini
[zabbix]
Description = MySQL test database
Driver = mysql
Server = mysql_server_ip
User = zabbix_username
Password = zabbix_password
Port = 3306
Database = zabbix
isql zabbix
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
Comment