check_mssql_server.py --readahead --lazywrites not working

[rchavan]

Hi All,

I have implemented check_mssql_server.py and check_mssql_database.py py, here in check_mssql_server.py few options like --readheads, --lazywrites, --deadloacks are working through command line however not working through NagiosXI GUIcommands, one of it doesnt work in cli or in nagiosXI either.

CLI output:

[root@NAGIOSXI libexec]# ./check_mssql_server.py -H XX.XX.XX.XX -U 'USER' -P 'Password' -p '1433' --deadlocks --warning 20 --critical 30
OK: Deadlocks / Sec is 0.0/sec|deadlocks=0.0;20;30;;;
[root@NAGIOSXI libexec]#

NagiosXI GUI:

MSSQL Readaheads Per Sec
Unknown 1d 1h 25m 38s 5/5 2015-09-02 13:14:56 [Errno 13] Permission denied: '/tmp/mssql-1857473023.tmp',

Please help.

[hsmith]

Hi All,

I have implemented check_mssql_server.py and check_mssql_database.py py, here in check_mssql_server.py few options like --readheads, --lazywrites, --deadloacks are working through command line however not working through NagiosXI GUIcommands, one of it doesnt work in cli or in nagiosXI either.

CLI output:

[root@NAGIOSXI libexec]# ./check_mssql_server.py -H XX.XX.XX.XX -U 'USER' -P 'Password' -p '1433' --deadlocks --warning 20 --critical 30
OK: Deadlocks / Sec is 0.0/sec|deadlocks=0.0;20;30;;;
[root@NAGIOSXI libexec]#

NagiosXI GUI:

MSSQL Readaheads Per Sec
Unknown 1d 1h 25m 38s 5/5 2015-09-02 13:14:56 [Errno 13] Permission denied: '/tmp/mssql-1857473023.tmp',

Please help.

Can you please post the output of a ls -l /usr/local/nagios/libexec command? This really seems like a permissions thing.

Also ls -l /tmp