Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-15592

Frontend allows creating ODBC items without parameters

XMLWordPrintable

    • Sprint 49 (Feb 2019), Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
    • 0.125

      Steps to reproduce:

      1. Create a host
      2. Create an item
        1. Select "Database monitor" as a type
        2. Select "db.odbc.select[<unique short description>,<dsn>]" key
        3. Remove both parameters (frontend states that these are optional)
        4. Fill other required fields

      Result:

      Frontend creates an item without any error message.

      When Zabbix starts to monitor created item, following line appears in Zabbix server's log:

       28861:20190205:110746.032 item "Host:db.odbc.select" became not supported: Invalid number of parameters.
      

      Expected:

      Even if description is optional, dsn parameter is mandatory. Frontend should not mark it as optional.

      https://www.zabbix.com/documentation/current/manual/config/items/itemtypes/odbc_checks states that description field is mandatory as well (i.e., no "<>" symbols there).

      Item key "db.odbc.discovery" is confusing as well. Documentation (https://www.zabbix.com/documentation/4.0/manual/discovery/low_level_discovery/sql_queries) states that both parameters are optional.

            Miks.Kronkalns Miks Kronkalns
            asitals Andrejs Sitals (Inactive)
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: