Nagios Support Forum

Posted: **Mon Nov 30, 2020 5:10 am**

Hi Support,

Currently, we are trying to monitor MSSQL DB via the MSSQL wizard. We encountered an error using the wizard to which we looked up in a nagios support forum that mentioned the limitation of the nagios wizard which is unable to accept special characters in the password. we followed the workaround provided in the forum which was to add the credentials into /usr/local/nagios/etc/resource.cfg. Upon doing so we still are facing the error, kindly assist this issue. attached is the relevant screenshots.

Posted: **Tue Dec 01, 2020 4:00 pm**

First, go to Admin > Manage Config Wizards and click the Check for Updates button and install any MSSQL wizard updates. There have been some recent updates and I want to make sure you have the latest.

Then go to Configure > Core Config Manager > Commands:
- Edit the command your service is using and surround the user/password values with single-quotes:

Code: Select all

$USER1$/check_mssql_database.py -H $HOSTADDRESS$ -U '$USER11$' -P '$USER10$' $ARG1$

Then save and apply configuration, and test.

If you SSH into the XI server and run it as the nagios user, does it work?

Code: Select all

su - nagios
/usr/local/nagios/libexec/check_mssql_database.py -H 10.202.12.98 -U 'username' -P 'password' -T 'master' -p 1443 --time2connect --warning 1 --critical 5

Send us the full output.

Nagios Support Forum

MSSQL WIZARD ERROR

MSSQL WIZARD ERROR

Re: MSSQL WIZARD ERROR