Hello,
We have couple of servers monitored with mssql and odbc discovery and it is working fine on the default MS SQL instance on port 1433.
Now, we need to monitor one more DB instance on each server which listens on the non default port. We have setup odbc.ini like this:
[DB01]
Driver = ODBC Driver 13 for SQL Server
Description = DB-01 Server
Server = 10.0.9.5
Port = 1433
[DB01-1434]
Driver = ODBC Driver 13 for SQL Server
Description = DB-01 Server
Server = 10.0.9.5\\INTA,1434
#Port = 1434
When testing with isql, I can connect to the correct instance and see all the databases on each instance.
When looking at the latest data on that host, I can see that I get the same results for each odbc instance, ie we get the same databases listed for both instances (which is clearly not the case and isql client confirms it), and the values for the databases is 7 (DB does not exists on server), which is obvious, because those DBs are running on another instance.
I have to mention, we did a new template for the second instance which uses their own macros {$ODBC2}, {$MSSQL_USER2}, {$MSSQL_PASSWORD2}, so no interference should happen here. On this template there is only discovery rule and item prototype with key db.odbc.select[{#DBNAME}_state,{$ODBC2}], and I have also tried adding a new host with only this new template added, but it still somehow gets the databases from the wrong instance (default one).
Did I made a mistake somewhere? I have double checked everything, even added a new userparameter in zabbix agent for discovery (mssql.db.discovery2) so the key is different.than the original one.
We are running template with powershell discoveryzabbix-version:
# zabbix_server -V
zabbix_server (Zabbix) 3.0.10
Revision 70208 14 July 2017, compilation time: Jul 17 2017 07:42:06
Can anybody point me in some direction where to look for errors?
If you need any other info, let me know.
Regards!
We have couple of servers monitored with mssql and odbc discovery and it is working fine on the default MS SQL instance on port 1433.
Now, we need to monitor one more DB instance on each server which listens on the non default port. We have setup odbc.ini like this:
[DB01]
Driver = ODBC Driver 13 for SQL Server
Description = DB-01 Server
Server = 10.0.9.5
Port = 1433
[DB01-1434]
Driver = ODBC Driver 13 for SQL Server
Description = DB-01 Server
Server = 10.0.9.5\\INTA,1434
#Port = 1434
When testing with isql, I can connect to the correct instance and see all the databases on each instance.
When looking at the latest data on that host, I can see that I get the same results for each odbc instance, ie we get the same databases listed for both instances (which is clearly not the case and isql client confirms it), and the values for the databases is 7 (DB does not exists on server), which is obvious, because those DBs are running on another instance.
I have to mention, we did a new template for the second instance which uses their own macros {$ODBC2}, {$MSSQL_USER2}, {$MSSQL_PASSWORD2}, so no interference should happen here. On this template there is only discovery rule and item prototype with key db.odbc.select[{#DBNAME}_state,{$ODBC2}], and I have also tried adding a new host with only this new template added, but it still somehow gets the databases from the wrong instance (default one).
Did I made a mistake somewhere? I have double checked everything, even added a new userparameter in zabbix agent for discovery (mssql.db.discovery2) so the key is different.than the original one.
We are running template with powershell discoveryzabbix-version:
# zabbix_server -V
zabbix_server (Zabbix) 3.0.10
Revision 70208 14 July 2017, compilation time: Jul 17 2017 07:42:06
Can anybody point me in some direction where to look for errors?
If you need any other info, let me know.
Regards!
Comment