Page 4 of 5
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Tue Jun 04, 2013 4:27 pm
by abrist
MSPk wrote: we have changed the password in the resource.cfg to match the one on the agent and then used the test check command on the server to see if nclient service is up and we get the below output.
The "test check command" feature has issues using the macros as the test check runs as user apache, not user nagios.
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Tue Jun 04, 2013 4:52 pm
by lmiltchev
Try saving your config (with the macros) and schedule an immediate check. See if this is going to work. I assume the problem with running the check from the CCM is that the check is run under apache, so the the "$" causes the issue.
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Wed Jun 05, 2013 7:44 am
by MSPk
Yes, it does work that way
I have now configured a service for my MSSQL, however ended up with different error messages while trying the user ID in different formats, details below
when user id is in the format my-domain\userid
Code: Select all
SQL Server message 18452, severity 14, state 1, line 1:
Login failed for user 'my-domainuserid'. The user is not associated with a trusted SQL Server connection.
DB-Lib error message 18452, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
User ID format - my-domain/userid
Code: Select all
SQL Server message 18452, severity 14, state 1, line 1:
Login failed for user 'my-domain/userid'. The user is not associated with a trusted SQL Server connection.
DB-Lib error message 18452, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
User ID format - "my-domain\userid"
Code: Select all
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed
I have shared the details with my DB admin as well and they have suggested that it is an issue with nagios/plugin as they are able to run queries successfullt using the same user ID.
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Wed Jun 05, 2013 12:25 pm
by abrist
What version of XI are you running? There was a bug in an old version that was replacing quotes/apostrophes with the html encoded version (').
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Wed Jun 05, 2013 3:32 pm
by MSPk
we are on 2012 R1.8
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Thu Jun 06, 2013 11:28 am
by abrist
MSPk wrote:'my-domainuserid&apos
The single quote html encoding is curious. Look at teh service check in the CCM, are there actually single quotes, or do you see
' ?
If you see
' replace them with single quotes.
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Fri Jun 07, 2013 10:57 am
by MSPk
The single quote html encoding is curious. Look at teh service check in the CCM, are there actually single quotes, or do you see ' ?
If you see ' replace them with single quotes.
we are passing the credentails via macro's, cant see the actual values via CCM.
I have come across this plugin in exchange,
http://exchange.nagios.org/directory/Pl ... nt/details
its says that the plugin uses NRPE_NT, does it actually mean the NRPE via NSClient++ ?? If yes, should we pu the complete folder in the scripts folder or jus the check_mssql_nt file? Also, should we create a command in the nsc config file and then call it from nagios check_nrpe or do we need to follow a different procedure for this?
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Mon Jun 10, 2013 7:24 am
by MSPk
I did manager to run this new plugin successfully, however the /CHK_CONNECTIONCOUNT always remain in 'Ok' State.
I have used the command "sql_testconnections=scripts\check_mssql_nt.exe /H:DB\instance /CHK_CONNECTIONCOUNT -Wv:50 -Cv100"
Output - MSSQL OK - 70 connections in 0.20 secs
Shouldn't this return a warning considering that the threshold is set to 50? I have reduced it further to 10 for warning and 15 for critical, however it still shows as 'Ok'.
I have tested the /CHK_CONNECT and /CHK_QUERY: successfully and they do return warning and Critical alerts. Its only the connection time that has issues,Please help
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Mon Jun 10, 2013 2:39 pm
by sreinhardt
Per the plugin guidelines I believe you actually want -Wv50: and -Cv100: so that both options are 50 or more and 100 or more. Otherwise you are technically setting warning for less than or equal to 50 and critical only reports at 100.
Re: Do we need to install Pre-requisites for monitoring MS S
Posted: Mon Jun 10, 2013 4:37 pm
by MSPk
how do change the thresholds to 50 or more for warning and 100 or more for critical?