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

Zabbix 5.0.2 MSSQL Official Template ZBX_NOTSUPPORTED: Unsupported item key.

XMLWordPrintable

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

      I am setting up the official template:

      https://www.zabbix.com/ru/integrations/microsoft_sql#tab:official1

      Specified login and password in the macros 

      Created a login and password on the MSSQL server
      I waited a while, but the values are not coming from the server.
      Then through zabbix get tried to get the values and got the following result:

       zabbix_get -s vrs-serv-db-01 -k mssql.uptime
      ZBX_NOTSUPPORTED: Unsupported item key.
      

      Driver installed: 

      
      [ODBC Driver 17 for SQL Server]
      Description=Microsoft ODBC Driver 17 for SQL Server
      Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1
      UsageCount=2
      
       
      
      sqlcmd test OK
      
      sqlcmd -Svrs-serv-db-01 -Uzabbix -Pzabbix
      
      

       

      What else needs to be configured to get values from the database server?

            zabbix.support Zabbix Support Team
            it9 Alex
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: