MSSQL Service checks (with $) after 2014 upgrade
Posted: Mon Jun 09, 2014 12:54 pm
I didn't want to hijack this thread:
http://support.nagios.com/forum/viewtop ... 086#p98089
but I have the same problem. I was able to get the checks to pass in CCM, but the automatic or forced checks in XI still fail. I did a "Save" and "Apply Configuration" in CCM before scheduling an immediate check.
COMMAND: /usr/local/nagios/libexec/check_nt -H server.fqdn -s "password" -p 12489 -v SERVICESTATE -l "MSSQL\$BLACKBERRY" -d SHOWALL
OUTPUT: MSSQL$BLACKBERRY: Started
But in the Nagios XI interface it still shows: Critical MSSQL: Not found
The "MSSQL" part listed above changes to be the first part of the service shortname before the $ in Windows Services applet.
ie for the Lync server:
COMMAND: /usr/local/nagios/libexec/check_nt -H server.fqdn -s "password" -p 12489 -v SERVICESTATE -l "MSSQLFDLauncher\$PANAMLYNCARC" -d SHOWALL
OUTPUT: MSSQLFDLauncher$PANAMLYNCARC: Started
but the XI interface shows:
Critical MSSQLFDLauncher: Not found
Anyone have an idea? I have 24 of these checks that all went to "WARNING" after the upgrade and they just show "MSSQL\: Error" in the XI interface. None worked as-is in CCM till I made the changes suggested in the other forum thread. Making the changes to the \$ got the CCM checks to pass, but now all are Critical in XI.
old version: 2012R2.9 <-- Everything worked
Upgraded to: 2014R1.1 <-- All MSSQL Service checks with $ in the service shortname show WARNING/CRITICAL depending on changes made to CCM.
From Admin|System Profile:
System:
Nagios XI Version : 2014R1.1
server.fqdn 2.6.18-348.16.1.el5 x86_64
CentOS release 5.9 (Final)
Gnome Installed
Apache Information
PHP Version: 5.1.6
Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0
Server Name: <nagios server>
Server Address: <IP>
Server Port: 80
http://support.nagios.com/forum/viewtop ... 086#p98089
but I have the same problem. I was able to get the checks to pass in CCM, but the automatic or forced checks in XI still fail. I did a "Save" and "Apply Configuration" in CCM before scheduling an immediate check.
COMMAND: /usr/local/nagios/libexec/check_nt -H server.fqdn -s "password" -p 12489 -v SERVICESTATE -l "MSSQL\$BLACKBERRY" -d SHOWALL
OUTPUT: MSSQL$BLACKBERRY: Started
But in the Nagios XI interface it still shows: Critical MSSQL: Not found
The "MSSQL" part listed above changes to be the first part of the service shortname before the $ in Windows Services applet.
ie for the Lync server:
COMMAND: /usr/local/nagios/libexec/check_nt -H server.fqdn -s "password" -p 12489 -v SERVICESTATE -l "MSSQLFDLauncher\$PANAMLYNCARC" -d SHOWALL
OUTPUT: MSSQLFDLauncher$PANAMLYNCARC: Started
but the XI interface shows:
Critical MSSQLFDLauncher: Not found
Anyone have an idea? I have 24 of these checks that all went to "WARNING" after the upgrade and they just show "MSSQL\: Error" in the XI interface. None worked as-is in CCM till I made the changes suggested in the other forum thread. Making the changes to the \$ got the CCM checks to pass, but now all are Critical in XI.
old version: 2012R2.9 <-- Everything worked
Upgraded to: 2014R1.1 <-- All MSSQL Service checks with $ in the service shortname show WARNING/CRITICAL depending on changes made to CCM.
From Admin|System Profile:
System:
Nagios XI Version : 2014R1.1
server.fqdn 2.6.18-348.16.1.el5 x86_64
CentOS release 5.9 (Final)
Gnome Installed
Apache Information
PHP Version: 5.1.6
Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0
Server Name: <nagios server>
Server Address: <IP>
Server Port: 80