MSSQL_Server Config Issue

[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.

[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

[mdzekevich]

Ok I see. The password actually ends with "!". I will try to assign password to user macro per your suggestion.
Thanks!

[lmiltchev]

Great! Let us know if your issue has been resolved, so that we can close the thread. Thanks!

[mdzekevich]

Issue has been resolved, thanks.

[bolson]

Closing topic as resolved.

Thank you for using the Nagios Support Forum.