Zabbix agent 2 oracle plugin custom queries functionality does not work

XMLWordPrintable

    • 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:

      1. Install Zabbix agent 2 7.0.19
      2. 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

            Assignee:
            Zabbix Support Team
            Reporter:
            Jaroslav Vrbicky
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: