Checkmk git commits

checkmk-commits@lists.checkmk.com

1 participants
64140 discussions

Check_MK Git: check_mk: mk_oracle: port to HP-UX

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: b43a09daabfe23e516ff0014dd4f703e568aa21b URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=b43a09daabfe23… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Fri Jan 28 12:43:10 2011 +0100 mk_oracle: port to HP-UX --- ChangeLog | 2 +- agents/{ => plugins}/mk_logwatch | 0 agents/plugins/mk_oracle | 23 +++++++++++++++-------- agents/{plugins => }/sqlplus.sh | 4 +++- checkman/oracle_logswitches | 2 +- checkman/oracle_sessions | 2 +- checkman/oracle_tablespaces | 2 +- 7 files changed, 22 insertions(+), 13 deletions(-) diff --git a/ChangeLog b/ChangeLog index f83e970..6b8edaa 100644 --- a/ChangeLog +++ b/ChangeLog @@ -21,7 +21,7 @@ * drbd: Fixed var typo which prevented inventory of drbd general check (Thanks to Andreas Behler) * mk_oracle: new agent plugin for monitoring ORACLE (currently only - on Linux, but easily portable to other Unices) + on Linux and HP-UX, but easily portable to other Unices) * oracle_sessions: new check for monitoring the current number of active database sessions. * oracle_logswitches: new check for monitoring the number of logswitches diff --git a/agents/mk_logwatch b/agents/plugins/mk_logwatch similarity index 100% rename from agents/mk_logwatch rename to agents/plugins/mk_logwatch diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle index a0faf17..4f311ea 100644 --- a/agents/plugins/mk_oracle +++ b/agents/plugins/mk_oracle @@ -26,23 +26,30 @@ # Check_MK agent plugin for monitoring ORACLE databases # Get list of all running databases -SIDS=$(UNIX95=true ps ax -o args | sed -n '/^ora_pmon_$[^ ]*$/s//\1/p') +if [ $(uname -s) = Linux ] +then + PS="ps ax -o args" +else + PS="ps -ef -o args" +fi + +SIDS=$(UNIX95=true $PS | sed -n '/^ora_pmon_$[^ ]*$/s//\1/p') if [ -z "$SIDS" ] ; then exit 0 ; fi # Make an sqlplus query, clean up the result and add an artificial # column with the SID at the front of each line. If the query fails, # no output at all is made. -function sqlplus () -{ +function sqlplus +{ OUTPUT=$({ echo 'set pages 0' ; echo 'set lines 8000' ; echo 'set feedback off'; cat ; } | $MK_CONFDIR/sqlplus.sh $1) || return 1 - echo "${OUTPUT}" | sed -e 's/[[:space:]]\+/ /g' -e '/^[[:space:]]*$/d' -e "s/^/$1 /" + echo "${OUTPUT}" | sed -e 's/[[:space:]][[:space:]]*/ /g' -e '/^[[:space:]]*$/d' -e "s/^/$1 /" } # Sessions echo '<<<oracle_sessions>>>' for SID in $SIDS do - echo "select count(*) from v"'$'"session where status = 'ACTIVE';" | sqlplus "$SID" + echo "select count(*) from v"'$'"session where status = 'ACTIVE';" | sqlplus "$SID" done echo '<<<oracle_logswitches>>>' @@ -53,13 +60,13 @@ select count(*) from v\$loghist where first_time > sysdate - 1/24; EOF done - + # Tablespaces echo '<<<oracle_tablespaces>>>' for SID in $SIDS do - sqlplus "$SID" <<EOF -select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, f.ONLINE_STATUS, t.BLOCK_SIZE, t.status from dba_data_files f, dba_tablespaces t where f.tablespace_name = t.tablespace_name + sqlplus "$SID" <<EOF | sed 's/READ ONLY/READONLY/g' +select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, f.ONLINE_STATUS, t.BLOCK_SIZE, t.status from dba_data_files f, dba_tablespaces t where f.tablespace_name = t.tablespace_name UNION select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, 'TEMP', t.BLOCK_SIZE, t.status from dba_temp_files f, dba_tablespaces t where f.tablespace_name = t.tablespace_name; EOF diff --git a/agents/plugins/sqlplus.sh b/agents/sqlplus.sh similarity index 95% rename from agents/plugins/sqlplus.sh rename to agents/sqlplus.sh index 929eab6..f1fb379 100755 --- a/agents/plugins/sqlplus.sh +++ b/agents/sqlplus.sh @@ -1,5 +1,7 @@ #!/bin/sh +# EXAMPLE + # This script is called by the Check_MK ORACLE plugin in order to # execute an SQL query. @@ -15,7 +17,7 @@ if [ -z "$ORACLE_SID" ] ; then exit 1 fi -su - nagios -c " +su nagios -c " ORACLE_SID=$ORACLE_SID ORAENV_ASK=NO . /usr/local/bin/oraenv diff --git a/checkman/oracle_logswitches b/checkman/oracle_logswitches index 77623db..0133e06 100644 --- a/checkman/oracle_logswitches +++ b/checkman/oracle_logswitches @@ -1,5 +1,5 @@ title: Check log switch activity of ORACLE database -agents: linux +agents: linux, hpux author: Mathias Kettner <mk(a)mathias-kettner.de> license: GPL distribution: check_mk diff --git a/checkman/oracle_sessions b/checkman/oracle_sessions index 5f2571d..ff2caa9 100644 --- a/checkman/oracle_sessions +++ b/checkman/oracle_sessions @@ -1,5 +1,5 @@ title: Check number of active sessions in ORACLE database -agents: linux +agents: linux, hpux author: Mathias Kettner <mk(a)mathias-kettner.de> license: GPL distribution: check_mk diff --git a/checkman/oracle_tablespaces b/checkman/oracle_tablespaces index f94aa09..1dc7ee6 100644 --- a/checkman/oracle_tablespaces +++ b/checkman/oracle_tablespaces @@ -1,5 +1,5 @@ title: Check various aspects of ORACLE tablespaces -agents: linux +agents: linux, hpux author: Mathias Kettner <mk(a)mathias-kettner.de> license: GPL distribution: check_mk

13 years, 7 months

Check_MK Git: check_mk: Removed obsolete SNMP misc checks blade_misc, ironport_misc and snial_sml

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: ba6ecb22f0ea6c3f0319fc07d783aeaa2bfab156 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=ba6ecb22f0ea6c… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 09:40:04 2011 +0100 Removed obsolete SNMP misc checks blade_misc, ironport_misc and snial_sml --- .bugs/110 | 10 ++++++++++ ChangeLog | 4 ++++ checks/blade_misc | 12 ++++++++---- checks/ironport_misc | 28 ++++++---------------------- checks/snia_sml | 25 +++++++------------------ 5 files changed, 35 insertions(+), 44 deletions(-) diff --git a/.bugs/110 b/.bugs/110 new file mode 100644 index 0000000..5583786 --- /dev/null +++ b/.bugs/110 @@ -0,0 +1,10 @@ +Title: Remove obsolete code of snmp_info_single +Component: core +Benefit: 1 +State: open +Cost: 1 +Date: 2011-01-27 09:39:10 +Class: cleanup + +Obsolete code formerly used by snmp_info_single should be removed +from the code. diff --git a/ChangeLog b/ChangeLog index 64f540e..73bcea5 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,4 +1,8 @@ 1.1.9i6: + INCOMPATIBLE CHANGES: + * Removed out-dated checks blade_misc, ironport_misc and snia_sml. Replaced + with dummy checks begin always UNKNOWN. + Core, Setup, etc.: * cmk -D: show ip address of host * Fix SNMP inventory find snmp misc checks inspite of negative scan function diff --git a/checks/blade_misc b/checks/blade_misc index 9f468f7..52f183e 100644 --- a/checks/blade_misc +++ b/checks/blade_misc @@ -25,8 +25,12 @@ # Boston, MA 02110-1301 USA. -check_info['blade_misc'] = (check_snmp_misc, "SENSOR %s", 1, inventory_snmp_misc) -snmp_info_single['blade_misc'] = ( "BLADE-MIB", "1.3.6.1.4.1.2.3.51.2.2", [ "1", "2", "3.1", "3.2" ] ) +def check_blade_misc(item, params, info): + return (3, "UNKNOWN - Sorry. Check not implemented in this version.") + +check_info['blade_misc'] = ( + check_blade_misc, + "%s", + 0, + no_inventory_possible) -snmp_scan_functions['blade_misc'] = \ - lambda oid: oid("1.3.6.1.2.1.1.1.0") == '"BladeCenter Management Module"' diff --git a/checks/ironport_misc b/checks/ironport_misc index 859f42f..afd436c 100644 --- a/checks/ironport_misc +++ b/checks/ironport_misc @@ -25,28 +25,12 @@ # Boston, MA 02110-1301 USA. +def check_ironport_misc(item, params, info): + return (3, "UNKNOWN - Sorry. Check not implemented in this version.") + check_info['ironport_misc'] = ( - check_snmp_misc, + check_ironport_misc, "%s", - 1, - inventory_snmp_misc) + 0, + no_inventory_possible) -snmp_info_single['ironport_misc'] = ( - "ASYNCOS-MAIL-MIB", - "1.3.6.1.4.1.15497.1.1.1", - [ "1.0", - "2.0", - "3.0", - "4.0", - "9.1.2.1", - "10.1.2.1", - "10.1.2.2", - "13.1.3.1", - "13.1.3.2", - "13.1.3.3", - "15.0", - "16.0", - "18.1.2.1", - "18.1.2.2", - "19.0", - "20.0" ] ) diff --git a/checks/snia_sml b/checks/snia_sml index b4b8407..58c0d83 100644 --- a/checks/snia_sml +++ b/checks/snia_sml @@ -25,23 +25,12 @@ # Boston, MA 02110-1301 USA. -# This inventory collects the current state of several SNMP -# variables. The check monitors if they are unchanged +def check_snia_sml(item, params, info): + return (3, "UNKNOWN - Sorry. Check not implemented in this version.") -check_info['snia_sml'] = (check_snmp_fixed, "SNMP %s", 0, inventory_snmp_fixed) -# e.g. IBM TAPELIB 3584 +check_info['snia_sml'] = ( + check_snia_sml, + "%s", + 0, + no_inventory_possible) -snmp_info_single['snia_sml'] = ( "SNIA-SML-MIB", "1.3.6.1.4.1.14851.3.1", - [ "4.5", # SNIA-SML-MIB::chassis-SecurityBreach - "4.6", # SNIA-SML-MIB::chassis-IsLocked - "4.10.1.5", # SNIA-SML-MIB::subChassis-LockPresent - "4.10.1.6", # SNIA-SML-MIB::subChassis-SecurityBreach - "4.10.1.7", # SNIA-SML-MIB::subChassis-IsLocked - "6.2.1.5", # SNIA-SML-MIB::mediaAccessDevice-Availability - "6.2.1.11", # SNIA-SML-MIB::mediaAccessDevice-OperationalStatus - "11.2.1.8", # SNIA-SML-MIB::changerDevice-Availability - "11.2.1.9", # SNIA-SML-MIB::changerDevice-OperationalStatus - "12.2.1.6", # SNIA-SML-MIB::scsiProtocolController-Availability - "12.2.1.4", # SNIA-SML-MIB::scsiProtocolController-OperationalStatus - "15.2.1.6", # SNIA-SML-MIB::fCPortController-OperationalStatus - ] )

13 years, 7 months

Check_MK Git: check_mk: mk_oracle: new oracle agent plugin and first check

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 9db80eb331300317174fa8b5fb38e083b33d0d0d URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=9db80eb3313003… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 12:44:12 2011 +0100 mk_oracle: new oracle agent plugin and first check --- ChangeLog | 5 +++- agents/plugins/mk_oracle | 64 +++++++++++++++++++++++++++++++++++++++++++++ agents/plugins/sqlplus.sh | 22 +++++++++++++++ checkman/oracle_sessions | 42 +++++++++++++++++++++++++++++ checks/oracle_sessions | 52 ++++++++++++++++++++++++++++++++++++ 5 files changed, 184 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index 73bcea5..e6dd36f 100644 --- a/ChangeLog +++ b/ChangeLog @@ -19,7 +19,10 @@ * hpux_serviceguard: new check for monitoring HP-UX Serviceguard * drbd: Fixed var typo which prevented inventory of drbd general check (Thanks to Andreas Behler) - + * mk_oracle: new agent plugin for monitoring ORACLE (currently only + on Linux, but easily portable to other Unices) + * oracle_sessions: new check for monitoring the current number of active + database sessions. 1.1.9i5: Multisite: diff --git a/agents/plugins/mk_oracle b/agents/plugins/mk_oracle new file mode 100644 index 0000000..3f080b0 --- /dev/null +++ b/agents/plugins/mk_oracle @@ -0,0 +1,64 @@ +#!/bin/sh +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | 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 databases + +# Get list of all running databases +SIDS=$(UNIX95=true ps ax -o args | sed -n '/^ora_pmon_$[^ ]*$/s//\1/p') +if [ -z "$SIDS" ] ; then exit 0 ; fi + +# Make an sqlplus query, clean up the result and add an artificial +# column with the SID at the front of each line. If the query fails, +# no output at all is made. +function sqlplus () +{ + OUTPUT=$({ echo 'set pages 0' ; echo 'set lines 8000' ; cat ; } | $MK_CONFDIR/sqlplus.sh $1) || return 1 + echo "${OUTPUT}" | sed -e 's/[[:space:]]\+/ /g' -e '/^[[:space:]]*$/d' -e "s/^/$1 /" +} + +# Sessions +echo '<<<oracle_sessions>>>' +for SID in $SIDS +do + echo "select count(*) from v"'$'"session where status = 'ACTIVE';" | sqlplus "$SID" +done + +echo '<<<oracle_logswitches>>>' +for SID in $SIDS +do + sqlplus "$SID" <<EOF +select count(*) from v\$loghist where first_time > sysdate - 1/24; +EOF +done + +# Tablespaces +echo '<<<oracle_tablespaces>>>' +for SID in $SIDS +do + sqlplus "$SID" <<EOF +select f.file_name, f.tablespace_name, f.status, f.AUTOEXTENSIBLE, f.blocks, f.maxblocks, f.USER_BLOCKS, f.INCREMENT_BY, f.ONLINE_STATUS, t.BLOCK_SIZE, t.status from dba_data_files f, dba_tablespaces t where f.tablespace_name = t.tablespace_name; +EOF +done + diff --git a/agents/plugins/sqlplus.sh b/agents/plugins/sqlplus.sh new file mode 100755 index 0000000..929eab6 --- /dev/null +++ b/agents/plugins/sqlplus.sh @@ -0,0 +1,22 @@ +#!/bin/sh + +# This script is called by the Check_MK ORACLE plugin in order to +# execute an SQL query. + +# It is your task to adapt this script so that the ORACLE environment +# is setup and the correct user chosen to execute sqlplus. + +# The script we get the query on stdin and shall output the +# result on stdout. Error messages goes to stderr. + +ORACLE_SID=$1 +if [ -z "$ORACLE_SID" ] ; then + echo "Usage: $0 ORACLE_SID" >&2 + exit 1 +fi + +su - nagios -c " +ORACLE_SID=$ORACLE_SID +ORAENV_ASK=NO +. /usr/local/bin/oraenv +sqlplus -s /" diff --git a/checkman/oracle_sessions b/checkman/oracle_sessions new file mode 100644 index 0000000..5f2571d --- /dev/null +++ b/checkman/oracle_sessions @@ -0,0 +1,42 @@ +title: Check number of active sessions in ORACLE database +agents: linux +author: Mathias Kettner <mk(a)mathias-kettner.de> +license: GPL +distribution: check_mk +description: + This check monitors the number of active sessions in an + ORACLE database. You can set warn/crit levels. + + 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). + +examples: + # Set global default values to 20 sessions for + # warning and 100 sessions for critical + oracle_sessions_default_levels = (20, 100) + + # Set higher levels for productive systems + # (having the host tag 'prod') + check_parameters += [ + ( (80, 160), [ 'prod' ], ALL_HOSTS, [ "ORA .* sessions" ]) + ] + +perfdata: + One value: the current number of active sessions. + +inventory: + One separate check for each database found running will + be created. + +[parameters] +warning(int): The number of active sessions triggering a warning +critical(int): The number of active sessions making the check critical + +[configuration] +oracle_sessions_default_levels(int, int): Global default levels used for all checks which have no specific configuration. This is preset to {(50, 100)}. + diff --git a/checks/oracle_sessions b/checks/oracle_sessions new file mode 100644 index 0000000..706f211 --- /dev/null +++ b/checks/oracle_sessions @@ -0,0 +1,52 @@ +#!/usr/bin/python +# -*- encoding: utf-8; py-indent-offset: 4 -*- +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | 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. + +# <<<oracle_sessions>>> +# pengt 15 +# hirni 22 + +oracle_sessions_default_levels = (50, 100) + +def inventory_oracle_sessions(checkname, info): + return [ (line[0], "oracle_sessions_default_levels") for line in info if len(line) >= 2 ] + +def check_oracle_sessions(item, params, info): + for line in info: + if line[0] == item: + warn, crit = params + sessions = int(line[1]) + infotext = " - %d active sessions" % sessions + perfdata = [("sessions", sessions, warn, crit)] + if sessions >= crit: + return (2, "CRIT" + infotext, perfdata) + elif sessions >= warn: + return (1, "WARN" + infotext, perfdata) + else: + return (0, "OK" + infotext, perfdata) + return (2, "UNKNOWN - Database not existant or not running") + +check_info['oracle_sessions'] = (check_oracle_sessions, "ORA %s Sessions", 1, inventory_oracle_sessions ) +

13 years, 7 months

Check_MK Git: check_mk: Fix MB/GB output (fraction part was zero)

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 79479d34c84ff67a047d91f9a389be81e4c72579 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=79479d34c84ff6… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 15:44:25 2011 +0100 Fix MB/GB output (fraction part was zero) --- ChangeLog | 1 + modules/check_mk_base.py | 2 +- 2 files changed, 2 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index 2f81b6b..9b5a82a 100644 --- a/ChangeLog +++ b/ChangeLog @@ -6,6 +6,7 @@ Core, Setup, etc.: * cmk -D: show ip address of host * Fix SNMP inventory find snmp misc checks inspite of negative scan function + * Fix output of MB and GB values (fraction part was zero) Checks & Agents: * megaraid_ldisks: remove debug output diff --git a/modules/check_mk_base.py b/modules/check_mk_base.py index cb15778..6bfb6eb 100755 --- a/modules/check_mk_base.py +++ b/modules/check_mk_base.py @@ -1033,7 +1033,7 @@ def savefloat(f): # Takes bytes as integer and returns a string which represents the bytes in a # more human readable form scaled to GB/MB/KB -def get_bytes_human_readable(b, base=1024): +def get_bytes_human_readable(b, base=1024.0): # Handle negative bytes correctly prefix = '' if b < 0:

13 years, 7 months

Check_MK Git: check_mk: Updated bug entries

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 915acbcd887807cab7467a34c97ce1aa90ea1f77 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=915acbcd887807… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 17:03:54 2011 +0100 Updated bug entries --- .bugs/111 | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/.bugs/111 b/.bugs/111 new file mode 100644 index 0000000..117e19c --- /dev/null +++ b/.bugs/111 @@ -0,0 +1,11 @@ +Title: View editor does not save tool tips (in group header) +Component: multisite +Benefit: 2 +State: open +Cost: 1 +Date: 2011-01-27 17:02:58 +Class: bug + +When you add tooltips to a group column in the view editor, +the tooltip is not saved. This might appear at normal columns +also, but is not tested.

13 years, 7 months

Check_MK Git: check_mk: oracle_tablespaces: new check for ORACLE monitoring

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 8d9daccc9e89b20e142689e3ebe727afca01b4ff URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=8d9daccc9e89b2… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 18:21:32 2011 +0100 oracle_tablespaces: new check for ORACLE monitoring --- ChangeLog | 2 + agents/plugins/mk_oracle | 8 +- checkman/oracle_tablespaces | 60 +++++++++ checks/oracle_tablespaces | 161 +++++++++++++++++++++++ pnp-rraconf/check_mk-oracle_tablespaces.rra.cfg | 1 + pnp-templates/check_mk-oracle_tablespaces.php | 60 +++++++++ 6 files changed, 289 insertions(+), 3 deletions(-) Diff: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commitdiff;h=8d9daccc9e…

13 years, 7 months

Check_MK Git: check_mk: oracle_logswitches: new check for oracle logswitches

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 202144b4532742aae36ef6551e5d4892ccff076c URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=202144b4532742… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 14:21:09 2011 +0100 oracle_logswitches: new check for oracle logswitches --- ChangeLog | 2 + checkman/oracle_logswitches | 41 +++++++++++++++++++++++++++++++++ checks/oracle_logswitches | 53 +++++++++++++++++++++++++++++++++++++++++++ checks/oracle_sessions | 4 +- 4 files changed, 98 insertions(+), 2 deletions(-) diff --git a/ChangeLog b/ChangeLog index e6dd36f..2f81b6b 100644 --- a/ChangeLog +++ b/ChangeLog @@ -23,6 +23,8 @@ on Linux, but easily portable to other Unices) * oracle_sessions: new check for monitoring the current number of active database sessions. + * oracle_logswitches: new check for monitoring the number of logswitches + of an ORACLE instances in the last 60 minutes. 1.1.9i5: Multisite: diff --git a/checkman/oracle_logswitches b/checkman/oracle_logswitches new file mode 100644 index 0000000..77623db --- /dev/null +++ b/checkman/oracle_logswitches @@ -0,0 +1,41 @@ +title: Check log switch activity of ORACLE database +agents: linux +author: Mathias Kettner <mk(a)mathias-kettner.de> +license: GPL +distribution: check_mk +description: + This check monitors the number of log switches of an ORACLE + database instance in the last 60 minutes. You can set levels + for upper and lower bounds. + + 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). + +examples: + # Set global default values. Make it critical if there + # is only 1 or 0 logswitches or 100 or more in the last + # hour. + oracle_logswitches_default_levels = (1, 3, 30 100) + +perfdata: + One value: the number of log switches in the last 60 minutes. + +inventory: + One separate check for each database found running will + be created. + +[parameters] +lo_crit(int): The check will get critical if only that many (or fewer) log switches appeared in the + last 60 minutes. Set this to {-1} in order to disable this bound. +lo_warn(int): Lower warning level. +hi_warn(int): Make the check warn if there were at least that many log switches in the last 60 minutes. +hi_crit(int): Upper critical level. + +[configuration] +oracle_logswitches_default_levels(int, int, int, int): Global default levels used for all checks which have no specific configuration. This is preset to {(-1, -1, 50, 100)}. + diff --git a/checks/oracle_logswitches b/checks/oracle_logswitches new file mode 100644 index 0000000..a1d524d --- /dev/null +++ b/checks/oracle_logswitches @@ -0,0 +1,53 @@ +#!/usr/bin/python +# -*- encoding: utf-8; py-indent-offset: 4 -*- +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | 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. + +# <<<oracle_logswitches>>> +# pengt 15 +# hirni 22 + +oracle_logswitches_default_levels = (-1, -1, 50, 100) + +def inventory_oracle_logswitches(checkname, info): + return [ (line[0], "oracle_logswitches_default_levels") for line in info if len(line) >= 2 ] + +def check_oracle_logswitches(item, params, info): + for line in info: + if line[0] == item: + locrit, lowarn, warn, crit = params + logswitches = int(line[1]) + infotext = " - %d log switches in the last 60 minutes (levels at %d/%d .. %d/%d)" \ + % (logswitches, locrit, lowarn, warn, crit) + perfdata = [("logswitches", logswitches, warn, crit)] + if logswitches >= crit or logswitches <= locrit: + return (2, "CRIT" + infotext, perfdata) + elif logswitches >= warn or logswitches <= lowarn: + return (1, "WARN" + infotext, perfdata) + else: + return (0, "OK" + infotext, perfdata) + return (2, "UNKNOWN - Database not existing or not running") + +check_info['oracle_logswitches'] = (check_oracle_logswitches, "ORA %s Logswitches", 1, inventory_oracle_logswitches ) + diff --git a/checks/oracle_sessions b/checks/oracle_sessions index 706f211..d71a67d 100644 --- a/checks/oracle_sessions +++ b/checks/oracle_sessions @@ -38,7 +38,7 @@ def check_oracle_sessions(item, params, info): if line[0] == item: warn, crit = params sessions = int(line[1]) - infotext = " - %d active sessions" % sessions + infotext = " - %d active sessions (levels at %d/%d)" % (sessions, warn, crit) perfdata = [("sessions", sessions, warn, crit)] if sessions >= crit: return (2, "CRIT" + infotext, perfdata) @@ -46,7 +46,7 @@ def check_oracle_sessions(item, params, info): return (1, "WARN" + infotext, perfdata) else: return (0, "OK" + infotext, perfdata) - return (2, "UNKNOWN - Database not existant or not running") + return (2, "UNKNOWN - Database not existing or not running") check_info['oracle_sessions'] = (check_oracle_sessions, "ORA %s Sessions", 1, inventory_oracle_sessions )

13 years, 7 months

Check_MK Git: check_mk: Added perfometer for ORACLE tablespaces

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 94b78d0c946029a6122cb45491d8de55cdf837b6 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=94b78d0c946029… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 18:37:19 2011 +0100 Added perfometer for ORACLE tablespaces --- pnp-templates/check_mk-oracle_tablespaces.php | 12 ------------ web/plugins/perfometer/check_mk.py | 14 ++++++++++++++ 2 files changed, 14 insertions(+), 12 deletions(-) diff --git a/pnp-templates/check_mk-oracle_tablespaces.php b/pnp-templates/check_mk-oracle_tablespaces.php index 107203c..88c9371 100644 --- a/pnp-templates/check_mk-oracle_tablespaces.php +++ b/pnp-templates/check_mk-oracle_tablespaces.php @@ -45,16 +45,4 @@ $def[1] .= "AREA:used_gb#f0b000:\"Used by user data\" " ; $def[1] .= "LINE:used_gb#806000:\"\" " ; $def[1] .= "GPRINT:used_gb:LAST:\"%2.2lfGB\" "; -# $def[1] .= "AREA:system#ff6000:\"System\" " ; -# $def[1] .= "GPRINT:system:LAST:\"%2.1lf%%\" " ; -# -# $def[1] .= "AREA:user#60f020:\"User\":STACK " ; -# $def[1] .= "GPRINT:user:LAST:\"%2.1lf%%\" " ; -# -# $def[1] .= "AREA:wait#00b0c0:\"$thirdname\":STACK " ; -# $def[1] .= "GPRINT:wait:LAST:\"%2.1lf%%\" " ; -# -# $def[1] .= "LINE:sum#004080:\"Utilization\" " ; -# $def[1] .= "GPRINT:sum:LAST:\"%2.1lf%%\" " ; - ?> diff --git a/web/plugins/perfometer/check_mk.py b/web/plugins/perfometer/check_mk.py index 7c12b14..2ef7a81 100644 --- a/web/plugins/perfometer/check_mk.py +++ b/web/plugins/perfometer/check_mk.py @@ -211,3 +211,17 @@ perfometers["check_mk-if"] = performeter_check_mk_if perfometers["check_mk-if64"] = performeter_check_mk_if perfometers["check_mk-hpux_if"] = performeter_check_mk_if +def performeter_oracle_tablespaces(row, check_command, perf_data): + current = float(perf_data[0][1]) + used = float(perf_data[1][1]) + max = float(perf_data[2][1]) + used_perc = used / max * 100 + curr_perc = (current / max * 100) - used_perc + h = '<table><tr>' + h += perfometer_td(used_perc, "#f0b000"); + h += perfometer_td(curr_perc, "#00ff80"); + h += perfometer_td(100 - used_perc - curr_perc, "#80c0ff"); + h += '</tr></table>' + return "%.1f%%" % used_perc, h + +perfometers["check_mk-oracle_tablespaces"] = performeter_oracle_tablespaces

13 years, 7 months

Check_MK Git: check_mk: new PNP template for oracle_sessions

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 833a92f16783182df8653d6bb800eec6062aa29a URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=833a92f1678318… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Fri Jan 28 09:23:21 2011 +0100 new PNP template for oracle_sessions --- pnp-templates/check_mk-oracle_sessions.php | 37 ++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/pnp-templates/check_mk-oracle_sessions.php b/pnp-templates/check_mk-oracle_sessions.php new file mode 100644 index 0000000..112b3c7 --- /dev/null +++ b/pnp-templates/check_mk-oracle_sessions.php @@ -0,0 +1,37 @@ +<?php +# +------------------------------------------------------------------+ +# | ____ _ _ __ __ _ __ | +# | / ___| |__ ___ ___| | __ | \/ | |/ / | +# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / | +# | | |___| | | | __/ (__| < | | | | . \ | +# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ | +# | | +# | 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. + +$title = str_replace("_", " ", $servicedesc); +$opt[1] = "--vertical-label 'active sessions' -l0 -u $CRIT[1] --title \"$title\" "; + +$def[1] = "DEF:sessions=$RRDFILE[1]:$DS[1]:MAX "; +$def[1] .= "AREA:sessions#00ff48: "; +$def[1] .= "LINE:sessions#008f38: "; +$def[1] .= "GPRINT:sessions:LAST:\"last\: %3.0lf\" "; +$def[1] .= "GPRINT:sessions:AVERAGE:\"avg\: %3.0lf\" "; +$def[1] .= "GPRINT:sessions:MAX:\"max\: %3.0lf\" "; +$def[1] .= "HRULE:$WARN[1]#ffcf00:\"Warning at $WARN[1]\" "; +$def[1] .= "HRULE:$CRIT[1]#ff0000:\"Critical at $CRIT[1]\" "; +?>

13 years, 7 months

Check_MK Git: check_mk: Fix SNMP scan bug with misc checks

by git＠mathias-kettner.de

Module: check_mk Branch: master Commit: 482747a27978a9398ca129a41455ac4e5fd6b4ce URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=482747a27978a9… Author: Mathias Kettner <mk(a)mathias-kettner.de> Date: Thu Jan 27 09:26:29 2011 +0100 Fix SNMP scan bug with misc checks --- ChangeLog | 1 + modules/check_mk.py | 2 +- 2 files changed, 2 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index c7c910c..64f540e 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,6 +1,7 @@ 1.1.9i6: Core, Setup, etc.: * cmk -D: show ip address of host + * Fix SNMP inventory find snmp misc checks inspite of negative scan function Checks & Agents: * megaraid_ldisks: remove debug output diff --git a/modules/check_mk.py b/modules/check_mk.py index 2a06e50..755bc6e 100755 --- a/modules/check_mk.py +++ b/modules/check_mk.py @@ -675,7 +675,7 @@ def snmp_scan(hostname, ipaddress): # Now try all checks not having a scan function for checktype in check_info.keys(): datatype = checktype.split('.')[0] - if datatype not in snmp_info: + if not check_uses_snmp(datatype): continue # no snmp check if checktype not in snmp_scan_functions: if opt_verbose:

13 years, 7 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

Checkmk git commits