ODBC Database Monitor Problem&Suggest

[hexoxssaa]

Hey Guys,

These days I need to monitor serval database server, and setup some odbc monitor items in zabbix.But I found some problem with odbc monitor.

1) Not support for LLD. It needs some triky sql string aggression/concation to make out a json style result. I hope this can process inside zabbix server.

2) When odbc connection fail, the item become not support! And all assosiated triggers are disable! I don't think this is an monitor value suppose to be. We should receive alerts while the query fail but not disable it.

[keithb]

This is the closest I've come to finding anything related to what I'm looking for myself.

I've got an ODBC item set up which works but I need a way to send an alert if the connection fails. As far as I can tell, zabbix itself knows that the connection fails but there's no way to set up a trigger/alert for that. The item just goes into 'Not Supported'.