Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
Directory
sucustrupador
bysucustrupador, March 3, 2014
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,
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,