XI Trial and MSSQL

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
thecountrylife08
Posts: 15
Joined: Wed Dec 23, 2015 9:50 pm

XI Trial and MSSQL

Post 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?
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: XI Trial and MSSQL

Post 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.
Former Nagios Employee
thecountrylife08
Posts: 15
Joined: Wed Dec 23, 2015 9:50 pm

Re: XI Trial and MSSQL

Post 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.
You do not have the required permissions to view the files attached to this post.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: XI Trial and MSSQL

Post by Box293 »

Is it just one service? Can you provide a copy of the plugin?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
thecountrylife08
Posts: 15
Joined: Wed Dec 23, 2015 9:50 pm

Re: XI Trial and MSSQL

Post 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.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: XI Trial and MSSQL

Post by Box293 »

Can you provide us with the service config of one of the services not working please.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
thecountrylife08
Posts: 15
Joined: Wed Dec 23, 2015 9:50 pm

Re: XI Trial and MSSQL

Post by thecountrylife08 »

Sure, I can post it tonight when I get in!
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: XI Trial and MSSQL

Post by lmiltchev »

Whenever you are ready...
Be sure to check out our Knowledgebase for helpful articles and solutions!
thecountrylife08
Posts: 15
Joined: Wed Dec 23, 2015 9:50 pm

Re: XI Trial and MSSQL

Post 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
	}	
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: XI Trial and MSSQL

Post 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.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked