Module: check_mk Branch: master Commit: 92548fdd0d4a10c2a81fc23e732ba29032a92675 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=92548fdd0d4a10… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Wed Mar 19 12:23:31 2014 +0100 FIX check_sql: Fixed monitoring of stored procedures with oracle --- .werks/758 | 8 ++++++++ ChangeLog | 1 + doc/treasures/active_checks/check_sql | 5 ++++- 3 files changed, 13 insertions(+), 1 deletion(-) diff --git a/.werks/758 b/.werks/758 new file mode 100644 index 0000000..78bc360 --- /dev/null +++ b/.werks/758 @@ -0,0 +1,8 @@ +Title: check_sql: Fixed monitoring of stored procedures with oracle +Level: 1 +Component: checks +Version: 1.2.5i1 +Date: 1395228185 +Class: fix + + diff --git a/ChangeLog b/ChangeLog index f9e9ae0..7796627 100644 --- a/ChangeLog +++ b/ChangeLog @@ -213,6 +213,7 @@ * 0729 FIX: esx_vsphere_hostsystem: fixed incorrect status label (not state)... * 0142 FIX: winperf_if: treat unknown packets no longer as error packets * 0593 FIX: zypper: agent plugin and check now lead to UNKNOWN result in case of repo problems + * 0758 FIX: check_sql: Fixed monitoring of stored procedures with oracle Multisite: * 0371 Added log class filter to hostsvcevents view diff --git a/doc/treasures/active_checks/check_sql b/doc/treasures/active_checks/check_sql old mode 100755 new mode 100644 index 761f1e1..846085e --- a/doc/treasures/active_checks/check_sql +++ b/doc/treasures/active_checks/check_sql @@ -206,7 +206,10 @@ try: #opt_input.append("outvar") cursor.callproc(opt_sql, (outvar,)) res = outvar.getvalue() - result = res[0].split(",") + if opt_dbms == "mssql": + result = res[0].split(",") + else: + result = res.split(",") else: cursor.execute(opt_sql) result = cursor.fetchone()