Database monitoring with unixODBC (mysql)

[Timoteo]

Hi,

I'm trying to monitor a MySQL DB running on a linux client. I've followed these instructions exactly:

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

I'm running Zabbix server 2.0.8 on CentOS 6.4.
I can access the remote DB via isql with no issues.
I set up a 'database monitoring' item for the host in Zabbix and a trigger to no avail.
The item doesn't go to 'unsupported', it stays 'enabled' and the trigger never fires off an action, even if I change the trigger to obviously fail.

With verbose logging on the server, I get this:
In substitute_key_macros() data:'db.odbc.select[mysql]'
End of substitute_key_macros():SUCCEED data:'db.odbc.select[mysql]'
In get_value() key:'db.odbc.select[mysql]'
In get_value_db() key_orig:'db.odbc.select[mysql]'
In odbc_DBconnect() db_dsn:'MySQL' user:''
End of odbc_DBconnect():SUCCEED
In odbc_DBselect() query:'select count(*) from mysql;'

It never returns a query SUCCEED, like I'm expecting.

Any ideas on why my item and query are hanging, even though isql goes right through?
Thanks!

[ghoulich]

I've got the same problem as you described, and google doesn't give any help ...