Home Directory

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory

sucustrupador

Reviews(1)
bysucustrupador, March 3, 2014
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,