ODBC only possible with Server and Proxy?

[hutknansen]

Hi everyone,

i just tried to monitor an SQL query on a Zabbix agent monitored host with ODBC and noticed the error in Zabbix Server "Could not find DSN".

So i tried to put the ODBC configuration on the server and the error message changed to "Can't connect to unknown database." So as it seems every ODBC select or discovery is done from the server and not from the Zabbix agent. Is that right? Or am i doing something wrong?

Thanks for your help!

[FelipeVieira]

If you want monitoring your host by zabbix-proxy, you need setup the unixODBC files in the proxy, not in the server.

You would like to use "isql -v <DSN>" for test your database conection using the ODBC before configure the item/template.

[hutknansen]

Yes i understand that, but the Zabbix agent is not able to do ODBC queries?