Page 1 of 1

SQL service "Not Found" but running?

Posted: Fri Aug 20, 2010 9:39 am
by servoisgod
Hellos all!

I have a very frustraiting issue with one of my servers. I'm trying to monitor the SQL and SQL Agent running and for some reason, Nagios is saying that it can't find the service? The strange part is that I have this monitor setup one 4 other servers and it's working just fine for those? Below is how I have ALL other servers setup and this is working great for them.

define service{
use generic-service
hostgroup_name SERVERNAME
service_description SQL Server
check_command check_nt!SERVICESTATE!-d SHOWALL -l MSSQLSERVER
contact_groups GROUPNAME
}

I've double, triple and even stood on my head to see if I'm trying something wrong, but can't find any reason why this isn't working on the system? All other Nagios monitoring on this one server is working just fine, so I know that Nagios is setup and configured correctly on it. All servers are running the same version of Nagios also.

What would cause the exact same code to work on one server but not another?

Thanks!


Edit: I'm trying to get the formatting of the code to look like it does on the Nagios setup, but I can't get the spaces to show up correctly? :(

Re: SQL service "Not Found" but running?

Posted: Mon Aug 23, 2010 10:31 am
by mmestnik
I don't follow. Please provide more information, versions and identify what's working. What did you mean by other 4 Servers?

Nagios Servers:
Verify installation of check_nt and compare versions.

Windows Servers:
Test check_nt with other options, try and monitor other metrics.


I've had the same issue with spaces, the solution was to use base64, here is an example:
http://go.nagios.com/forum/73/961