-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Trivial
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Environment:RHEL9.7 VM, Zabbix server/proxy 7.0.6, Zabbix agent 2 7.0.19, Oracle 19c (19.29)
Steps to reproduce:
- Install Zabbix agent 2 7.0.19
- Follow the "custom query feature" instructions from: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/go/plugins/oracle
- $ ls
la /etc/zabbix/alertlog.sql-rw-rr-. 1 zabbix zabbix 29 Jan 14 13:42 /etc/zabbix/alertlog.sql - $ cat /etc/zabbix/alertlog.sql
select name from v$datafile; - $ grep -i "customq" /etc/zabbix/zabbix_agent2.d/plugins.d/oracle.conf### Option: Plugins.Oracle.CustomQueriesPath# Plugins.Oracle.CustomQueriesPath=Plugins.Oracle.CustomQueriesPath=/etc/zabbix
- Zabbix agent 2 restarted
Result:
$ zabbix_agent2 -t oracle.custom.query["tcp://localhost:1521","XXX","XXX","XXX",alertlog]
oracle.custom.query[tcp://localhost:1521,XXX,XXX,XXX,alertlog][m|ZBX_NOTSUPPORTED] [Cannot fetch data.: query "alertlog" not found.]
Expected:
Collected data from a custom query execution