Problems with monitoring MSSQL on WIndows server

[nagiosEngie]

Hello,
I am having an issue with a service check. I am using NCPA agent to monitor windows Servers.
Ma mssql check if tested from CCM will give me the right result as you can see in the attached image CCMtest.jpg

When I go to my server in the nagios interface i will get a message telling me the service is not running. Image nagiostest.jpg
As you can see there is a dollar sign at the end of the word running. I think this is giving the problem, but I do not know how to solve this issue.

Can you please help?

Thanks
Sandro

[lmiltchev]

From the Nagios XI GUI, go to Service Detail, click on the service, go to Configure > Re-configure this service, and change the command (under the "Monitoring" tab) by adding a second dollar sign to "MSSQL$SQLPRINTMI".
Example:

Code: Select all

MSSQL$$SQLPRINTMI

Click on "Update", and force an immediate check. Let us know if this "workaround" fixed your issue.

P.S.
I am going to be filing an internal bug report about the NCPA wizard. The wizard should escape the dollar sign with another one for services that contain one in the name.

[lmiltchev]

Update: The bug report has been filed (task_id=13296). Thank you!

[nagiosEngie]

Hello,
I tested the solution proposed and it is now working if I do the force immidiate check. But it is giving an error if I try it through CCM.
Images atached.
Thanks
Sandro

[lmiltchev]

Don't worry about the testing from the CCM. It's is not perfect - sometimes it may have issues, caused by escaping. The test button is placed in the CCM for convenience. It is not meant to be a substitute for testing from the command line. As long as your check works from the GUI, you should be fine.

Our developers already fixed the NCPA wizard, and the "$" in the names of the services will be escaped with another "$" from now on.