Page 1 of 2

XI Trial and MSSQL

Posted: Tue Mar 15, 2016 12:59 pm
by thecountrylife08
Hello Everyone,

I tried to search both the Forum and Google for the answer to this question but have been unsuccessful in finding the problem and resolving it. I am using Nagios XI trial for a class I am taking to monitor my class server, we are getting into the 70-462/463 sections so performance is becoming a big deal. I am trying to use the XI trial (while it remains) to monitor the databases but for every SQL/NSClient service I setup I get the following error
(No output on stdout) stderr: /bin/sh: -c: line 0: unexpected EOF while looking for matching `''
/bin/sh: -c: line 1: syntax error: unexpected end of file
I am not a Linux/Unix expert but I know that in some shell file or script there is a missing close " and it needs to be inserted, problem is I have no idea what /bin/sh: -c: is referring to. Anyone have any helpful hints or tricks to resolve this one?

Re: XI Trial and MSSQL

Posted: Tue Mar 15, 2016 1:55 pm
by rkennedy
Where are you seeing this error at? Also, what OS are you running XI on?

Let's check the permissions for your plugins, please run this from the CLI - ls -l /usr/local/nagios/libexec/ and post the result.

Re: XI Trial and MSSQL

Posted: Tue Mar 15, 2016 6:24 pm
by thecountrylife08
I am seeing this when looking at the View Services Screen, it is what is showing in the data section of the results. I am running on CentOS 6. I have also attached the returns from the list command, it looks similar to the core installation I was using previously, but it wasn't monitoring DBs yet.

Re: XI Trial and MSSQL

Posted: Tue Mar 15, 2016 7:03 pm
by Box293
Is it just one service? Can you provide a copy of the plugin?

Re: XI Trial and MSSQL

Posted: Tue Mar 15, 2016 8:23 pm
by thecountrylife08
I am 99% sure it is the plugin called check_nt, but the extension cannot be uploaded. I came to this conclusion by checking the commands, using the resources and tracing it to the libexec folder.

Re: XI Trial and MSSQL

Posted: Tue Mar 15, 2016 9:38 pm
by Box293
Can you provide us with the service config of one of the services not working please.

Re: XI Trial and MSSQL

Posted: Wed Mar 16, 2016 5:52 pm
by thecountrylife08
Sure, I can post it tonight when I get in!

Re: XI Trial and MSSQL

Posted: Thu Mar 17, 2016 9:22 am
by lmiltchev
Whenever you are ready...

Re: XI Trial and MSSQL

Posted: Thu Mar 17, 2016 1:46 pm
by thecountrylife08
Here we go...

Code: Select all

define service {
	host_name			MCSA Class Server
	service_description		CPU Usage
	use				xiwizard_windowsserver_nsclient_service
	check_command			check_xi_service_nsclient!password!CPULOAD!-l 5,70,80
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			windowsserver
	register			1
	}	

Re: XI Trial and MSSQL

Posted: Thu Mar 17, 2016 5:06 pm
by tgriep
You may want to edit that service and add single quotes around the argument like below.

Code: Select all

'password'
Moderator's Note: We removed your password.