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

ODBC item unsupported after upgrading to 3.2

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.2.0, 3.2.1
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Labels:
      None
    • Environment:
      Server: Centos 7
      Proxy: 6
      Database beeing accessed via ODBC: postgresql-9.2.15-1.el7_2.x86_64
      ODBC version on Proxy: unixODBC-2.2.14-14.el6.i686, postgresql-odbc-08.04.0200-1.el6.x86_64

      Description

      I had an ODBC discovery configured this way:

      db.odbc.discovery[{$BAREOS_DBDSN}.discovery,{$BAREOS_DBDSN}]
      Query: select name as client,clientid from client;
      

      Discovered items:

      db.odbc.select[{$BAREOS_DBDSN}.{#CLIENT}.jobstatus,{$BAREOS_DBDSN}]
      Query: select jobstatus from job where clientid={#CLIENTID} and type='B' order by endtime desc limit 1;
      

      After upgrading to 3.2.0 all the discovered items went unsupported with the following error:

      Cannot execute ODBC query:[SQL_ERROR]:[07002][32][The # of binded parameters < the # of parameter markers]|
      

      odbc.ini is configured this way:

      [bareos-srvbkp]
      Description         = PostgreSQL connection to XXXXXXX
      Driver              = PostgreSQL
      Database            = bareos
      Servername          = 10.254.99.100
      UserName            = bareos
      Password            = XXXXXXX
      Port                = 5432
      #Protocol            = 9.3
      ReadOnly            = No
      RowVersioning       = No
      ShowSystemTables    = No
      ConnSettings        =
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                c.mammoli Cristian Mammoli
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: