MSSQL not showing data in XI

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
dlisterjr
Posts: 9
Joined: Mon Jul 08, 2013 2:47 pm

MSSQL not showing data in XI

Post by dlisterjr »

I run the check_mssql_server.py via the command line and I retrieve data but in XI I get the error: (No output on stdout) stderr: Traceback (most recent call last): This is for all the data points of MSSQL created using the wizard. I have verified the plugin and the wizard are up to date.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: MSSQL not showing data in XI

Post by tgriep »

Can you post how the service check is defined in XI so we can review it?
If the username or password has special characters in it, try putting them between single quotes and see if that helps.
Can you run this command on the XI server and post the output?

Code: Select all

ls -l /usr/local/nagios/libexec/check_mssql_server*
Be sure to check out our Knowledgebase for helpful articles and solutions!
dlisterjr
Posts: 9
Joined: Mon Jul 08, 2013 2:47 pm

Re: MSSQL not showing data in XI

Post by dlisterjr »

Thanks for the reminder on the special characters. The password I was given had a $ in it and I didn't notice.
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: MSSQL not showing data in XI

Post by tgriep »

Is it working now?
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked