Help with ODBC needed (odbc oracle, possible php zabbix error)

[frglgcls]

Hi, currently im trying to configure odbc in linux server with zabbix in order to monitor several oracle databases and Im having several issues (quite hard).

I have everything ok, isql $DSN works ok and I can log into the database from shell using isql to test as its explained at https://www.zabbix.com/documentation...es/odbc_checks

Problem is that zabbix php seems to be not able to connect to oracle, I have inserted at the php code an exec in order to see if isql works from here and it works :
$output_exec = shell_exec('isql -v ORACLEDATASOURCE');
echo "<pre>$output_exec</pre>";

I can see the output of connected

But when I set a item of type db.odbc.select[archivelog.Query,ORACLEDATASOURCE] I see at Status column the statement not supported and the info column says : Cannot connect to ODBC DSN:[SQL_ERROR]:[08004][12154][[unixODBC][Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
]|

Seems like zabbix php is not able to connect because it does not find the definitions for the DATASOURCES, however its able to exec the isql correctly, some help here please ? Seems like some zabbix error

[frglgcls]

No one uses zabbix via ODBC for oracle ? I would really apreciate help on that

[ingus.vilnis]

Hello and welcome to Zabbix forums!

Just from top of my head check that you have all ODBC drivers and connectors installed for Oracle. For MySQL you need "mysql-connector-odbc" package. "php-odbc" could also be.

Try with troubleshooting that way.

Best Regards,
Ingus

[mark.chan]

i got the same problem and i yum install php-odbc, it doesn't work...