Page 1 of 1
Issue with check mssql server
Posted: Thu May 09, 2019 8:55 am
by user1234
Hello.
I've added by config wizard ms sql server.
Windows server 2019, sql server 2017.
Followed by
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
But i have error on every service.
(only host ping are online)
I tried to disable firewall also.
SQL server is without instance name.
Local sql account nagios with permission was created.
(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
Re: Issue with check mssql server
Posted: Thu May 09, 2019 10:20 am
by lmiltchev
Can you show us the actual command run from the command line, along with the output of it? Obfuscate sensitive data. Thank you!
Re: Issue with check mssql server
Posted: Tue May 14, 2019 7:25 am
by user1234
Its not command issue, as same command working fine for other sql server.
Code: Select all
check_xi_mssql_server!-U 'login' -P 'pass' -p 1433 --locktimeouts --warning 20 --critical 30
Only differencies which i see that server which is not working has not custom instance name.
Re: Issue with check mssql server
Posted: Tue May 14, 2019 10:53 am
by lmiltchev
Only differencies which i see that server which is not working has not custom instance name.
Do you have special characters in the password, e.g. "!"? This can cause the same issue.
Re: Issue with check mssql server
Posted: Thu May 16, 2019 5:22 am
by user1234
Thanks.
Yes, that was issue, special char.
I removed them and started working.
But its still some security policy issue with password without special char
Re: Issue with check mssql server
Posted: Thu May 16, 2019 1:04 pm
by scottwilkerson
user1234 wrote:Thanks.
Yes, that was issue, special char.
I removed them and started working.
But its still some security policy issue with password without special char
You can use almost all special chars, but they may need to be escaped.
The ! is more complicated in nagios commands as it is argument separator in the command line.
https://support.nagios.com/kb/article.php?id=580