Page 1 of 1

MSSQL_Server Config Issue

Posted: Thu Jul 27, 2017 2:52 pm
by mdzekevich
2017-07-27_14-32-04.png
Hello,
I am configuring MSSQL server check through configuration wizard.
On all service check I am receiving the same error: (No output on stdout) stderr: /bin/sh: -c: line 0: unexpected EOF while looking for matching `''
When I went to the service check settings I see that arguments have been split into 2 $ARG$ parameters, even though the command is using $ARG1$ only. Moreover, the password is missing characters in $ARG1$ field.
Then I tried to put all arguments in $ARG1$ field, and test run the command - it worked fine. But when I clicked Save, it added \ sign in password parameter and the check didn't work again. It keeps adding \ every time i have everything in $ARG1$ line and click Save button.

Re: MSSQL_Server Config Issue

Posted: Thu Jul 27, 2017 4:31 pm
by lmiltchev
If you had special characters in the password, the CCM could try to escape them on saving, and actually break the check. The "!" is especially bad as it is used as a delimiter, so the password would get split after the "!" and the second part would be shifted to the $ARGx$ below. In order to resolve the issue, you could assign your password to a user macro. Review the following document to find out how:

https://assets.nagios.com/downloads/nag ... Macros.pdf

Re: MSSQL_Server Config Issue

Posted: Fri Jul 28, 2017 9:19 am
by mdzekevich
Ok I see. The password actually ends with "!". I will try to assign password to user macro per your suggestion.
Thanks!

Re: MSSQL_Server Config Issue

Posted: Fri Jul 28, 2017 11:08 am
by lmiltchev
Great! Let us know if your issue has been resolved, so that we can close the thread. Thanks!

Re: MSSQL_Server Config Issue

Posted: Thu Aug 03, 2017 11:55 am
by mdzekevich
Issue has been resolved, thanks.

Re: MSSQL_Server Config Issue

Posted: Thu Aug 03, 2017 1:31 pm
by bolson
Closing topic as resolved.

Thank you for using the Nagios Support Forum.