Ad Widget

Collapse

Error database monitor

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HTC
    Junior Member
    • Mar 2016
    • 3

    #1

    Error database monitor

    Hi

    I'm using Zabbix 2.4.6 Appliance. I want to see the number of records that exist in a database, for example the number of users of Zabbix database, to prove I created an item

    Error Log:
    item "test-SQL:db.odbc.select[sss,test]" became not supported: Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]|

    Error Web Zabbix:
    Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]|

    I'm doing wrong, what it is the problem ?



    Item:
    Type: Database monitor
    Key db.odbc.select(sss,test)
    Username: root
    Password: zabbix
    Sql Query: select count(*) from users
    Type of information: Numeric (unsigned)
    Data type: Decimal

    Zabbix ODBC Enabled

    OdbcUnix config:
    unixODBC 2.3.0
    DRIVERS............: /etc/odbcinst.ini
    SYSTEM DATA SOURCES: /etc/odbc.ini
    FILE DATA SOURCES..: /etc/ODBCDataSources
    USER DATA SOURCES..: /root/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8


    config /etc/odbc.ini
    [test]
    Description=MySql Test database
    Driver=Mysql
    Server=127.0.0.1
    User=root
    Password=zabbix
    Port=3306
    Database=zabbix

    Config: /etc/odbcinst.ini
    [MySql]
    Description=MySql ODBC
    Driver=/usr/lib64/libmyodbc5.so



    Thanks
Working...