Page 1 of 1
MSSQL
Posted: Sat Dec 17, 2016 8:30 pm
by orani
i am using the wizards for MSSQL that nagios have and i am getting the follown error
(No output on stdout) stderr: /bin/sh: -c: line 0: unexpected EOF while looking for matching `''
any ideas what is happening?
Re: MSSQL
Posted: Sun Dec 18, 2016 3:37 pm
by ruffsense
with all the checks?
Re: MSSQL
Posted: Mon Dec 19, 2016 10:39 am
by dwhitfield
Can you post a screenshot of the check you are using (of the command line if you are running from command line)? It looks to me like you are missing a closing quote.
Also, what version of XI are you running and what version of MSSQL?
Re: MSSQL
Posted: Tue Dec 20, 2016 2:58 pm
by orani
@ruffsense yes at all checks
@dwhitfield i used the MSSQL wizard for database monitoring and i just filled the username and password. i run the latest version of nagios xi and MSSQL 2012 v. 11.0.5058.0
Re: MSSQL
Posted: Tue Dec 20, 2016 3:08 pm
by orani
Thats my screenshots. if you need extra infos please let me know
Re: MSSQL
Posted: Tue Dec 20, 2016 3:54 pm
by dwhitfield
Also see a 20009 error. If you want to take that, run the following:
Code: Select all
export TDSDUMP=/tmp/freetds.log
tsql -H myip -p 1433 -U myuser
(replace myip / myuser as needed, and enter the SQL Server password when prompted)
As for the missing ", can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the Download Profile button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info).
After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.