nagiosenterprises / check_mssql_collection Goto Github PK

$ /tmp/check_mssql_server.py -H $host -U $dbuser -P $dbpswd --lazywrites -w 20 -c 30
Traceback (most recent call last):
  File "/tmp/check_mssql_server.py", line 464, in <module>
    main()
  File "/tmp/check_mssql_server.py", line 430, in main
    execute_query(mssql, options, host)
  File "/tmp/check_mssql_server.py", line 443, in execute_query
    mssql_query.do(mssql)
  File "/tmp/check_mssql_server.py", line 282, in do
    self.run_on_connection(connection)
  File "/tmp/check_mssql_server.py", line 269, in run_on_connection
    self.query_result = cur.fetchone()[0]
TypeError: 'NoneType' object has no attribute '__getitem__'

$ /tmp/check_mssql_server.py -H $host -U $dbuser -P $dbpswd --time2connect
OK: Time to connect was 0.0266668796539s|time=0.0266668796539s;;;;;

stdout = '%s%s|%s=%s%s;%s;%s;;' % (prefix, stdout, label, strresult, unit, options.warning or '', options.critical or '')

/usr/local/nagios/libexec/check_mssql_server.py --help
Usage: check_mssql_server.py -H hostname -U user -P password -T table --mode

xxxxxx

  Nagios Plugin Information:
    -w WARNING, --warning=WARNING
                        Specify warning range.
    -c CRITICAL, --critical=CRITICAL
                        Specify critical range.

./check_mssql_database.py -H mssql01.box293.local -U 'nagios' -P 'xxxxxx' -T 'Sample' -p 14333 --logcachehit --warning 0:95 --critical 0:97
<type 'exceptions.ZeroDivisionError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

231 def return_nagios(options, stdout='', result='', unit='', label=''):
232 >>>>>>>>>>>>>>>>>>>>>>>>
233     if int(options.critical) < int(options.warning):
234         invert = True
235     else:
236         invert = False
237 
238     if is_within_range(options.critical, result, invert):
239 <<<<<<<<<<<<<<<<<<<<<<<
        prefix = 'CRITICAL: '
240         code = 2
>>>>>>>>>>>>>>>>>>>>>>>>
241     elif is_within_range(options.warning, result, invert):
<<<<<<<<<<<<<<<<<<<<<<<
242         prefix = 'WARNING: '
243         code = 1
244     else:
245         prefix = 'OK: '
246         code = 0
247     strresult = str(result)
248     try:
249         stdout = stdout % (strresult)
250     except TypeError, e:
251         pass
252     stdout = '%s%s|%s=%s%s;%s;%s;;;' % (prefix, stdout, label, strresult, unit, options.warning or '', options.critical or '')
253     raise NagiosReturn(stdout, code)

>>>>>>>>>>>>>>>>>>>>>>>>
391 def is_within_range(nagstring, value, invert = False):
<<<<<<<<<<<<<<<<<<<<<<<
392     if not nagstring:
393         return False
394     import re
395     import operator
396     first_float = r'(?P<first>(-?[0-9]+(\.[0-9]+)?))'
397     second_float= r'(?P<second>(-?[0-9]+(\.[0-9]+)?))'
398     actions = [ (r'^%s$' % first_float,lambda y: (value > float(y.group('first'))) or (value < 0)),
399                 (r'^%s:$' % first_float,lambda y: value < float(y.group('first'))),
400                 (r'^~:%s$' % first_float,lambda y: value > float(y.group('first'))),
401                 (r'^%s:%s$' % (first_float,second_float), lambda y: (value < float(y.group('first'))) or (value > float(y.group('        second')))),
402                 (r'^@%s:%s$' % (first_float,second_float), lambda y: not((value < float(y.group('first'))) or (value > float(y.gr        oup('second')))))]
403     for regstr,func in actions:
404         res = re.match(regstr,nagstring)
405         if res:
>>>>>>>>>>>>>>>>>>>>>>>>
406                 if invert:
407                   return not func(res)
408                 else:
409                   return func(res)
<<<<<<<<<<<<<<<<<<<<<<<
410     raise Exception('Improper warning/critical format.')

<type 'exceptions.TypeError'>
Caught unexpected error. This could be caused by your sysperfinfo not containing the proper entries for this query, and you may delete this service check.

$ /tmp/check_mssql_database.py --hostname=$host --user=$dbuser --password=$dbpswd --table=dbadmin --datasize
Traceback (most recent call last):
  File "/tmp/check_mssql_database.py", line 352, in <module>
    main()
  File "/tmp/check_mssql_database.py", line 318, in main
    execute_query(mssql, options, host)
  File "/tmp/check_mssql_database.py", line 331, in execute_query
    mssql_query.do(mssql)
  File "/tmp/check_mssql_database.py", line 167, in do
    self.run_on_connection(connection)
  File "/tmp/check_mssql_database.py", line 154, in run_on_connection
    self.query_result = cur.fetchone()[0]
TypeError: 'NoneType' object has no attribute '__getitem__'

$ pip freeze | egrep -i pymssql\|cython
Cython==0.20.2
pymssql==2.1.0