Database monitoring - Item not supported

[Eithco]

I created an item for monitoring a value from a database table but it's "Not supported" without any further explenation, and I can't find any relevant documentation. A "getting started" guide on the various issues would have made Zabbix so, so much friendlier.

Here's my configuration:

Item name: RESPONSE_TIME

Type: Database monitor

Key: db.odbc.select[response_time]

Username: <username>

Password: <password>

SQL Query: select RESPONSE_TIME from dbname.monitor_data order by action_timestamp desc limit 1;

Type of information: Numeric unsigned (the value is a MySql INT)

Interval: 50

Store value: as is

Show value: as is

New Application: <empty>

Applications: none

Populate host inventory field: none

Description: Monitors the response time for the latest action on dbname.monitor_data.

The database was created on the MySql that comes with the Zabbix server installation. So it's sitting on the same host machine.

There is no zabbix agent on the machine. The OS is Ubuntu 12.04.

I installed ODBC but I'm not sure if it's configured correctly or not.

Like I said, the item is "Not supported."

What am I missing?

[Colttt]

odbc must work, otherwise it would not work..

check this:

https://www.zabbix.com/documentation/2.2/manual/config/items/itemtypes/odbc_checks

[Eithco]

Thanks very much for replying, Colttt.

I followd the instructions in https://www.zabbix.com/documentation...es/odbc_checks to install ODBC but sadly something is not connecting right. Here's my info.

In /etc/odbc.ini:

[eyatest]
Description = MySQL connection to 'dbname' database
Driver = MySQL
Database = dbname
Server = localhost
UserName = root
Password = ****
Port = 3306
Socket = /var/lib/mysql/mysql.sock


/etc/odbcinst.ini:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
FileUsage = 1


odbcinst -j:

unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/eyal/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

but when I try to connect using sudo isql -v eyatest I get the following error:

[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified

If by any chance you could help I'd truly appreciate it.

[HTC]

Hi Eihtco
I have the same error, you've solved?

Thanks

[Colttt]

sorry for the very late response ^^

this is my config:
on ubuntu/debian you need (for postgres):
apt-get install unixodbc odbc-postgresql

at first it looks like that the odbc-mysql driver is wrong..

does exist the file/path " /usr/lib/odbc/libmyodbc.so" ?/