Nagios Support Forum

Posted: **Mon Oct 21, 2013 9:15 am**

Hi,

I have an issue configuring the check_mssql_database.py plugin

When I try to connect to the database everything works:

Code: Select all

[root@pxdc001apnag1 libexec]# ./check_mssql_database.py -H 10.180.2.38 -U nagios
 -P ********* -I COBRA_GHSS -T Adressen_GHSS_01                               
OK: Time to connect was 0.00567698478699s|time=0.00567698478699s;;;;;

However when I try to retrieve further inforation for instance --datasize, I get the following error

Code: Select all

[root@pxdc001apnag1 libexec]# ./check_mssql_database.py -H 10.180.2.38 -U nagios
 -P ********* -I COBRA_GHSS -T Adressen_GHSS_01 --datasize -w 200000 -c 300000
                                                                                
SQL Server message 208, severity 16, state 1, line 1:                           
Invalid object name 'sysperfinfo'.                                              
DB-Lib error message 208, severity 16:                                          
General SQL Server error: Check messages from the SQL Server

I am no SQL expert, so I would not even know where to begin, could someone help me, thanks

EDIT: I checked the SQL logs, and there is no entry at that timestamp

Posted: **Mon Oct 21, 2013 10:07 am**

One possibility is.. does the nagios user account in the mssql server have access to that table in the master database?

Posted: **Wed Oct 23, 2013 7:28 am**

With Table you mean Database..right?

yes he does, he has full permissions on the instance and the database. However the error persists

Posted: **Wed Oct 23, 2013 3:18 pm**

The following link suggests that 'sysperfinfo' is only available on the master. If the plugin is checking that on the instance, this may explain your issue. . .
http://thomaslarock.com/2011/03/march-m ... sperfinfo/

Nagios Support Forum

MSSQL PLugin Error

MSSQL PLugin Error

Re: MSSQL PLugin Error

Re: MSSQL PLugin Error

Re: MSSQL PLugin Error