Ad Widget

Collapse

Zabbix 5.2.2 unable to connect to odbc driver

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Singularity
    Member
    • Aug 2020
    • 81

    #1

    Zabbix 5.2.2 unable to connect to odbc driver

    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 |
    | |
    +---------------------------------------+
  • Singularity
    Member
    • Aug 2020
    • 81

    #2
    I figured out the problem.
    By mistake while creating the macro for monitor item, I entered the incorrect value.

    Comment

    Working...