template oracle db : invalid username/password

[doum]

Hi,

I'm trying to monitor our Oracle DB with the template here https://share.zabbix.com/databases/o...late-oracle-db

I didn't understand at first, but a priori if I'm not mistaken the odbc monitoring is not done by the agent on the server, but directly by the zabbix server.

I installed the Oracle client on my Zabbix server
I can connect to the database with sqlplus.
I installed odbcunix on the server.
I can connect to the database with isql (isql DSNNAME)

I associated the template to my host who hosts the database.
I have filled in the 3 macros, {$DSN}, {$DB_USERNAME}, {$DB_PASSWORD}, but I get this error message on all items:

Cannot connect to ODBC DSN:[SQL_ERROR]:[28000][1017][[unixODBC][Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied
]

I tried to track everything I could find on the net.
I filled in the file /etc/default/zabbix-server with the environment variables for oracle

if I do sudo strings -a /proc/<pid>/environment
I do have the variables
ORACLE_HOME=/usr/lib/oracle/19.5/client64
LD_LIBRARY_PATH=/usr/lib/oracle/19.5/client64/lib/
TNS_ADMIN=/usr/lib/oracle/19.5/client64/network/admin

Of course, the username given in the macro is the same as the one in the odbc.ini.

Thanks for your help

[doum]

Forget it, I'm tired.

It's working now.

Is it possible with this template to monitor multiple instances on the same host?