SQL Database Check

[jerrywfg]

Hi,

We have setup Nagios XI 5.4.10 on a REDHAT environment.
We are trying to monitor SQL databases. So we created an account as seen in https://assets.nagios.com/downloads/nag ... 1512636088

Next we started the MSSQL Wizard for databases all the service states show UNKNOWN. But when I check one State manually it is OK. See below:

Run Check Command:
[nagios@xxxx ~]$ /usr/local/nagios/libexec/check_mssql_database.py -H SERVER -U 'DOMAIN\USERACCOUNT' -P 'PASSWORD' -T 'CM_PS1' -p 1433 -w 10 -c 20 OK: Time to connect was 0.0143220424652s|time=0.0143220424652s;10;20;;

Operations Center View:
Host Service Status Duration Attempt Last Check Status Information
SQL-DB-CM_PS1 CM_PS1 MSSQL Active Transactions Unknown 22m 23s 5/5 2017-12-08 13:12:01 <empty>

[kyang]

Is it just saying Unknown?

Could you put the error output or screenshot of the services from the SQL database check that return that error?

Thanks!

[jerrywfg]

Hi,

Thank you for your reply.
It is just Unknown. There is nu error message or status. But as you can see when we run it manually there is an OK with a value.
Is there an error log somewhere where we can see what happens? I will try to get the screenshot but this week I am in another office.

Thanks.

[kyang]

Sounds good,

Could you also tell us what version of MS SQL database you are using?

The nagios.log should contain the information that it shows from the UI. You could send us that log.

Code: Select all

/usr/local/nagios/var/nagios.log

[jerrywfg]

Hi,

Here's an update. Finally the internet was enabled on the new Nagios Server. We have downloaded the latest Nagios Plugins. And after we enabled those the Check is working fine!

Thank you for your patient but the problem is solved!

Jerry

[kyang]

Sounds good! I'll be closing this thread!

If you have any more questions, feel free to create another thread.

Thanks for using the Nagios Support Forum!