Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-1961

Database monitor ODBC connections should be dynamic without involving odbc.ini

    XMLWordPrintable

    Details

    • Team:
      Team C
    • Sprint:
      Sprint 61 (Feb 2020), Sprint 62 (Mar 2020)
    • Story Points:
      1

      Description

      Database monitor item types use ODBC as described in "ODBC monitoring" at https://www.zabbix.com/documentation/2.0/manual/config/items/itemtypes/odbc_checks

      Everything in the docs suggest that in order to query a database it must first be defined in the odbc.ini file (usually located in /etc/odbc.ini). This seems to go against the otherwise self-contained nature of Zabbix, particularly host auto discovery and LLD.

      My use case is:

      • LLD rule that runs against a host to get a list of databases
      • Run a set of stored procedures on each of the databases (using ODBC)
      • Alerts based on return values, etc.

      The feature request is therefore that DSNs can be fully defined within Zabbix - e.g. hostname, database, username, password and connector (defined in odbcinst.ini).

        Attachments

        1. zbx_export_hosts.xml
          6 kB
        2. odbc_dsn.diff
          2 kB
        3. change.diff
          5 kB

          Issue Links

            Activity

              People

              Assignee:
              atumilovics Andrejs Tumilovics
              Reporter:
              lewiz Lewis Thompson
              Votes:
              17 Vote for this issue
              Watchers:
              25 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: