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

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

      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).

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

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

              Created:
              Updated:
              Resolved: