CODEWITHSUNDEEP
oracle-databaseenvironment-variablesunixodbczabbix
Lassi Autio
Lassi Autio

Reputation: 1239

Environment variables in Zabbix's host

I want to have a graph from queries to Oracle. I can connect to remote Oracle with isql and sqlplus. But in Zabbix host has an error:

Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]|

I guess Zabbix needs (updated) LD_LIBRARY_PATH and PATH environment variables which I have edited in my command line.

How can I set environment variables in Zabbix's host?

Upvotes: 0

Views: 2076

Answers (1)

Lassi Autio
Lassi Autio

Reputation: 1239

After all this problem had nothing to do with environment variables, it even worked without them. My problem was that I configured odbc.ini and odbcinst.ini files from /usr/local/etc. That is the place isql/sqlplus uses them and odbcinst -j command shows them to be. But Zabbix uses them from /etc. (I found this tip somewhere from Stackoverflow or like that web page but can't find it anymore)

Upvotes: 1

Related Questions