MSSQL Server Wizard

Hi Scoot,

Im trying to monitoring deadlocks of a SQL server,

When im execute ./check_mssql_server.py -H myIP -U myuser -P mypass
the command works fine, but when Im use the --deadlock the command respond to me with this fail.. can you help me please ??

./check_mssql_server.py -H myIP -U myuser -P mypass --deadlocks --warning 20 --critical 30

the result is

Traceback (most recent call last):
File "./check_mssql_server.py", line 464, in
main()
File "./check_mssql_server.py", line 430, in main
execute_query(mssql, options, host)
File "./check_mssql_server.py", line 443, in execute_query
mssql_query.do(mssql)
File "./check_mssql_server.py", line 282, in do
self.run_on_connection(connection)
File "./check_mssql_server.py", line 269, in run_on_connection
self.query_result = cur.fetchone()[0]
TypeError: 'NoneType' object has no attribute '__getitem__'
root@Nagios:/usr/local/nagios/libexec#

thanks in advance,

---

Just as an FYI, if you're running Ubuntu, you can get the pymssql package by installing 'python-pymssql' via apt-get

ie: apt-get install python-pymssql

---

This is a great tool to have now in nagios. Makes monitoring sql servers much easier. There is 1 bug with the -p (port) assignment that prevents it from working correctly when you have non standard ports. You can easily fix this though by going into the service details and setting the host to be host:port

for example

check_xi_mssql_database!-H "server.mydomain" -p 1550 -U nagios -P "password" -T master --logfileusage --warning 0:80 --critical 0:90

would become

check_xi_mssql_database!-H "server.mydomain:1550" -U nagios -P "password" -T master --logfileusage --warning 0:80 --critical 0:90

---