Nagios Support Forum

Absolutely agree with this!

Thanks, that's works great for me!

In your example command ./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. BASE_QUERY = "...

What version of MSSQL are you running on that server? I'm not pretty sure at this moment but it should be MSSQL 2012 or 2014. I will verify this. Can you post the check_mssql_database.py script here or the link to the where you downloaded it from? Yes, see atachment for my used script: check_mssql_...

Hey all, when I'm trying to run on bash ./check_mssql_database.py -H MYHOST:MYPORT -U USER -P SECRET -T CHECKTABLE --loggrowths I got the following error: <type 'exceptions.TypeError'> Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query,...

Yes, we can close the issue. The issue was running the script first time as root and the nagios user wasn't able to delete the temp files within /tmp. First delete them and try again.

When I'm running ./check_mssql_server.py as nagios user I got the follwoing error: pagelooks failed with: [Errno 13] Permission denied: '/tmp/mssql-5102010976614747718.tmp' batchreq failed with: [Errno 13] Permission denied: '/tmp/mssql--6562670709155699978.tmp' connections passed! lockwaits failed ...