Checkmk git commits

checkmk-commits@lists.checkmk.com

1 participants
64454 discussions

Check_MK Git: check_mk: Merge branch 'master' of ssh://mathias-kettner.de/ check_mk

by Mathias Kettner

Module: check_mk Branch: master Commit: 1d7e8248beffd2df0464b68b3d57e82a1b7aeefd URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=1d7e8248beffd2… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Mon May 6 11:47:11 2013 +0200 Merge branch 'master' of ssh://mathias-kettner.de/check_mk ---

11 years, 5 months

Check_MK Git: check_mk: vsphere agent: Added counter dump mode for easier debugging

by Lars Michelsen

Module: check_mk Branch: master Commit: 3c69ef2f839d43cac2edc83c81a5384d3f9b9e48 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=3c69ef2f839d43… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 11:14:45 2013 +0200 vsphere agent: Added counter dump mode for easier debugging --- agents/special/agent_vsphere | 2 ++ 1 file changed, 2 insertions(+) diff --git a/agents/special/agent_vsphere b/agents/special/agent_vsphere index 8a696aa..24f4e29 100755 --- a/agents/special/agent_vsphere +++ b/agents/special/agent_vsphere @@ -74,6 +74,8 @@ OPTIONS: hostsystem, virtualmachine and storage. Default is to query all modules. + -c, --dump-counters Simply dumping out all available counters and their values. + This mode is meant for debugging and diagnostic purposes. """)

11 years, 5 months

Check_MK Git: check_mk: vsphere agent: Added counter dump mode for easier debugging

by Lars Michelsen

Module: check_mk Branch: master Commit: 244754b67dd49210b40d27577880fdea41868fc3 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=244754b67dd492… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 11:12:42 2013 +0200 vsphere agent: Added counter dump mode for easier debugging --- agents/special/agent_vsphere | 126 +++++++++++++++++++++++------------------- 1 file changed, 70 insertions(+), 56 deletions(-) diff --git a/agents/special/agent_vsphere b/agents/special/agent_vsphere index eeb6250..8a696aa 100755 --- a/agents/special/agent_vsphere +++ b/agents/special/agent_vsphere @@ -77,9 +77,10 @@ OPTIONS: """) -short_options = 'hi:u:s:Dat:H:' +short_options = 'hi:u:s:Dat:H:c' long_options = [ 'help', 'user=', 'secret=', 'direct', 'agent', 'debug', 'modules=', 'timeout=', 'hostname=', + 'dump-counters', ] try: @@ -88,11 +89,13 @@ except getopt.GetoptError, err: sys.stderr.write("%s\n" % err) sys.exit(1) -opt_debug = False -opt_direct = False -opt_agent = False -opt_timeout = 60 -opt_hostname = None +opt_debug = False +opt_direct = False +opt_agent = False +opt_dump_counters = False +opt_timeout = 60 +opt_hostname = None + host_address = None user = None secret = None @@ -115,6 +118,8 @@ for o,a in opts: opt_timeout = int(a) elif o in [ '-H', '--hostname' ]: opt_hostname = a + elif o in [ '-c', '--dump-counters' ]: + opt_dump_counters = True elif o in [ '-h', '--help' ]: usage() sys.exit(0) @@ -426,7 +431,10 @@ def dump_list(l, indent): # 'sys.resourceMemZero': 262157, # 'sys.uptime': 262144} -def output_hostsystem_counters(): +def dump_hostsystem_counters(): + output_hostsystem_counters(all_counters = True) + +def output_hostsystem_counters(all_counters = False): pm = host.get_performance_manager() for mor, name in all_hosts.items(): if not opt_direct: @@ -437,57 +445,58 @@ def output_hostsystem_counters(): # a couple of seconds. To check out which counters are available just comment out # the hardcoded needed_ids and uncomment the following three lines of code. This will # give you a) A dict of name to id mappings and b) Current values of all counters. - #counterids = pm.get_entity_counters(mor) - #needed_ids = counterids.keys() # retrieve all ids.... - #print counterids - - needed_ids = [ - # net.* - 196616, 196621, 196617, 196625, 196619, 196623, 196609, 196614, - 196620, 196624, 196615, 196622, 196618, 196612, 196613, 196626, - # sys.uptime - 262144, - # mem.* - # 65635, 65537, 65577, 65625, 65545, 65611, 65573, 65615, 65582, - # 65549, 65630, 65622, 65618, 65621, 65561, 65623, 65632, 65557, - # 65628, 65633, 65541, 65643, 65586, 65553, 65569, 65589, 65639, - # 65620, 65599, 65580, 65619, 65603, - # 'disk.deviceLatency': 131091, - # 'disk.deviceReadLatency': 131083, - # 'disk.deviceWriteLatency': 131087, - # 'disk.kernelLatency': 131092, - # 'disk.kernelReadLatency': 131084, - # 'disk.kernelWriteLatency': 131088, - # 'disk.maxQueueDepth': 131096, - # 'disk.maxTotalLatency': 131095, - # 'disk.numberRead': 131076, - # 'disk.numberReadAveraged': 131097, - # 'disk.numberWrite': 131077, - # 'disk.numberWriteAveraged': 131098, - # 'disk.queueLatency': 131094, - # 'disk.queueReadLatency': 131086, - # 'disk.queueWriteLatency': 131090, - # 'disk.read': 131078, - # 'disk.totalLatency': 131093, - # 'disk.totalReadLatency': 131085, - # 'disk.totalWriteLatency': 131089, - # 'disk.usage': 131073, - - # disk.read/write/deviceLatency/numberRead/numberWrite - 131078, 131079, 131091, 131076, 131077, - ] - - # Seems as this is not available in ESX 5.0 but we saw it on 5.1 - if esx_version_num > 5.0: - # sys.resourceMemConsumed - needed_ids += [ - 262171, + if all_counters: + counterids = pm.get_entity_counters(mor) + needed_ids = counterids.keys() # retrieve all ids.... + else: + needed_ids = [ + # net.* + 196616, 196621, 196617, 196625, 196619, 196623, 196609, 196614, + 196620, 196624, 196615, 196622, 196618, 196612, 196613, 196626, + # sys.uptime + 262144, + # mem.* + # 65635, 65537, 65577, 65625, 65545, 65611, 65573, 65615, 65582, + # 65549, 65630, 65622, 65618, 65621, 65561, 65623, 65632, 65557, + # 65628, 65633, 65541, 65643, 65586, 65553, 65569, 65589, 65639, + # 65620, 65599, 65580, 65619, 65603, + # 'disk.deviceLatency': 131091, + # 'disk.deviceReadLatency': 131083, + # 'disk.deviceWriteLatency': 131087, + # 'disk.kernelLatency': 131092, + # 'disk.kernelReadLatency': 131084, + # 'disk.kernelWriteLatency': 131088, + # 'disk.maxQueueDepth': 131096, + # 'disk.maxTotalLatency': 131095, + # 'disk.numberRead': 131076, + # 'disk.numberReadAveraged': 131097, + # 'disk.numberWrite': 131077, + # 'disk.numberWriteAveraged': 131098, + # 'disk.queueLatency': 131094, + # 'disk.queueReadLatency': 131086, + # 'disk.queueWriteLatency': 131090, + # 'disk.read': 131078, + # 'disk.totalLatency': 131093, + # 'disk.totalReadLatency': 131085, + # 'disk.totalWriteLatency': 131089, + # 'disk.usage': 131073, + + # disk.read/write/deviceLatency/numberRead/numberWrite + 131078, 131079, 131091, 131076, 131077, ] - #needed_ids = [ - # # sys.resourceMem* - # 262151, 262155, 262169, 262152, 262154, 262153, 262157, 262156, 262168, - #] + # Seems as this is not available in ESX 5.0 but we saw it on 5.1 + if esx_version_num > 5.0: + # sys.resourceMemConsumed + needed_ids += [ + 262171, + ] + + #needed_ids = [ + # # sys.resourceMem* + # 262151, 262155, 262169, 262152, 262154, 262153, 262157, 262156, 262168, + #] + counters = pm.get_entity_statistic(mor, needed_ids) lines = [] for counter in counters: @@ -609,6 +618,11 @@ def conv_numeric_sensor_info(value): def conv_host(value): return all_hosts.get(value) +# This is only for testing/debugging. Simply printing all counters. +if opt_dump_counters: + dump_hostsystem_counters() + sys.exit(0) + if "datastore" in mortypes: output_datastores()

11 years, 5 months

Check_MK Git: check_mk: jar_signature: New check to monitor wether or not a jar is signed and certificate is not expired

by Lars Michelsen

Module: check_mk Branch: master Commit: 2d278af967a45554e595a2f0e5dac49e263e952b URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=2d278af967a455… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 11:03:18 2013 +0200 jar_signature: New check to monitor wether or not a jar is signed and certificate is not expired --- ChangeLog | 2 + agents/plugins/jar_signature | 45 ++++++++++++++++++++++ checks/jar_signature | 86 ++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 133 insertions(+) diff --git a/ChangeLog b/ChangeLog index e6c07e1..dcc0a28 100644 --- a/ChangeLog +++ b/ChangeLog @@ -55,6 +55,8 @@ * oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script * oracle_jobs: New check to monitor oracle database job execution * oracle_rman_backups: New check to monitor state of ORACLE RMAN backups + * jar_signature: New check to monitor wether or not a jar is signed and + certificate is not expired * cisco_qos: adhere qos-bandwidth policies * check_disk_smb: WATO formalization for active check check_disk_smb * if.include: new configurable parameters for assumed input and output speed diff --git a/agents/plugins/jar_signature b/agents/plugins/jar_signature new file mode 100755 index 0000000..76bb431 --- /dev/null +++ b/agents/plugins/jar_signature @@ -0,0 +1,45 @@ +#!/bin/bash +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2013 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +# This agent uses the program "jarsigner" to read ssl certificate +# information of jar files and outputs the information to stdout +# for the Check_MK check. +# We assume that all files in the jar archive are signed with the +# same certificate. So we only deal with the last signed file here. + +JAVA_HOME=/home/oracle/bin/jdk_latest_version +JAR_PATH=/home/oracle/fmw/11gR2/as_1/forms/java/*.jar + +PATH=$JAVA_HOME/bin:$PATH + +echo "<<<jar_signature>>>" +for JAR in $JAR_PATH; do + echo "[[[${JAR##*/}]]]" + OUTPUT=$(jarsigner -verify -verbose -certs "$JAR") + LINE=$(echo "$OUTPUT" | grep -n ^s | tail -n1 | cut -d: -f1) + echo "$(echo "$OUTPUT" | tail -n +$LINE)" + echo +done + diff --git a/checks/jar_signature b/checks/jar_signature new file mode 100644 index 0000000..2247d0d --- /dev/null +++ b/checks/jar_signature @@ -0,0 +1,86 @@ +#!/usr/bin/python +# -*- encoding: utf-8; py-indent-offset: 4 -*- +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2013 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +import datetime, time + +def inventory_jar_signature(info): + inventory = [] + for line in info: + if line[0].startswith("[[["): + f = line[0][3:-3] + inventory.append((f, {})) + return inventory + +def check_jar_signature(item, params, info): + in_block = False + details = [] + in_cert = False + cert = [] + for line in info: + line = (" ".join(line)).strip() + if line == "[[[%s]]]" % item: + in_block = True + elif in_block and line.startswith("[[["): + break + elif in_block and line.startswith("X.509"): + in_cert = True + cert = [line] + elif in_block and in_cert and line.startswith("[") and not line.startswith("[entry was signed on"): + in_cert = False + cert.append(line) + details.append(cert) + + if not details: + return (2, "No certificate found") + + cert_dn, cert_valid = details[0] + + # [certificate is valid from 3/26/12 11:26 AM to 3/26/17 11:36 AM] + # [certificate will expire on 7/4/13 4:13 PM] + if "will expire on " in cert_valid: + to = cert_valid.split("will expire on ", 1)[1][:-1] + else: + to = cert_valid.split("to ", 1)[1][:-1] + to_dt = datetime.datetime(*time.strptime(to, '%m/%d/%y %I:%M %p')[:6]) + + warn, crit = 60, 30 + + state = 0 + status_txt = "" + if to_dt < datetime.datetime.now() + datetime.timedelta(days = crit): + state = 2 + status_txt = " (less than %d days)" % crit + elif to_dt < datetime.datetime.now() + datetime.timedelta(days = warn): + state = 1 + status_txt = " (less than %d days)" % warn + + return state, "Certificate expires on %s%s (%s)" % (to, status_txt, cert_dn) + +check_info['jar_signature'] = { + "service_description" : "Jar-Signature %s", + "check_function" : check_jar_signature, + "inventory_function" : inventory_jar_signature, +}

11 years, 5 months

Check_MK Git: check_mk: oracle_rman_backups: New check to monitor state of ORACLE RMAN backups

by Lars Michelsen

Module: check_mk Branch: master Commit: 7bf4cbe44c403ac55acf4b3f91981df8e37d919a URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=7bf4cbe44c403a… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 10:51:49 2013 +0200 oracle_rman_backups: New check to monitor state of ORACLE RMAN backups --- ChangeLog | 1 + agents/plugins/mk_oracle | 13 ++++++++ checkman/oracle_rman_backups | 21 ++++++++++++ checks/oracle_rman_backups | 72 ++++++++++++++++++++++++++++++++++++++++++ 4 files changed, 107 insertions(+) diff --git a/ChangeLog b/ChangeLog index 2d17310..e6c07e1 100644 --- a/ChangeLog +++ b/ChangeLog @@ -54,6 +54,7 @@ * job: Monitoring states and performance indicators of any jobs on linux systems * oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script * oracle_jobs: New check to monitor oracle database job execution + * oracle_rman_backups: New check to monitor state of ORACLE RMAN backups * cisco_qos: adhere qos-bandwidth policies * check_disk_smb: WATO formalization for active check check_disk_smb * if.include: new configurable parameters for assumed input and output speed diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle index ae35dea..98a3604 100755 --- a/agents/plugins/mk_oracle +++ b/agents/plugins/mk_oracle @@ -180,6 +180,19 @@ for SID in $SIDS; do EOF fi + if [ '$EXCLUDE' = '${EXCLUDE/rman_backups/}' ]; then + echo '<<<oracle_rman_backups>>>' + sqlplus "$SID" <<EOF + SELECT b.COMMAND_ID, a.STATUS, + to_char(a.START_TIME, 'YYYY-mm-dd_HH24:MI:SS') AS START_TIME, + to_char(a.END_TIME, 'YYYY-mm-dd_HH24:MI:SS') AS END_TIME, b.INPUT_TYPE + FROM SYS.V_\\\$RMAN_BACKUP_JOB_DETAILS a, + (SELECT input_type, max(command_id) as command_id + FROM SYS.V_\\\$RMAN_BACKUP_JOB_DETAILS WHERE STATUS<>'RUNNING' GROUP BY input_type) b + WHERE a.COMMAND_ID = b.COMMAND_ID; +EOF + fi + if [ '$EXCLUDE' = '${EXCLUDE/tablespaces/}' ]; then echo '<<<oracle_tablespaces>>>' sqlplus "$SID" <<EOF | sed 's/READ ONLY/READONLY/g' diff --git a/checkman/oracle_rman_backups b/checkman/oracle_rman_backups new file mode 100644 index 0000000..4c58d0a --- /dev/null +++ b/checkman/oracle_rman_backups @@ -0,0 +1,21 @@ +title: Oracle RMAN Backups +agents: linux +author: Lars Michelsen <lm(a)mathias-kettner.de> +license: GPL +distribution: check_mk +description: + This check monitors backup jobs configured with RMAN + (Recovery Manager) in ORACLE databases. It checks the state + of the last executed backup and outputs the execution times. + + This check needs the Check_MK {mk_oracle}-plugin installed in + the agent. Please refer to the online documentation + for how to install that plugin. + +item: + The SID of the database (as appearing in the process + name of the pmon_... process) concatenated with the name + of the job separated by a single dot. + +inventory: + One separate check for each configured backup job will be created. diff --git a/checks/oracle_rman_backups b/checks/oracle_rman_backups new file mode 100644 index 0000000..e9f2fa5 --- /dev/null +++ b/checks/oracle_rman_backups @@ -0,0 +1,72 @@ +#!/usr/bin/python +# -*- encoding: utf-8; py-indent-offset: 4 -*- +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2013 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +# <<<oracle_rman_backups>>> +# IODBSZ1 2013-04-08T16:33:53 COMPLETED 2013-04-08_16:33:54 2013-04-08_17:56:42 DB FULL +# IODBSZ1 2013-04-23T15:28:26 RUNNING 2013-04-23_15:28:28 2013-04-23_15:31:02 ARCHIVELOG + +def inventory_oracle_rman_backups(info): + inventory = [] + for line in info: + inventory.append(("%s.%s" % (line[0], " ".join(line[5:])), {})) + return inventory + +def check_oracle_rman_backups(item, params, info): + try: + sid, jobname = item.split('.') + except ValueError: + return (3, 'Invalid check item given (must be <SID>.<job_name>)') + + data = None + for line in info: + if line[0] == sid and " ".join(line[5:]) == jobname: + data = line + break + if not data: + return (3, 'Unable to find the job') + + state = 0 + output = [] + + job_state = line[2] + + txt = "State: %s" % job_state + if job_state not in [ "COMPLETED", "RUNNING" ]: + txt += " (!!)" + state = max(state, 2) + output.append(txt) + + output.append("Start-Time: %s" % line[3]) + if job_state != "RUNNING": + output.append("End-Time: %s" % line[4]) + + return (state, ", ".join(output)) + +check_info['oracle_rman_backups'] = { + "service_description" : "ORA %s RMAN Backup", + "check_function" : check_oracle_rman_backups, + "inventory_function" : inventory_oracle_rman_backups, +}

11 years, 5 months

Check_MK Git: check_mk: Fixed typo in var name

by Lars Michelsen

Module: check_mk Branch: master Commit: 9e1d26f522a163d7dc8df6abf2344838f9099c9b URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=9e1d26f522a163… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 09:35:45 2013 +0200 Fixed typo in var name --- agents/waitmax | Bin 9956 -> 0 bytes checks/esx_vsphere_counters | 4 ++-- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/agents/waitmax b/agents/waitmax deleted file mode 100755 index cb77121..0000000 Binary files a/agents/waitmax and /dev/null differ diff --git a/checks/esx_vsphere_counters b/checks/esx_vsphere_counters index 9d05388..7eae5ed 100644 --- a/checks/esx_vsphere_counters +++ b/checks/esx_vsphere_counters @@ -282,7 +282,7 @@ check_info['esx_vsphere_counters.uptime'] = { # +----------------------------------------------------------------------+ # We assume that all ramdisks have the same size (in mb) on all hosts -esx_vsphere_cunters_ramdisk_sizes = { +esx_vsphere_counters_ramdisk_sizes = { 'root': 32, 'etc': 28, 'tmp': 192, @@ -304,7 +304,7 @@ def check_esx_vsphere_counters_ramdisk(item, params, info): if name == 'sys.resourceMemConsumed' \ and instance.startswith('host/system/kernel/kmanaged/visorfs/'): name = instance.split('/')[-1] - size_mb = esx_vsphere_cunters_ramdisk_sizes[name] + size_mb = esx_vsphere_counters_ramdisk_sizes[name] used_mb = float(counter) / 1000 avail_mb = size_mb - used_mb ramdisks.append((name, size_mb, avail_mb))

11 years, 5 months

Check_MK Git: check_mk: oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script

by Lars Michelsen

Module: check_mk Branch: master Commit: 94b3b122d6bfc5150cce41c80691b985c7a74274 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=94b3b122d6bfc5… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 10:29:13 2013 +0200 oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script --- ChangeLog | 1 + agents/asmcmd.sh | 26 ++++++++++++++++++++++++++ agents/plugins/mk_oracle_asm | 38 ++++++++++++++++++++++++++++++++++++++ 3 files changed, 65 insertions(+) diff --git a/ChangeLog b/ChangeLog index 5232a64..26c5507 100644 --- a/ChangeLog +++ b/ChangeLog @@ -52,6 +52,7 @@ * openvpn_clients: new check for OpenVPN connections * if64_tplink: special new check for TP Link switches with broken SNMP output * job: Monitoring states and performance indicators of any jobs on linux systems + * oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script * cisco_qos: adhere qos-bandwidth policies * check_disk_smb: WATO formalization for active check check_disk_smb * if.include: new configurable parameters for assumed input and output speed diff --git a/agents/asmcmd.sh b/agents/asmcmd.sh new file mode 100755 index 0000000..19d3c07 --- /dev/null +++ b/agents/asmcmd.sh @@ -0,0 +1,26 @@ +#!/bin/sh +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2013 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +su - griduser -c "asmcmd $@" diff --git a/agents/plugins/mk_oracle_asm b/agents/plugins/mk_oracle_asm new file mode 100755 index 0000000..1b02bd5 --- /dev/null +++ b/agents/plugins/mk_oracle_asm @@ -0,0 +1,38 @@ +#!/bin/bash +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2010 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +# Check_MK agent plugin for monitoring ORACLE ASM + +if [ ! -e $MK_CONFDIR/asmcmd.sh ]; then + echo "$MK_CONFDIR/asmcmd.sh does not exist." >&2 + exit 1 +fi + +function asmcmd () { + $MK_CONFDIR/asmcmd.sh $@ +} + +echo "<<<oracle_asm_diskgroup>>>" +asmcmd lsdg | grep -v State | grep -v "The Oracle"

11 years, 5 months

Check_MK Git: check_mk: Added manpage for new check

by Lars Michelsen

Module: check_mk Branch: master Commit: 1d026374a21f9bf72a5ac14c684bd3dcad4f2051 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=1d026374a21f9b… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 10:41:25 2013 +0200 Added manpage for new check --- checkman/oracle_jobs | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/checkman/oracle_jobs b/checkman/oracle_jobs new file mode 100644 index 0000000..2267d1f --- /dev/null +++ b/checkman/oracle_jobs @@ -0,0 +1,25 @@ +title: Oracle Database Jobs +agents: linux +author: Lars Michelsen <lm(a)mathias-kettner.de> +license: GPL +distribution: check_mk +description: + This check monitors jobs configured in ORACLE databases. It + monitors all enabled jobs wether or not their last execution + was successfull and the next execution is scheduled. It also + records the execution time of the jobs. + + This check needs the Check_MK {mk_oracle}-plugin installed in + the agent. Please refer to the online documentation + for how to install that plugin. + +item: + The SID of the database (as appearing in the process + name of the pmon_... process) concatenated with the name + of the job separated by a single dot. + +perfdata: + One value: the duration of the last job execution in seconds. + +inventory: + One separate check for each enabled job will be created.

11 years, 5 months

Check_MK Git: check_mk: Merge branch 'master' of mathias-kettner.de: check_mk

by Lars Michelsen

Module: check_mk Branch: master Commit: 43098f49775563d2ae33d18eca96f43d0d6a2bf3 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=43098f49775563… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 10:41:35 2013 +0200 Merge branch 'master' of mathias-kettner.de:check_mk ---

11 years, 5 months

Check_MK Git: check_mk: oracle_jobs: New check to monitor oracle database job execution

by Lars Michelsen

Module: check_mk Branch: master Commit: 5cc14b9854c88ba5dd86054237ef53ee30fac8e4 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=5cc14b9854c88b… Author: Lars Michelsen <lm(a)mathias-kettner.de> Date: Mon May 6 10:36:49 2013 +0200 oracle_jobs: New check to monitor oracle database job execution --- ChangeLog | 1 + agents/plugins/mk_oracle | 14 +++++++ checks/oracle_jobs | 105 ++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 120 insertions(+) diff --git a/ChangeLog b/ChangeLog index 26c5507..eee2b89 100644 --- a/ChangeLog +++ b/ChangeLog @@ -53,6 +53,7 @@ * if64_tplink: special new check for TP Link switches with broken SNMP output * job: Monitoring states and performance indicators of any jobs on linux systems * oracle_asm_diskgroups: Added missing agent plugin + asmcmd wrapper script + * oracle_jobs: New check to monitor oracle database job execution * cisco_qos: adhere qos-bandwidth policies * check_disk_smb: WATO formalization for active check check_disk_smb * if.include: new configurable parameters for assumed input and output speed diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle index 92781ff..ae35dea 100755 --- a/agents/plugins/mk_oracle +++ b/agents/plugins/mk_oracle @@ -166,6 +166,20 @@ for SID in $SIDS; do echo \"select count(1) from v\\\$loghist where first_time > sysdate - 1/24;\" | sqlplus \"$SID\" fi + if [ '$EXCLUDE' = '${EXCLUDE/jobs/}' ]; then + echo '<<<oracle_jobs>>>' + sqlplus "$SID" <<EOF + SELECT j.OWNER, j.JOB_NAME, j.STATE, + (TRUNC(sysdate) + j.LAST_RUN_DURATION - TRUNC(sysdate)) * 86400 AS LAST_RUN_DURATION, + j.RUN_COUNT, j.ENABLED, NVL(j.NEXT_RUN_DATE, to_date('1970-01-01', 'YYYY-mm-dd')), + NVL(j.SCHEDULE_NAME, '-'), d.STATUS + FROM dba_scheduler_jobs j, dba_scheduler_job_run_details d + WHERE d.owner=j.OWNER AND d.JOB_NAME=j.JOB_NAME + AND d.LOG_ID=(SELECT max(LOG_ID) FROM dba_scheduler_job_run_details dd + WHERE dd.owner=j.OWNER and dd.JOB_NAME=j.JOB_NAME); +EOF + fi + if [ '$EXCLUDE' = '${EXCLUDE/tablespaces/}' ]; then echo '<<<oracle_tablespaces>>>' sqlplus "$SID" <<EOF | sed 's/READ ONLY/READONLY/g' diff --git a/checks/oracle_jobs b/checks/oracle_jobs new file mode 100644 index 0000000..394e247 --- /dev/null +++ b/checks/oracle_jobs @@ -0,0 +1,105 @@ +#!/usr/bin/python +# -*- encoding: utf-8; py-indent-offset: 4 -*- +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | Copyright Mathias Kettner 2013 mk(a)mathias-kettner.de | +# +------------------------------------------------------------------+ +# +# This file is part of Check_MK. +# The official homepage is at http://mathias-kettner.de/check_mk. +# +# check_mk is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation in version 2. check_mk is distributed +# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with- +# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A +# PARTICULAR PURPOSE. See the GNU General Public License for more de- +# ails. You should have received a copy of the GNU General Public +# License along with GNU Make; see the file COPYING. If not, write +# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, +# Boston, MA 02110-1301 USA. + +# <<<oracle_jobs>>> +# IODBSZ1 SYS SM$CLEAN_AUTO_SPLIT_MERGE SCHEDULED 0 763 TRUE 24.04.13 00:00:00,600000 EUROPE/VIENNA - SUCCEEDED 0 +# IODBSZ1 SYS RSE$CLEAN_RECOVERABLE_SCRIPT SCHEDULED 0 763 TRUE 24.04.13 00:00:00,100000 EUROPE/VIENNA - SUCCEEDED 0 +# IODBSZ1 SYS BSLN_MAINTAIN_STATS_JOB SCHEDULED 0 110 TRUE 29.04.13 00:00:00,300000 +01:00 BSLN_MAINTAIN_STATS_SCHED SUCCEEDED 0 +# IODBSZ1 SYS DRA_REEVALUATE_OPEN_FAILURES SCHEDULED 0 97 TRUE 01.01.70 00:00:00,000000 +02:00 MAINTENANCE_WINDOW_GROUP SUCCEEDED 0 +# IODBSZ1 SYS ORA$AUTOTASK_CLEAN SCHEDULED 0 763 TRUE 24.04.13 03:00:00,900000 EUROPE/VIENNA DAILY_PURGE_SCHEDULE SUCCEEDED 0 +# IODBSZ1 SYS PURGE_LOG SCHEDULED 0 763 TRUE 24.04.13 03:00:00,800000 EUROPE/VIENNA DAILY_PURGE_SCHEDULE SUCCEEDED 0 +# IODBSZ1 ORACLE_OCM MGMT_CONFIG_JOB SCHEDULED 0 97 TRUE 01.01.70 00:00:00,000000 +02:00 MAINTENANCE_WINDOW_GROUP SUCCEEDED 1 +# IODBSZ1 ORACLE_OCM MGMT_STATS_CONFIG_JOB SCHEDULED 0 3 TRUE 01.05.13 01:01:01,000000 +01:00 - SUCCEEDED 1 +# IODBSZ1 EXFSYS RLM$SCHDNEGACTION SCHEDULED 0 18954 TRUE 23.04.13 14:51:57,000000 +02:00 - SUCCEEDED 0 +# IODBSZ1 EXFSYS RLM$EVTCLEANUP SCHEDULED 0 18202 TRUE 23.04.13 13:41:48,200000 +01:00 - SUCCEEDED 0 + +def inventory_oracle_jobs(info): + inventory = [] + for line in info: + if line[6] == "TRUE": # only add enabled jobs + inventory.append(("%s.%s" % (line[0], line[2]), {})) + return inventory + +def check_oracle_jobs(item, params, info): + try: + sid, jobname = item.split('.') + except ValueError: + return (3, 'Invalid check item given (must be <SID>.<job_name>)') + + data = None + for line in info: + if line[0] == sid and line[2] == jobname: + data = line + break + if not data: + return (3, 'Unable to find the job') + + state = 0 + output = [] + perfdata = [] + + job_state = line[3] + + txt = "Job-State: %s" % job_state + if job_state == "BROKEN": + txt += " (!!)" + state = max(state, 2) + output.append(txt) + + txt = "Enabled: %s" % (line[6] == "TRUE" and "Yes" or "No") + if line[6] != "TRUE": + txt += " (!)" + state = max(state, 1) + output.append(txt) + + last_duration = int(line[4]) + output.append("Last Duration: %s" % get_age_human_readable(last_duration)) + perfdata.append(("duration", last_duration)) + + # 01.05.13 01:01:01,000000 +01:00 + next_run = " ".join(line[7:9]) + if next_run.startswith("01.01.70 00:00:00"): + if line[-1] == "-": + next_run = "not scheduled (!)" + state = max(state, 1) + else: + next_run = line[10] + output.append("Next Run: %s" % next_run) + + txt = "Last Run Status: %s" % (line[11]) + if line[11] != "SUCCEEDED": + txt += " (!!)" + state = max(state, 2) + output.append(txt) + + return (state, ", ".join(output), perfdata) + +check_info['oracle_jobs'] = { + "service_description" : "ORA %s Job", + "check_function" : check_oracle_jobs, + "inventory_function" : inventory_oracle_jobs, + "has_perfdata" : True, +}

11 years, 5 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

Checkmk git commits