I have downloaded check_mssql_database.py from Nagios exchange
I can successfully run a few checks using the plugin
but most fail, all with the same error:./check_mssql_database.py -H 192.168.1.1 -p 1234 -U user -P password --time2connect
OK: Time to connect was 0.00571298599243s|time=0.00571298599243s;;;;
freetds is 0.91-6, (0.91 is the minimum needed I think)./check_mssql_database.py -H 192.168.1.1 -p 1234 -U user -P password --pagelooks
Traceback (most recent call last):
File "./check_mssql_database.py", line 469, in <module>
main()
File "./check_mssql_database.py", line 435, in main
execute_query(mssql, options, host)
File "./check_mssql_database.py", line 448, in execute_query
mssql_query.do(mssql)
File "./check_mssql_database.py", line 284, in do
self.run_on_connection(connection)
File "./check_mssql_database.py", line 271, in run_on_connection
self.query_result = cur.fetchone()[0]
TypeError: 'NoneType' object has no attribute '__getitem__'
apt-cache show freetds-common
Package: freetds-common
Source: freetds
Version: 0.91-6
This plugin has any compatibility issues with specific versions of MSSQL?
Thank you