-
Incident report
-
Resolution: Duplicate
-
Major
-
None
-
5.0.2
-
None
-
Ubuntu 20.04
Zabbix 5.0.2
ODBCInst Microsoft ODBC Driver 17 for SQL Server libmsodbcsql-17.5.so.2.1
MySQL DB - 8.0.21-0ubuntu0.20.04.3
Steps to reproduce:
- Add Host - Hostname Azure SQL Managed Instance (Not Azure SQL) xxxxx.xxxxx.database.windows.net
- Add Template "Template DB MSSQL by ODBC Template DB MSSQL by ODBC"
- Set Macros {$MSSQL.DSN}, {$MSSQL.USER}, {$MSSQL.PASSWORD}, {$MSSQL.PORT}
- Install MS ODBC driver from Microsoft repository
- Confirm odbcinst.ini entry for [ODBC Driver 17 for SQL Server] --> add Same entry as [mssql]:
- [mssql]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
UsageCount=1 - Add odbc.ini entry with SQL Managed Instance server name:
- sql###########xxxxxtest
Description = MSSQL MI databases
Driver = mssql
server = xxx######xxx###.xxxxxxxxxxxx.database.windows.net
User = xxxxxx
Password = xxxxxx
Port = 1433
Database = sql###########xxxxxtest
Result:
The Only key that works are:
mssql.db.state
db.odbc.get
mssql.uptime
mssql.version
net.tcp.service
Running Template Query "Get Performance Counters"
gives AU Cleanup Values, but no Instance_name
Query returns 5528 rows. attached is CSV of the result of that query.
Zabbix_server.log is same error message as image
Expected:
data is should be collected.
Please let me know if there is anything else I can try. I suspect it could be the Different version or Azure SQL Managed Instance (Ref: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview)