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

Monitoring over ODBC is not working on Zabbix 6.0 LTS

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.0.5
    • Templates (T)
    • ODBC

      Steps to reproduce:

      1. Installation of Zabbix 6.0 LTS based on installation instruction with configration:
        1. Zabbix Version: 6.0 LTS
        2. OS Distribution: Cent OS
        3. OS Version: 8 Stream
        4. Database: MySQL
        5. Web Server: Apache
      2. Install template based on instructions: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_odbc?at=release/6.0
      3. Configure odbc driver to use Microsoft Driver
      4. Add to host with MSSQL ODBC Template
      5. Test connection from Zabbix server over isql is successful (isql -v Sx***.domain.local zbx_monitor password). 
      6. Open Host (Sx**.domain.local) with SQL template attached in Zabbix  (Configuration->Sx**.domain.local) -> Discovery -> MSSQL by ODBCDatabase discovery and click on Test button and Get Values button with error : 
      7. Cannot connect to ODBC DSN: [SQL_ERROR]:[HYT00][0][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x271D]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishin]
      8. Same issue shows also with Driver 18  or with FreeTDS even isql works correctly.

      Result:
      Query over Zabbix ends with error even ODBC is working as i can connect to the same server over isql.

      Expected:
      When i tried to install Zabbix 5.0 LTS ODBC query with Get Values button was successful. 

        1. odbc.ini.png
          odbc.ini.png
          3 kB
        2. odbcinst.ini.png
          odbcinst.ini.png
          4 kB
        3. zabbix_test1_result.png
          zabbix_test1_result.png
          24 kB
        4. zabbix_test1.png
          zabbix_test1.png
          17 kB

            zabbix.support Zabbix Support Team
            martinsindler Martin Sindler
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: