Nagios Support Forum

./check_mssql_database.py -H MYHOST:MYPORT -U USER -P SECRET -T CHECKTABLE --loggrowths

<type 'exceptions.TypeError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

SELECT cntr_value,counter_name,instance_name FROM Vudyog.sys.sysperfinfo WHERE instance_name='CHECKTABLE ';

SELECT cntr_value FROM sysperfinfo WHERE counter_name='Log Cache Hit Ratio' AND instance_name='CHECKTABLE ';

tgriep wrote:What version of MSSQL are you running on that server?

tgriep wrote:Can you post the check_mssql_database.py script here or the link to the where you downloaded it from?

tgriep wrote:A possible cause could be that the user permissions may not be sufficient so make sure they are set correctly.

tgriep wrote:In your example command

Code: Select all

./check_mssql_database.py -H MYHOST:MYPORT -U USER -P SECRET -T CHECKTABLE --loggrowths

You are specifying loggrowths as the option.

When that is used, this is the query that is generated, so see if you can run this in your MSSQL server without any errors.

Code: Select all

BASE_QUERY = "SELECT cntr_value FROM sysperfinfo WHERE counter_name='Log Growths' AND instance_name='CHECKTABLE';"

Also, from what I heard, in MSSQL 2012 and newer, some tables were removed so you cannot check for them as they do not exist and will cause errors running the plugin.