Page 1 of 1

check_mssql_server - Permission denied issue

Posted: Thu Aug 03, 2017 3:32 am
by Marcusg562
When I'm running ./check_mssql_server.py as nagios user I got the follwoing error:

Code: Select all

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 with: [Errno 13] Permission denied: '/tmp/mssql--7938501698673200740.tmp'
pagereads failed with: [Errno 13] Permission denied: '/tmp/mssql-171828080302661302.tmp'
totalpages failed with: 'NoneType' object has no attribute '__getitem__'
readahead failed with: [Errno 13] Permission denied: '/tmp/mssql--6089655253061029962.tmp'
pagewrites failed with: [Errno 13] Permission denied: '/tmp/mssql-3606806625728950990.tmp'
stolenpages failed with: 'NoneType' object has no attribute '__getitem__'
targetpages passed!
fullscans failed with: [Errno 13] Permission denied: '/tmp/mssql--1566979456380714131.tmp'
locktimeouts failed with: [Errno 13] Permission denied: '/tmp/mssql--5799456107031461231.tmp'
memory passed!
freepages failed with: 'NoneType' object has no attribute '__getitem__'
bufferhitratio passed!
averagewait passed!
checkpoints failed with: [Errno 13] Permission denied: '/tmp/mssql-5496578879705381720.tmp'
lockrequests failed with: [Errno 13] Permission denied: '/tmp/mssql--1275856912352964185.tmp'
pagelife passed!
databasepages passed!
deadlocks failed with: [Errno 13] Permission denied: '/tmp/mssql-2175521217392866454.tmp'
cachehit passed!
pagesplits failed with: [Errno 13] Permission denied: '/tmp/mssql-1254462928432539929.tmp'
lockwait passed!
lazywrites failed with: [Errno 13] Permission denied: '/tmp/mssql--6207153280418390731.tmp'
sqlcompilations failed with: [Errno 13] Permission denied: '/tmp/mssql--6130677350282614346.tmp'
cpu passed!
17/27 tests failed.
Is there an option to solve this issue? Even make nagios to root doesen't fixed it.

Re: check_mssql_server - Permission denied issue

Posted: Thu Aug 03, 2017 12:18 pm
by bolson
This has been resolved? May we close the topic?

Re: check_mssql_server - Permission denied issue

Posted: Fri Aug 04, 2017 12:49 am
by Marcusg562
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.

Re: check_mssql_server - Permission denied issue

Posted: Fri Aug 04, 2017 9:17 am
by bolson
Closing topic as resolved.

Thank you for using the Nagios Support Forum.