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 C
    • Sprint 61 (Feb 2020), Sprint 62 (Mar 2020)
    • 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. change.diff
          5 kB
        2. odbc_dsn.diff
          2 kB
        3. zbx_export_hosts.xml
          6 kB

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: