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

    Details

    • Type: Change Request
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0.9
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Environment:
      Ubuntu 12.04

      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

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lewiz Lewis Thompson
              • Votes:
                16 Vote for this issue
                Watchers:
                15 Start watching this issue

                Dates

                • Created:
                  Updated: