MSSQL PLugin Error

[sievers]

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

[slansing]

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

[sievers]

With Table you mean Database..right?

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

[abrist]

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/