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

MSSQL ODBC monitoring doesn't work after upgrading from 2.4.7 to 3.2.3

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 3.2.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      RHEL6 - 2.6.32-642.13.1.el6.x86_64 with RHSCL repo.
      PostgreSQL 9.4.9

      Description

      After upgrade zabbix from version 2.4.7 to 3.2.3 ODBC dircovering doesn't works.
      In frontend view discoveru rule makes unsupported
      In zabbix server log i can see

      17476:20170131:184454.041 odbc_DBfetch() fetched [0 col (-10)]: '{'
      

      From isql CLI all worksas expected

      +---------------------------------------+
      | Connected!                            |
      |                                       |
      | sql-statement                         |
      | help [tablename]                      |
      | quit                                  |
      |                                       |
      +---------------------------------------+
      SQL> select '{"data":[', (SELECT STUFF((SELECT ',' + '{"{#DBNAME}":"' + [Name] + '"}' FROM master..sysdatabases ORDER BY [Name] FOR XML PATH('')), 1, 1, '')) ,']}' FOR XML PATH('')
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | XML_F52E2B61-18A1-11d1-B105-00805F49916B                                                                                                                                                                                                                                                                    |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | {"data":[{"{#DBNAME}":"confluence_it"},{"{#DBNAME}":"icap_it"},{"{#DBNAME}":"jira_it"},{"{#DBNAME}":"master"},{"{#DBNAME}":"model"},{"{#DBNAME}":"msdb"},{"{#DBNAME}":"tempdb"}]}                                                                                                                           |
      +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      SQLRowCount returns 1
      1 rows fetched
      

      my /etc/odbc.ini

      [CBR4T]
      Driver = FreeTDS
      Server = fsrumosdt0031
      PORT = 1442
      TDS_Version = 8.0
      

      my locale

      locale
      LANG=en_US.UTF-8
      LC_CTYPE="en_US.UTF-8"
      LC_NUMERIC="en_US.UTF-8"
      LC_TIME="en_US.UTF-8"
      LC_COLLATE="en_US.UTF-8"
      LC_MONETARY="en_US.UTF-8"
      LC_MESSAGES="en_US.UTF-8"
      LC_PAPER="en_US.UTF-8"
      LC_NAME="en_US.UTF-8"
      LC_ADDRESS="en_US.UTF-8"
      LC_TELEPHONE="en_US.UTF-8"
      LC_MEASUREMENT="en_US.UTF-8"
      LC_IDENTIFICATION="en_US.UTF-8"
      LC_ALL=
      

      sorry for english mistakes and thanks in advance

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              amaslennikov Aleksandr Maslennikov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: