MSSQL/IIS

[DragonJTS]

I'm trying to monitor MSSQL via plugins, and coworker is trying to monitor IIS. We've each tried a couple of plugins, but each one, whether for MSSQL or IIS, returns a critical state with some take on the message that it can't connect. We can still monitor the windows server in questions though, and Nagios confirms both the MSSQL and IIS services are running.

I know the MSSQL wizard jsut went up today, but when i installed it, it didn't appear in the list when I went to use it. (though it did appear in the list of installed wizards)

On an unrelated note, when I set up Nagios for WMI monitoring, it returns "null" for all metrics.

[DragonJTS]

Forgot to mention:
1. CentOS 5.6
2. 32 Bit
3. VMware
4. No special configurations

[nscott]

Dragon,

Which wizard is not showing up? Did you install all three? I'm just curious because I am trying to replicate the issue, and, not to be ask too much but what order did you install them in.

Also on the connectivity issue, its tricky to set up MSSQL to allow non-domain users access to it. What version of SQL Server are you running? Can you try following the instructions where applicable of this post on a remote forum. Its a step-by-step to enable TCP/IP connections to your SQL database:

http://www.webxpert.ro/andrei/2009/05/3 ... s-edition/

[DragonJTS]

I first installed the server wizard, then the query wizard, and finally the database wizard. The server wizard is the one that does not show up, and initially I installed only it, before trying to install the other 2, both of which did show up.

The server has both MSSQL 2005 and 2008 installed on it, and both have TCP/IP active, and listening on all ip's via port 1433

[nscott]

Did you try removing the Server wizard and then readding it? I'm not saying its a permanent, fix I'm just trying to troubleshoot as I cannot duplicate the problem on my machine.

In regards to the server connection refused, are you using the IP? When I was testing the wizard with 2008 (and this may apply to 2005 as well) i had to enter the instance name after the IP like so (i'm using 192.168.5.6 as an example)

192.168.5.6\SQLINSTANCE

The null value from the plugin generall means that WMIC was not installed, did you run the script on this document?

http://assets.nagios.com/downloads/nagi ... For_XI.pdf

[DragonJTS]

I did trying removing/readding the wizard.

I am using the ip, I will try adding the instance name. Is there any way to escape invalid characters in a plugin command? The instance name has a dash, do I need to change it?

WMIC was installed, via the directions in the document.

[nscott]

As long as you wrap it in quotes, and if its still causing problems, if in doubt try using a backslash to escape the character. A dash should be fine however.

Ok, I just checked the WMI installer script and it looks like the perl libraries have moved. While I work on patching this, would you please run this command as root from you linux command line?

Code: Select all

yum install perl-DateTime perl-IniConf -y

We'll see if that resolves and issue.

On the MSSQL server front, can you remove it using the GUI, then see if it still lurking on the command line?

ls /usr/local/nagiosxi/html/includes/configwizards/mssql_server -alR

After removing it with the GUI that should not return any results besides . and .., if it does return results do this:

rm /usr/local/nagiosxi/html/includes/configwizards/mssql_server -rf

[DragonJTS]

Installing the perl modules does not prevent the wmi checks from returning null.

After removing it via the GUI, It returns nothing, it say there is no such file directory (performing the command on the configwizards directory confirms it's not there).

[nscott]

Ok, can you confirm that you're installing the Wizard through the Config Wizard menu and not the Component install screen?

I'm currently digging into the WMI check.

[DragonJTS]

Yes, I can confirm I am installing it through the config wizard screen. And that it shows up in the directory.