Database monitoring and ODBC permissions

[Eithco]

I set up a Database monitor Item with the key being db.odbc.select["response_time",eyalora]

and I'm getting it as Not supported with this error:

Cannot connect to ODBC DSN:[SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib' : file not found]|

My ODBC is working when I sudo it, and I'm wondering if this is a permissions issue?

What is the user Zabbix is installed under? My own user? (I'm running it on Ubuntu.) But the ownder of /usr/lib is root.

Am I on the right track? What is the solution?

[akbar415]

Do you have configured this two files?
odbcinst.ini
odbc.ini

[Colttt]

do you compile zabbix with odbc-support?

[Eithco]

Colttt -- I did not. I installed unixODBC separately.

akbar415 -- I did configure them. However, there was a mixture between two locations:

Zabbix was looking for odbc.ini and odbcinst.ini in /etc/ while isql was looking for it in /usr/local/etc.

I was modifying the copies in /usr/local/etc and once I realized that zabbix only sees it in /etc/ it started working.

The best solution is probably to link these two copies so that you only have to modify one location.

[Colttt]

Colttt -- I did not. I installed unixODBC separately.

thats the problem you must compile zabbix with odbc-support otherwise it dont work..

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

[mark.chan]

i install the zabbix with the package

https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages

and when i look at the server log, it state the ODBC is ON

but i got the same problem on the frontend:
Cannot connect to ODBC DSN:[SQL_ERROR]:[01000][0][[unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1' : file not found]|

i can link to the database with isql

any suggestion?

[GPegel]

I also had that error about not finding the file. I solved it by adding the LD_LIBRARY_PATH to the environment variables.