MSSQL

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

[ruffsense]

with all the checks?

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

[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

[orani]

Thats my screenshots. if you need extra infos please let me know

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