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
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