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

db.odbc.discovery not create items

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Workaround proposed
    • Icon: Minor Minor
    • None
    • 3.4.6
    • None
    • None
    • RHEL7, SAP ASE 15.7 DB server, SAP ASE 16.0 client, Zabbix-server-psql 3.4.6

      Steps to reproduce:

      1. Check SQL query for discovery in isql in zabbix user shell, all work good.
      2. Create db.odbc.discovery rule to discover some data from Sybase DB with the query.
      3. Create item prototype to make items by discovery

      Result:
      Discovery runs without errors, but items has not being created.

      Expected:
      Items has been successfully created

      Attachments
      Zabbix-server logfile with loglevel 4.

      Perhaps the problem is caused because the db.odbc.discovery does not process the environment variables. Without the $SYBASE environment variable set, text fields has a blank output.

      Now I'm use an external script as workaround.

        1. isql_query_result.PNG
          isql_query_result.PNG
          23 kB
        2. item_prototype.PNG
          item_prototype.PNG
          40 kB
        3. odbc_discovery.PNG
          odbc_discovery.PNG
          36 kB
        4. odbc_library_linking.png
          odbc_library_linking.png
          10 kB
        5. zabbix_server.log
          18 kB

            Unassigned Unassigned
            areytsman Aleksey Reytsman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: