check_mssql_server - Permission denied issue

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Marcusg562
Posts: 7
Joined: Thu Aug 03, 2017 3:28 am

check_mssql_server - Permission denied issue

Post 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.
bolson

Re: check_mssql_server - Permission denied issue

Post by bolson »

This has been resolved? May we close the topic?
Marcusg562
Posts: 7
Joined: Thu Aug 03, 2017 3:28 am

Re: check_mssql_server - Permission denied issue

Post 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.
bolson

Re: check_mssql_server - Permission denied issue

Post by bolson »

Closing topic as resolved.

Thank you for using the Nagios Support Forum.
Locked