From 1e2387474a449452b78520b9ad96a8b4b5e99722 Mon Sep 17 00:00:00 2001
From: Harald Pfeiffer <coding@lirion.de>
Date: Wed, 17 Apr 2019 19:07:19 +0200
Subject: initial commit of source fetch
---
.../percona-nagios-plugins/Changelog | 115 ++++
.../percona-nagios-plugins/Makefile | 13 +
.../percona-nagios-plugins/control | 7 +
.../percona-nagios-plugins/copyright | 12 +
.../nagios/bin/pmp-check-aws-rds.py | 562 +++++++++++++++++++
.../nagios/bin/pmp-check-lvm-snapshots | 187 +++++++
.../nagios/bin/pmp-check-mongo.py | 594 +++++++++++++++++++++
.../nagios/bin/pmp-check-mysql-deadlocks | 189 +++++++
.../nagios/bin/pmp-check-mysql-deleted-files | 286 ++++++++++
.../nagios/bin/pmp-check-mysql-file-privs | 289 ++++++++++
.../nagios/bin/pmp-check-mysql-innodb | 368 +++++++++++++
.../nagios/bin/pmp-check-mysql-pidfile | 291 ++++++++++
.../nagios/bin/pmp-check-mysql-processlist | 323 +++++++++++
.../nagios/bin/pmp-check-mysql-replication-delay | 280 ++++++++++
.../nagios/bin/pmp-check-mysql-replication-running | 242 +++++++++
.../nagios/bin/pmp-check-mysql-status | 482 +++++++++++++++++
.../nagios/bin/pmp-check-mysql-ts-count | 210 ++++++++
.../nagios/bin/pmp-check-pt-table-checksum | 239 +++++++++
.../nagios/bin/pmp-check-unix-memory | 207 +++++++
19 files changed, 4896 insertions(+)
create mode 100644 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Changelog
create mode 100644 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Makefile
create mode 100644 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/control
create mode 100644 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/copyright
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-aws-rds.py
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-lvm-snapshots
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mongo.py
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deadlocks
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deleted-files
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-file-privs
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-innodb
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-pidfile
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-processlist
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-delay
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-running
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-status
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-ts-count
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-pt-table-checksum
create mode 100755 nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-unix-memory
(limited to 'nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins')
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Changelog b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Changelog
new file mode 100644
index 0000000..cb12581
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Changelog
@@ -0,0 +1,115 @@
+2014-03-20: version 1.1.3
+-------------------------
+* Introduced more secure location of PHP script configs to harden a Cacti setup (bug #1295006)
+
+2014-03-14: version 1.1.2
+-------------------------
+* Added Nagios plugin and Cacti template for Amazon RDS
+* Added Nagios config template to the documentation
+* Added an option to pmp-check-pt-table-checksum to check MAX(ts) of latest checksum
+* Added generic Nagios plugin for PT tables
+* Extended pmp-check-mysql-processlist with max user connections check
+* Zabbix MySQL.running-slave item failed with MySQL 5.6 (bug 1272358)
+* ss_get_mysql_stats and MariaDB does not use have_response_time_distribution (bug 1285888)
+* Cacti Monitoring plugins and SNMP via TCP (bug 1268552)
+
+2013-12-30: version 1.1.1
+-------------------------
+* Cacti mysql graphs stop working with data input field "server-id" after 1.1 upgrade (bug 1264814)
+* Non-integer poller errors for MySQL Query Response Time (bug 1264353)
+
+2013-12-16: version 1.1
+-------------------------
+* Added MySQL template for Zabbix 2.0.x (first release)
+* Added FreeBSD support to Nagios plugins, partially rewritten pmp-check-unix-memory (bugs 1249575, 1244081)
+* Added new options to ss_get_mysql_stats.php to better support pt-heartbeat (bugs 1253125, 1253130)
+* ss_get_mysql_stats.php script was opening multiple connections to the server (bug 1255371)
+* sql query for idle_blocker_duraction check in pmp-check-mysql-innodb did not conform sql mode of ONLY_FULL_GROUP_BY (bug #1240417)
+
+2013-10-02: version 1.0.5
+-------------------------
+
+* Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857)
+* Added user info to the idle_blocker_duration check of pmp-check-mysql-innodb (bug 1215317)
+* Extended pmp-check-mysql-processlist with more locking states (bug 1213859)
+* ss_get_mysql_stats.php did not work with custom mysql port (bug 1213862)
+* ss_get_mysql_stats.php silently failed when a query returns too many rows (bug 1225070)
+* Wrong description of percona-cacti-templates deb package (bug 1217782)
+
+2013-07-22: version 1.0.4
+-------------------------
+
+* Added Galera/MySQL Monitoring Template for Cacti
+* Added "Disk Read/Write Time per IO Request (ms)" graph
+* Added "MySQL InnoDB Buffer Pool Efficiency" graph
+* Switched ss_get_mysql_stats.php to PHP MySQLi extension and made it working with SSL (bug 1193097)
+* Added user info to the max_duration check of pmp-check-mysql-innodb plugin (bug 1185513)
+* ss_get_mysql_stats.php default values for '$status' array were null instead of 0 (bug 1070268)
+* Introduction of innodb_read_views_memory overrode the InnoDB total memory allocated output in Cacti (bug 1188519)
+* ss_get_by_ssh.php parsed MongoDB counters incorrectly when replica is set (bug 1087073)
+* Cacti graph "Redis Unsaved Changes" was empty for Redis 2.6 (bug 1110372)
+* Comparison of status variables that are strings didn't work with pmp-check-mysql-status (bug 1191305)
+* pmp-check-mysql-processlist always showed 0 for "copy to table" counter (bug 1197084)
+* percona-nagios-plugins package failed to install on Debian Squeeze when debsums is installed (bug 1194757)
+
+2013-04-17: version 1.0.3
+-------------------------
+
+* MySQL 5.6 compatibility for InnoDB graphs (bug 1124292)
+* Added performance data to Nagios plugins (bugs 1090145, 1102687)
+* Added UTC option to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364)
+* Added 1-second granularity to pmp-check-mysql-deadlocks (bug 1154774)
+* Added package install/update instructions and other documentation updates (bugs 1139652, 1124200, 1015981)
+* Updated documentation with the new Cacti sample images
+* Updated "Network Traffic" to be blue and green and to show bits/sec (bug 1132900)
+* Extended "MySQL Threads" graph with all kind of threads (bug 1157911)
+* Some Cacti single-item graphs were broken due to cacti hexadecimal transformation (bug 1155513)
+* Memcached graphs were broken when the wrong arguments for nc command are passed (bug 1155712)
+* ss_get_by_ssh.php didn't gather mongodb stats without SSH (bug 1050537)
+* ss_get_by_ssh.php didn't timeout commands that hang (bug 1160611)
+* pmp-check-file-privs didn't throw the proper error on directory permissions issue (bug 1024001)
+* pmp-check-mysql-replication-running reported OK when a slave is in "Connecting" state (bug 1089506)
+
+Update note: Cacti templates have to be re-imported together with the updating
+of ss_get_*.php scripts. Then make sure you rebuilt the poller cache under
+Cacti -> System Utilities. Also the following Cacti graphs need to be recreated: MySQL "MySQL
+Threads", Linux "Network Traffic".
+
+2013-02-15: version 1.0.2
+-------------------------
+
+* Created Debian and RPM packages
+* Added "Disk IOPS" graph to Cacti Linux Templates
+* Added an option to pmp-check-unix-memory to disable overriding the status based on the largest process in memory (bug 1052368)
+* Added '!=' comparison operator to pmp-check-mysql-status (bug 1048627)
+* pmp-check-mysql-replication-delay didn't alert if second behing master is NULL (bug 1040528)
+* pmp-check-pt-table-checksum reported OK when checksums table does not exist (bug 1114425)
+* pmp-check-pt-table-checksum threw "Bad substitution" error on Debian (bug 1071802)
+* Minor updates to the documentation (bugs 1021855, 1014814, 1125233)
+
+2012-06-12: version 1.0.1
+-------------------------
+
+* Cacti debug logs had a 12-hour timestamp instead of 24-hour (bug 973320).
+* Nagios checks didn't remove temporary files on some platforms (bug 977514).
+* Nagios plugins didn't use enough XXX in mktemp patterns (bug 2022766).
+* Nagios check for deleted files didn't return 0 on success (bug 1009751).
+* Nagios check for long-running txns didn't show thread ID (bug 1011625).
+
+2012-04-02: version 1.0.0
+-------------------------
+
+* Load average was 15-minute instead of 1-minute (bug 968604).
+* MySQL connection errors weren't logged (bug 958782).
+* The pmp-check-mysql-deadlocks referred to pt-heartbeat (bug 934255).
+* HTTP status was not fetched correctly when $use_ssh was disabled (bug 937017).
+* MongoDB didn't support --port2 (bug 937018).
+* Percona Server response time graph didn't tolerate <> 14 rows (bug 954118).
+* The release tarball had an extra directory (bug 934227).
+* pmp-check-mysql-status didn't remove one of its temp files (bug 959425).
+
+2012-02-16: version 0.9.0
+-------------------------
+
+* Initial release. Not backwards compatible with Better Cacti Templates.
+
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Makefile b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Makefile
new file mode 100644
index 0000000..dce78e2
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/Makefile
@@ -0,0 +1,13 @@
+#/usr/bin/make -f
+
+PLUGIN = $(wildcard nagios/bin/*)
+MANPAGES = $(shell find nagios/bin -type f -printf '%f\n' | sed 's,$$,.7,')
+CLEANFILES = $(MANPAGES)
+
+include ../common.mk
+
+
+%.7: $(PLUGIN)
+ pod2man -s 7 $< > $@
+
+
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/control b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/control
new file mode 100644
index 0000000..7b672b3
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/control
@@ -0,0 +1,7 @@
+Watch: http://www.percona.com/downloads/percona-monitoring-plugins/LATEST/source/ >percona-monitoring-plugins-([0-9.]+)\.tar\.gz<
+Version: 1.1.8
+Homepage: http://www.percona.com/doc/percona-monitoring-plugins/
+Uploaders: Bernd Zeimetz <bzed@debian.org>
+Description: Percona Monitoring Plugins (nagios)
+ Nagios MySQL Monitoring plugins writting/provided by Percona.
+Suggests: percona-toolkit, python2.7, python-pymongo
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/copyright b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/copyright
new file mode 100644
index 0000000..c0aecd2
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/copyright
@@ -0,0 +1,12 @@
+Copyright 2012-2014 Baron Schwartz, 2012-2014 Percona Inc.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA.
+
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-aws-rds.py b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-aws-rds.py
new file mode 100755
index 0000000..73b7660
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-aws-rds.py
@@ -0,0 +1,562 @@
+#!/usr/bin/env python
+"""Nagios plugin for Amazon RDS monitoring.
+
+This program is part of $PROJECT_NAME$
+License: GPL License (see COPYING)
+
+Author Roman Vynar
+Copyright 2014-2015 Percona LLC and/or its affiliates
+"""
+
+import datetime
+import optparse
+import pprint
+import sys
+
+import boto
+import boto.rds
+import boto.ec2.cloudwatch
+
+# Nagios status codes
+OK = 0
+WARNING = 1
+CRITICAL = 2
+UNKNOWN = 3
+
+
+class RDS(object):
+
+ """RDS connection class"""
+
+ def __init__(self, region, profile=None, identifier=None):
+ """Get RDS instance details"""
+ self.region = region
+ self.profile = profile
+ self.identifier = identifier
+
+ if self.region == 'all':
+ self.regions_list = [reg.name for reg in boto.rds.regions()]
+ else:
+ self.regions_list = [self.region]
+
+ self.info = None
+ if self.identifier:
+ for reg in self.regions_list:
+ try:
+ rds = boto.rds.connect_to_region(reg, profile_name=self.profile)
+ self.info = rds.get_all_dbinstances(self.identifier)
+ except (boto.provider.ProfileNotFoundError, boto.exception.BotoServerError) as msg:
+ debug(msg)
+ else:
+ # Exit on the first region and identifier match
+ self.region = reg
+ break
+
+ def get_info(self):
+ """Get RDS instance info"""
+ if self.info:
+ return self.info[0]
+ else:
+ return None
+
+ def get_list(self):
+ """Get list of available instances by region(s)"""
+ result = dict()
+ for reg in self.regions_list:
+ try:
+ rds = boto.rds.connect_to_region(reg, profile_name=self.profile)
+ result[reg] = rds.get_all_dbinstances()
+ except (boto.provider.ProfileNotFoundError, boto.exception.BotoServerError) as msg:
+ debug(msg)
+
+ return result
+
+ def get_metric(self, metric, start_time, end_time, step):
+ """Get RDS metric from CloudWatch"""
+ cw_conn = boto.ec2.cloudwatch.connect_to_region(self.region, profile_name=self.profile)
+ result = cw_conn.get_metric_statistics(
+ step,
+ start_time,
+ end_time,
+ metric,
+ 'AWS/RDS',
+ 'Average',
+ dimensions={'DBInstanceIdentifier': [self.identifier]}
+ )
+ if result:
+ if len(result) > 1:
+ # Get the last point
+ result = sorted(result, key=lambda k: k['Timestamp'])
+ result.reverse()
+
+ result = float('%.2f' % result[0]['Average'])
+
+ return result
+
+
+def debug(val):
+ """Debugging output"""
+ global options
+ if options.debug:
+ print 'DEBUG: %s' % val
+
+
+def main():
+ """Main function"""
+ global options
+
+ short_status = {
+ OK: 'OK',
+ WARNING: 'WARN',
+ CRITICAL: 'CRIT',
+ UNKNOWN: 'UNK'
+ }
+
+ # DB instance classes as listed on
+ # http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html
+ db_classes = {
+ 'db.t1.micro': 0.615,
+ 'db.m1.small': 1.7,
+ 'db.m1.medium': 3.75,
+ 'db.m1.large': 7.5,
+ 'db.m1.xlarge': 15,
+ 'db.m4.large': 8,
+ 'db.m4.xlarge': 16,
+ 'db.m4.2xlarge': 32,
+ 'db.m4.4xlarge': 64,
+ 'db.m4.10xlarge': 160,
+ 'db.r3.large': 15,
+ 'db.r3.xlarge': 30.5,
+ 'db.r3.2xlarge': 61,
+ 'db.r3.4xlarge': 122,
+ 'db.r3.8xlarge': 244,
+ 'db.t2.micro': 1,
+ 'db.t2.small': 2,
+ 'db.t2.medium': 4,
+ 'db.t2.large': 8,
+ 'db.m3.medium': 3.75,
+ 'db.m3.large': 7.5,
+ 'db.m3.xlarge': 15,
+ 'db.m3.2xlarge': 30,
+ 'db.m2.xlarge': 17.1,
+ 'db.m2.2xlarge': 34.2,
+ 'db.m2.4xlarge': 68.4,
+ 'db.cr1.8xlarge': 244,
+ }
+
+ # RDS metrics http://docs.aws.amazon.com/AmazonCloudWatch/latest/DeveloperGuide/rds-metricscollected.html
+ metrics = {
+ 'status': 'RDS availability',
+ 'load': 'CPUUtilization',
+ 'memory': 'FreeableMemory',
+ 'storage': 'FreeStorageSpace'
+ }
+
+ units = ('percent', 'GB')
+
+ # Parse options
+ parser = optparse.OptionParser()
+ parser.add_option('-l', '--list', help='list of all DB instances',
+ action='store_true', default=False, dest='db_list')
+ parser.add_option('-n', '--profile', default=None,
+ help='AWS profile from ~/.boto or /etc/boto.cfg. Default: None, fallbacks to "[Credentials]".')
+ parser.add_option('-r', '--region', default='us-east-1',
+ help='AWS region. Default: us-east-1. If set to "all", we try to detect the instance region '
+ 'across all of them, note this will be slower than if you specify the region explicitly.')
+ parser.add_option('-i', '--ident', help='DB instance identifier')
+ parser.add_option('-p', '--print', help='print status and other details for a given DB instance',
+ action='store_true', default=False, dest='printinfo')
+ parser.add_option('-m', '--metric', help='metric to check: [%s]' % ', '.join(metrics.keys()))
+ parser.add_option('-w', '--warn', help='warning threshold')
+ parser.add_option('-c', '--crit', help='critical threshold')
+ parser.add_option('-u', '--unit', help='unit of thresholds for "storage" and "memory" metrics: [%s].'
+ 'Default: percent' % ', '.join(units), default='percent')
+ parser.add_option('-t', '--time', help='time period in minutes to query. Default: 5',
+ type='int', default=5)
+ parser.add_option('-a', '--avg', help='time average in minutes to request. Default: 1',
+ type='int', default=1)
+ parser.add_option('-f', '--forceunknown', help='force alerts on unknown status. This prevents issues related to '
+ 'AWS Cloudwatch throttling limits Default: False',
+ action='store_true', default=False)
+ parser.add_option('-d', '--debug', help='enable debug output',
+ action='store_true', default=False)
+ options, _ = parser.parse_args()
+
+ if options.debug:
+ boto.set_stream_logger('boto')
+
+ rds = RDS(region=options.region, profile=options.profile, identifier=options.ident)
+
+ # Check args
+ if len(sys.argv) == 1:
+ parser.print_help()
+ sys.exit()
+ elif options.db_list:
+ info = rds.get_list()
+ print 'List of all DB instances in %s region(s):' % (options.region,)
+ pprint.pprint(info)
+ sys.exit()
+ elif not options.ident:
+ parser.print_help()
+ parser.error('DB identifier is not set.')
+ elif options.printinfo:
+ info = rds.get_info()
+ if info:
+ pprint.pprint(vars(info))
+ else:
+ print 'No DB instance "%s" found on your AWS account and %s region(s).' % (options.ident, options.region)
+
+ sys.exit()
+ elif not options.metric or options.metric not in metrics.keys():
+ parser.print_help()
+ parser.error('Metric is not set or not valid.')
+ elif not options.warn and options.metric != 'status':
+ parser.print_help()
+ parser.error('Warning threshold is not set.')
+ elif not options.crit and options.metric != 'status':
+ parser.print_help()
+ parser.error('Critical threshold is not set.')
+ elif options.avg <= 0 and options.metric != 'status':
+ parser.print_help()
+ parser.error('Average must be greater than zero.')
+ elif options.time <= 0 and options.metric != 'status':
+ parser.print_help()
+ parser.error('Time must be greater than zero.')
+
+ now = datetime.datetime.utcnow()
+ status = None
+ note = ''
+ perf_data = None
+
+ # RDS Status
+ if options.metric == 'status':
+ info = rds.get_info()
+ if not info:
+ status = UNKNOWN
+ note = 'Unable to get RDS instance'
+ else:
+ status = OK
+ try:
+ version = info.EngineVersion
+ except:
+ version = info.engine_version
+
+ note = '%s %s. Status: %s' % (info.engine, version, info.status)
+
+ # RDS Load Average
+ elif options.metric == 'load':
+ # Check thresholds
+ try:
+ warns = [float(x) for x in options.warn.split(',')]
+ crits = [float(x) for x in options.crit.split(',')]
+ fail = len(warns) + len(crits)
+ except:
+ fail = 0
+
+ if fail != 6:
+ parser.error('Warning and critical thresholds should be 3 comma separated numbers, e.g. 20,15,10')
+
+ loads = []
+ fail = False
+ j = 0
+ perf_data = []
+ for i in [1, 5, 15]:
+ if i == 1:
+ # Some stats are delaying to update on CloudWatch.
+ # Let's pick a few points for 1-min load avg and get the last point.
+ points = 5
+ else:
+ points = i
+
+ load = rds.get_metric(metrics[options.metric], now - datetime.timedelta(seconds=points * 60), now, i * 60)
+ if not load:
+ status = UNKNOWN
+ note = 'Unable to get RDS statistics'
+ perf_data = None
+ break
+
+ loads.append(str(load))
+ perf_data.append('load%s=%s;%s;%s;0;100' % (i, load, warns[j], crits[j]))
+
+ # Compare thresholds
+ if not fail:
+ if warns[j] > crits[j]:
+ parser.error('Parameter inconsistency: warning threshold is greater than critical.')
+ elif load >= crits[j]:
+ status = CRITICAL
+ fail = True
+ elif load >= warns[j]:
+ status = WARNING
+
+ j = j + 1
+
+ if status != UNKNOWN:
+ if status is None:
+ status = OK
+
+ note = 'Load average: %s%%' % '%, '.join(loads)
+ perf_data = ' '.join(perf_data)
+
+ # RDS Free Storage
+ # RDS Free Memory
+ elif options.metric in ['storage', 'memory']:
+ # Check thresholds
+ try:
+ warn = float(options.warn)
+ crit = float(options.crit)
+ except:
+ parser.error('Warning and critical thresholds should be integers.')
+
+ if crit > warn:
+ parser.error('Parameter inconsistency: critical threshold is greater than warning.')
+
+ if options.unit not in units:
+ parser.print_help()
+ parser.error('Unit is not valid.')
+
+ info = rds.get_info()
+ free = rds.get_metric(metrics[options.metric], now - datetime.timedelta(seconds=options.time * 60),
+ now, options.avg * 60)
+ if not info or not free:
+ status = UNKNOWN
+ note = 'Unable to get RDS details and statistics'
+ else:
+ if options.metric == 'storage':
+ storage = float(info.allocated_storage)
+ elif options.metric == 'memory':
+ try:
+ storage = db_classes[info.instance_class]
+ except:
+ print 'Unknown DB instance class "%s"' % info.instance_class
+ sys.exit(CRITICAL)
+
+ free = '%.2f' % (free / 1024 ** 3)
+ free_pct = '%.2f' % (float(free) / storage * 100)
+ if options.unit == 'percent':
+ val = float(free_pct)
+ val_max = 100
+ elif options.unit == 'GB':
+ val = float(free)
+ val_max = storage
+
+ # Compare thresholds
+ if val <= crit:
+ status = CRITICAL
+ elif val <= warn:
+ status = WARNING
+
+ if status is None:
+ status = OK
+
+ note = 'Free %s: %s GB (%.0f%%) of %s GB' % (options.metric, free, float(free_pct), storage)
+ perf_data = 'free_%s=%s;%s;%s;0;%s' % (options.metric, val, warn, crit, val_max)
+
+ # Final output
+ if status != UNKNOWN and perf_data:
+ print '%s %s | %s' % (short_status[status], note, perf_data)
+ elif status == UNKNOWN and not options.forceunknown:
+ print '%s %s | null' % ('OK', note)
+ sys.exit(0)
+ else:
+ print '%s %s' % (short_status[status], note)
+
+ sys.exit(status)
+
+
+if __name__ == '__main__':
+ main()
+
+# ############################################################################
+# Documentation
+# ############################################################################
+"""
+=pod
+
+=head1 NAME
+
+pmp-check-aws-rds.py - Check Amazon RDS metrics.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-aws-rds.py [options]
+
+ Options:
+ -h, --help show this help message and exit
+ -l, --list list of all DB instances
+ -n PROFILE, --profile-name=PROFILE
+ AWS profile from ~/.boto or /etc/boto.cfg. Default:
+ None, fallbacks to "[Credentials]".
+ -r REGION, --region=REGION
+ AWS region. Default: us-east-1. If set to "all", we
+ try to detect the instance region across all of them,
+ note this will be slower than you specify the region.
+ -i IDENT, --ident=IDENT
+ DB instance identifier
+ -p, --print print status and other details for a given DB instance
+ -m METRIC, --metric=METRIC
+ metric to check: [status, load, storage, memory]
+ -w WARN, --warn=WARN warning threshold
+ -c CRIT, --crit=CRIT critical threshold
+ -u UNIT, --unit=UNIT unit of thresholds for "storage" and "memory" metrics:
+ [percent, GB]. Default: percent
+ -t TIME, --time=TIME time period in minutes to query. Default: 5
+ -a AVG, --avg=AVG time average in minutes to request. Default: 1
+ -f, --forceunknown force alerts on unknown status. This prevents issues
+ related to AWS Cloudwatch throttling limits Default:
+ False
+ -d, --debug enable debug output
+
+=head1 REQUIREMENTS
+
+This plugin is written on Python and utilizes the module C<boto> (Python interface
+to Amazon Web Services) to get various RDS metrics from CloudWatch and compare
+them against the thresholds.
+
+* Install the package: C<yum install python-boto> or C<apt-get install python-boto>
+* Create a config /etc/boto.cfg or ~nagios/.boto with your AWS API credentials.
+ See http://code.google.com/p/boto/wiki/BotoConfig
+
+This plugin that is supposed to be run by Nagios, i.e. under ``nagios`` user,
+should have permissions to read the config /etc/boto.cfg or ~nagios/.boto.
+
+Example:
+
+ [root@centos6 ~]# cat /etc/boto.cfg
+ [Credentials]
+ aws_access_key_id = THISISATESTKEY
+ aws_secret_access_key = thisisatestawssecretaccesskey
+
+If you do not use this config with other tools such as our Cacti script,
+you can secure this file the following way:
+
+ [root@centos6 ~]# chown nagios /etc/boto.cfg
+ [root@centos6 ~]# chmod 600 /etc/boto.cfg
+
+=head1 DESCRIPTION
+
+The plugin provides 4 checks and some options to list and print RDS details:
+
+* RDS Status
+* RDS Load Average
+* RDS Free Storage
+* RDS Free Memory
+
+To get the list of all RDS instances under AWS account:
+
+ # ./pmp-check-aws-rds.py -l
+
+To get the detailed status of RDS instance identified as C<blackbox>:
+
+ # ./pmp-check-aws-rds.py -i blackbox -p
+
+Nagios check for the overall status. Useful if you want to set the rest
+of the checks dependent from this one:
+
+ # ./pmp-check-aws-rds.py -i blackbox -m status
+ OK mysql 5.1.63. Status: available
+
+Nagios check for CPU utilization, specify thresholds as percentage of
+1-min., 5-min., 15-min. average accordingly:
+
+ # ./pmp-check-aws-rds.py -i blackbox -m load -w 90,85,80 -c 98,95,90
+ OK Load average: 18.36%, 18.51%, 15.95% | load1=18.36;90.0;98.0;0;100 load5=18.51;85.0;95.0;0;100 load15=15.95;80.0;90.0;0;100
+
+Nagios check for the free memory, specify thresholds as percentage:
+
+ # ./pmp-check-aws-rds.py -i blackbox -m memory -w 5 -c 2
+ OK Free memory: 5.90 GB (9%) of 68 GB | free_memory=8.68;5.0;2.0;0;100
+ # ./pmp-check-aws-rds.py -i blackbox -m memory -u GB -w 4 -c 2
+ OK Free memory: 5.90 GB (9%) of 68 GB | free_memory=5.9;4.0;2.0;0;68
+
+Nagios check for the free storage space, specify thresholds as percentage or GB:
+
+ # ./pmp-check-aws-rds.py -i blackbox -m storage -w 10 -c 5
+ OK Free storage: 162.55 GB (33%) of 500.0 GB | free_storage=32.51;10.0;5.0;0;100
+ # ./pmp-check-aws-rds.py -i blackbox -m storage -u GB -w 10 -c 5
+ OK Free storage: 162.55 GB (33%) of 500.0 GB | free_storage=162.55;10.0;5.0;0;500.0
+
+By default, the region is set to ``us-east-1``. You can re-define it globally in boto config or
+specify with -r option. The following command will list all instances across all regions under your AWS account:
+
+ # ./pmp-check-aws-rds.py -r all -l
+
+The following command will show the status for the first instance identified as ``blackbox`` in all regions:
+
+ # ./pmp-check-aws-rds.py -r all -i blackbox -p
+
+Remember, scanning regions are slower operation than specifying it explicitly.
+
+=head1 CONFIGURATION
+
+Here is the excerpt of potential Nagios config:
+
+ define host{
+ use mysql-host
+ host_name blackbox
+ alias blackbox
+ address blackbox.abcdefgh.us-east-1.rds.amazonaws.com
+ }
+
+ define servicedependency{
+ host_name blackbox
+ service_description RDS Status
+ dependent_service_description RDS Load Average, RDS Free Storage, RDS Free Memory
+ execution_failure_criteria w,c,u,p
+ notification_failure_criteria w,c,u,p
+ }
+
+ define service{
+ use active-service
+ host_name blackbox
+ service_description RDS Status
+ check_command check_rds!status!0!0
+ }
+
+ define service{
+ use active-service
+ host_name blackbox
+ service_description RDS Load Average
+ check_command check_rds!load!90,85,80!98,95,90
+ }
+
+ define service{
+ use active-service
+ host_name blackbox
+ service_description RDS Free Storage
+ check_command check_rds!storage!10!5
+ }
+
+ define service{
+ use active-service
+ host_name blackbox
+ service_description RDS Free Memory
+ check_command check_rds!memory!5!2
+ }
+
+ define command{
+ command_name check_rds
+ command_line $USER1$/pmp-check-aws-rds.py -i $HOSTALIAS$ -m $ARG1$ -w $ARG2$ -c $ARG3$
+ }
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2014 Percona LLC and/or its affiliates.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-aws-rds.py $VERSION$
+
+=cut
+
+"""
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-lvm-snapshots b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-lvm-snapshots
new file mode 100755
index 0000000..6aa4d11
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-lvm-snapshots
@@ -0,0 +1,187 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Print the name and fullness of every LVM snapshot that is open and
+# nearly full. The input is the file with 'lvs', and the allowable fullness.
+# In many cases lvs will report "File descriptor %d (...) leaked" and we ignore
+# this, as it's only a warning that usually happens from a shell.
+# ########################################################################
+check_lvm_snapshot_fullness() {
+ local FILE="$1"
+ local FULL="$2"
+ awk -v full="$FULL" '
+ $1 != "LV" && $1 != "File" && $6 !~ /[^0-9.]/ && $6 > full {
+ print $2 "/" $1 "[" $5 "]=" $6 "%"
+ }' "${FILE}"
+}
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+
+ # Get options
+ for o; do
+ case "${o}" in
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_WARN=${OPT_WARN:-90}
+ OPT_CRIT=${OPT_CRIT:-95}
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ local NOTE="OK no full LVM snapshot volumes"
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+
+ # The lvs command is usually in /usr/sbin. But if it's run as a non-root
+ # user, it will print out "WARNING: Running as a non-root user. Functionality
+ # may be unavailable." and exit with success anyway. So we have to detect
+ # this and make the plugin exit UNKNOWN in that case. If there is a $1 it's
+ # the output of lvs.
+ PATH="$PATH:/usr/sbin:/sbin"
+ if [ -z "$1" ]; then
+ lvs > "${TEMP}" 2>&1
+ else
+ cat "$1" > "${TEMP}" 2>/dev/null # For testing only
+ fi
+
+ if grep 'command not found' "${TEMP}" > /dev/null 2>&1; then
+ NOTE="OK $(cat "${TEMP}")"
+ elif grep 'WARNING: Running as a non-root user' "${TEMP}" >/dev/null 2>&1; then
+ NOTE="UNK You must execute lvs with root privileges"
+ else
+ local VOLS=$(check_lvm_snapshot_fullness "${TEMP}" "${OPT_CRIT}")
+ if [ "${VOLS}" ]; then
+ NOTE="CRIT LVM snapshot volumes over ${OPT_CRIT}% full: ${VOLS}"
+ else
+ VOLS=$(check_lvm_snapshot_fullness "${TEMP}" "${OPT_WARN}")
+ if [ "${VOLS}" ]; then
+ NOTE="WARN LVM snapshot volumes over ${OPT_WARN}% full: ${VOLS}"
+ fi
+ fi
+ fi
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-lvm-snapshots" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-lvm-snapshots - Alert when LVM snapshots are running out of copy-on-write space.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-lvm-snapshots [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; default 95%.
+ -w WARN Warning threshold; default 90%.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin looks at the output of the 'lvs' command to find LVM snapshot volumes
+that are beginning to run out of copy-on-write space. If a snapshot fills up its
+copy-on-write space, it will fail. This is also a useful way to detect whether
+some process, such as a backup, failed to release a snapshot volume after
+finishing with it.
+
+=head1 PRIVILEGES
+
+This plugin does not access MySQL.
+
+This plugin executes the following UNIX commands that may need special privileges:
+
+=over
+
+=item *
+
+lvs
+
+=back
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-lvm-snapshots $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mongo.py b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mongo.py
new file mode 100755
index 0000000..0de0987
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mongo.py
@@ -0,0 +1,594 @@
+#!/usr/bin/env python2.7
+"""MongoDB Nagios check script
+
+This program is part of $PROJECT_NAME$
+License: GPL License (see COPYING)
+
+Author David Murphy
+Copyright 2014-2015 Percona LLC and/or its affiliates
+"""
+
+import sys
+import time
+import optparse
+import os
+import stat
+import pickle
+import traceback
+import pprint
+
+from types import FunctionType
+# Not yet implemented
+# import DeepDiff
+
+try:
+ import pymongo
+except ImportError, e:
+ print e
+ sys.exit(2)
+
+# As of pymongo v 1.9 the SON API is part of the BSON package, therefore attempt
+# to import from there and fall back to pymongo in cases of older pymongo
+if pymongo.version >= "1.9":
+ import bson.son as son
+else:
+ import pymongo.son as son
+
+
+# Adding special behavior for optparse
+class OptionParsingError(RuntimeError):
+ def __init__(self, msg):
+ self.msg = msg
+
+
+class ModifiedOptionParser(optparse.OptionParser):
+ def error(self, msg):
+ raise OptionParsingError(msg)
+
+def unicode_truncate(s, length, encoding='utf-8'):
+ encoded = s.encode(encoding)[:length]
+ return encoded.decode(encoding, 'ignore')
+
+def parse_options(args):
+ funcList = []
+ for item_name, item_type in NagiosMongoChecks.__dict__.items():
+ if type(item_type) is FunctionType and item_name.startswith("check_") and item_name is not 'check_levels':
+ funcList.append(item_name)
+ p = ModifiedOptionParser()
+
+ p.add_option('-H', '--host', action='store', type='string', dest='host', default='127.0.0.1', help='The hostname you want to connect to')
+ p.add_option('-P', '--port', action='store', type='int', dest='port', default=27017, help='The port mongodb is running on')
+ p.add_option('-u', '--user', action='store', type='string', dest='user', default=None, help='The username you want to login as')
+ p.add_option('-p', '--password', action='store', type='string', dest='passwd', default=None, help='The password you want to use for that user')
+ p.add_option('-W', '--warning', action='store', dest='warning', default=None, help='The warning threshold you want to set')
+ p.add_option('-C', '--critical', action='store', dest='critical', default=None, help='The critical threshold you want to set')
+ p.add_option('-A', '--action', action='store', type='choice', dest='action', default='check_connect',
+ choices=funcList, help="The action you want to take. Valid choices are (%s) Default: %s" % (", ".join(funcList), 'check_connect'))
+ p.add_option('-s', '--ssl', dest='ssl', default=False, help='Connect using SSL')
+ p.add_option('-r', '--replicaset', dest='replicaset', default=None, help='Connect to replicaset')
+ p.add_option('-c', '--collection', action='store', dest='collection', default='foo', help='Specify the collection in check_cannary_test')
+ p.add_option('-d', '--database', action='store', dest='database', default='tmp', help='Specify the database in check_cannary_test')
+ p.add_option('-q', '--query', action='store', dest='query', default='{"_id":1}', help='Specify the query in check_cannary_test')
+ p.add_option('--statusfile', action='store', dest='status_filename', default='status.dat', help='File to current store state data in for delta checks')
+ p.add_option('--backup-statusfile', action='store', dest='status_filename_backup', default='status_backup.dat',
+ help='File to previous store state data in for delta checks')
+ p.add_option('--max-stale', action='store', dest='max_stale', type='int', default=60, help='Age of status file to make new checks (seconds)')
+ # Add options for output stat file
+ try:
+ result = p.parse_args()
+ except OptionParsingError, e:
+ if 'no such option' in e.msg:
+ sys.exit("UNKNOWN - No such options of %s" % e.msg.split(":")[1])
+ if 'invalid choice' in e.msg:
+ error_item = e.msg.split(":")[2].split("'")[1]
+ sys.exit('UNKNOWN - No such action of %s found!' % error_item)
+ return result
+
+
+def return_result(result_type, message):
+ if result_type == "ok":
+ print "OK - " + message
+ sys.exit(0)
+ elif result_type == "critical":
+ print "CRITICAL - " + message
+ sys.exit(2)
+ elif result_type == "warning":
+ print "WARNING - " + message
+ sys.exit(1)
+ else:
+ print "UNKNOWN - " + message
+ sys.exit(2)
+
+
+def main(argv):
+ options, arguments = parse_options(argv)
+ check(options, options.action)
+
+
+def check(args, check_name):
+ try:
+ checksObj = globals()['NagiosMongoChecks'](args)
+ run_check = getattr(checksObj, check_name)
+ result_type, message = run_check(args, args.warning, args.critical)
+ except Exception, e:
+ raise
+ print(traceback.extract_tb(sys.exc_info()[-1], 1))
+ return_result("critical", str(e))
+ return_result(result_type, message)
+
+
+class NagiosMongoChecks:
+ # need to initialize variables and such still
+ def __init__(self, args):
+ # setup inital values from optParse
+ self.host = '127.0.0.1'
+ self.port = 27017
+ self.user = None
+ self.password = None
+ self.warning = None
+ self.critical = None
+ self.action = 'check_connect'
+ self.ssl = False
+ self.replicaset = None
+ self.collection = 'foo'
+ self.database = 'tmp'
+ self.query = '{"_id":1}'
+ self.status_filename = 'status.dat'
+ self.status_filename_backup = 'status_backup.dat'
+ self.max_stale = 60
+
+ for option in vars(args):
+ setattr(self, option, getattr(args, option))
+
+ # Fix filepaths to be relative
+ if not self.status_filename.startswith("/") or not self.status_filename.startswith(".."):
+ self.status_filename_backup = "%s/%s" % (os.curdir, self.status_filename_backup)
+ self.status_filename = "%s/%s" % (os.curdir, self.status_filename)
+
+ # ammend known intenal values we will need
+ self.current_status = {}
+ self.last_status = {}
+ self.connection = None
+ self.connection_time = None
+ self.pyMongoError = None
+
+ self.connect()
+
+ if self.file_age(self.status_filename) <= self.max_stale:
+ # Save status_file contents status as current_status
+ self.get_last_status(True)
+ # Save status_filename_backup contents as last_status
+ self.get_last_status(False, self.status_filename_backup)
+ else:
+ if self.connection is None:
+ raise pymongo.errors.ConnectionFailure(self.pyMongoError or "No connection Found, did connect fail?")
+ # Get fresh current_status from server
+ self.current_status = self.sanatize(self.get_server_status())
+ # user last status_filename contents as last_status
+ self.get_last_status(False, self.status_filename)
+ # Not yet implemented
+ # self.compute_deltas()
+
+ # get last status
+ # check if needs refresh, refresh if needed
+ # set last/current to self.current_status
+ pass
+
+ def get_last_status(self, returnAsCurrent, forceFile=None):
+ # Open file using self.file
+ try:
+ file_name = forceFile if forceFile is not None else self.status_filename
+ fileObject = open(file_name, 'r')
+ if returnAsCurrent is None or returnAsCurrent is False:
+ self.last_status = pickle.load(fileObject)
+ else:
+ self.current_status = pickle.load(fileObject)
+ except Exception:
+ return False
+ return True
+
+ def get_server_status(self):
+ try:
+ data = self.connection['admin'].command(pymongo.son_manipulator.SON([('serverStatus', 1)]))
+ except:
+ try:
+ data = self.connection['admin'].command(son.SON([('serverStatus', 1)]))
+ except Exception, e:
+ if type(e).__name__ == "OperationFailure":
+ sys.exit("UNKNOWN - Not authorized!")
+ else:
+ sys.exit("UNKNOWN - Unable to run serverStatus: %s::%s" % (type(e).__name__, unicode_truncate(e.message, 45)))
+
+ if self.current_status is None:
+ self.current_status = data
+
+ return data
+
+ # figure out how to use this one later
+ def rotate_files(self):
+ # 1)this needs to rename self.status_filename to status_filename_backup
+ # 2) Save current_status to self.status_filename ( new file )
+ if self.last_status == {}:
+ # Build the last status file for future deltas from current data
+ self.save_file(self.status_filename_backup, self.current_status)
+ # Set the current status file to empty to set the aging clock
+ self.save_file(self.status_filename, {})
+ sys.exit("UNKNOWN - No status data present, please try again in %s seconds" % self.max_stale)
+ else:
+ self.save_file(self.status_filename_backup, self.last_status)
+ self.save_file(self.status_filename, self.current_status)
+
+
+ def save_file(self, filename, contents):
+ try:
+ pickle.dump(contents, open(filename, "wb"))
+ except Exception, e:
+ sys.exit("UNKNOWN - Error saving stat file %s: %s" % (filename, e.message))
+
+ # TODO - Fill in all check defaults
+ def get_default(self, key, level):
+
+ defaults = {
+ 'check_connections': {'warning': 15000, 'critical': 19000},
+ 'check_connect': {'warning': 50, 'critical': 100},
+ 'check_queues': {'warning': 30, 'critical': 100},
+ 'check_lock_pct': {'warning': 30, 'critical': 50},
+ 'check_repl_lag': {'warning': 200, 'critical': 500},
+ # 'check_flushing': {'warning':XX, 'critical': XX},
+ 'check_total_indexes': {'warning': 100, 'critical': 300},
+ 'check_cannary_test': {'warning': 30, 'critical': 50},
+ 'check_oplog': {'warning': 36, 'critical': 24},
+ 'check_index_ratio': {'warning': .9, 'critical': .8},
+ }
+ try:
+ return defaults[key][level]
+ except KeyError:
+ sys.exit("UNKNOWN - Missing defaults found for %s please use -w and -c" % key)
+
+ # Not yet implemented
+ # def compute_deltas(self):
+ # deltas = []
+ # for item in DeepDiff(self.last_status, self.current_status)['values_changed']:
+ # name = item.split(":")[0].split("root")[1].replace("['", "").replace("']", ".")[:-1]
+ # if 'time' not in item.lower():
+ # values = item.split(":")[1]
+ # print(values)
+ # old, new = values.split("===>")
+ # print("%s: %s - %s = %s" % (name, new, old, float(new)-float(old)))
+ # deltas[name] = float(new) - float(old)
+ # self.delta_data = deltas
+ # return True
+
+ def file_age(self, filename):
+ try:
+ age = time.time() - os.stat(filename)[stat.ST_CTIME]
+ except OSError:
+ age = 999999
+ return age
+
+ # TODO - Add meat to this if needed, here for future planning
+ def sanatize(self, status_output):
+ return status_output
+
+ def connect(self):
+ start_time = time.time()
+ try:
+ # ssl connection for pymongo > 2.3
+ if self.replicaset is None:
+ con = pymongo.MongoClient(self.host, self.port, ssl=self.ssl, serverSelectionTimeoutMS=2500)
+ else:
+ con = pymongo.MongoClient(self.host, self.port, ssl=self.ssl, replicaSet=self.replicaset, serverSelectionTimeoutMS=2500)
+ if (self.user and self.passwd) and not con['admin'].authenticate(self.user, self.passwd):
+ sys.exit("CRITICAL - Username and password incorrect")
+ except Exception, e:
+ raise
+ if isinstance(e, pymongo.errors.AutoReconnect) and str(e).find(" is an arbiter") != -1:
+ # We got a pymongo AutoReconnect exception that tells us we connected to an Arbiter Server
+ # This means: Arbiter is reachable and can answer requests/votes - this is all we need to know from an arbiter
+ print "OK - State: 7 (Arbiter)"
+ sys.exit(0)
+ con = None
+ self.pyMongoError = str(e)
+ if con is not None:
+ try:
+ con['admin'].command(pymongo.son_manipulator.SON([('ping', 1)]))
+ except Exception, e:
+ sys.exit("UNKNOWN - Unable to run commands, possible auth issue: %s" % e.message)
+ self.connection_time = round(time.time() - start_time, 2)
+ version = con.server_info()['version'].split('.')
+ self.mongo_version = (version[0], version[1], version[2])
+ self.connection = con
+
+ def check_levels(self, check_result, warning_level, critical_level, message):
+ if check_result < warning_level:
+ return "ok", message
+ elif check_result > critical_level:
+ return "critical", message
+ elif check_result > warning_level and check_result < critical_level:
+ return "warning", message
+ else:
+ return "unknown", "Unable to parse %s into a result" % check_result
+
+ def check_connect(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_connect', 'warning')
+ critical_level = critical_level or self.get_default('check_connect', 'critical')
+ con_time = self.connection_time
+ message = "Connection time %.2f ms" % con_time
+ return self.check_levels(float(con_time), float(warning_level), float(critical_level), message)
+
+ def check_connections(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_connections', 'warning')
+ critical_level = critical_level or self.get_default('check_connections', 'critical')
+ connections = self.current_status['connections']
+ connections['total'] = connections['available'] + connections['current']
+ used_percent = int((connections['current'] / connections['total']) * 100)
+ message = "%i%% connections used ( %d of %d )" % (used_percent, connections['current'], connections['total'])
+ return self.check_levels(float(used_percent), int(warning_level), int(critical_level), message)
+
+ def check_lock_pct(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_lock_pct', 'warning')
+ critical_level = critical_level or self.get_default('check_lock_pct', 'critical')
+ if self.mongo_version >= ('2', '7', '0'):
+ return "ok", "Mongo 3.0 and above do not have lock %"
+ lockTime = self.current_status['globalLock']['lockTime'] - self.last_status['globalLock']['lockTime']
+ totalTime = self.current_status['globalLock']['totalTime'] - self.last_status['globalLock']['totalTime']
+ lock_percent = int((lockTime / totalTime) * 100)
+ message = "%i%% locking found (over 100%% is possible)" % (lock_percent)
+ return self.check_levels(lock_percent, warning_level, critical_level, message)
+
+ def check_flushing(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_flushing', 'warning')
+ critical_level = critical_level or self.get_default('check_flushing', 'critical')
+ flushData = self.current_status['backgroundFlushing']
+ if args.average:
+ flush_time = flushData['average_ms']
+ stat_type = "Average"
+ else:
+ flush_time = flushData['last_ms']
+ stat_type = "Last"
+
+ message = "%s Flush Time: %.2fms" % (stat_type, flush_time)
+ return self.check_levels(flush_time, warning_level, critical_level, message)
+
+ def check_index_ratio(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_index_ratio', 'warning')
+ critical_level = critical_level or self.get_default('check_index_ratio', 'critical')
+ message = None
+
+ indexCounters = self.current_status['indexCounters']
+ if 'note' in indexCounters:
+ ratio = 1.0
+ message = "not supported defaulting to 1.0 ratio"
+ elif self.mongo_version >= ('2', '4', '0'):
+ ratio = indexCounters['missRatio']
+ else:
+ ratio = indexCounters['btree']['missRatio']
+ if message is None:
+ message = "Miss Ratio: %.2f" % ratio
+ return self.check_levels(ratio, warning_level, critical_level, message)
+
+ def check_have_primary(self, args, warning_level, critical_level):
+ replset_status = self.connection['admin'].command("replSetGetStatus")
+ for member in replset_status['members']:
+ if member['state'] == 1:
+ return "ok", "Cluster has primary"
+ return "critical", "Cluster has no primary!"
+
+ def check_total_indexes(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_total_indexes', 'warning')
+ critical_level = critical_level or self.get_default('check_total_indexes', 'critical')
+ index_count = 0
+ database_count = 0
+ for database in self.connection.database_names():
+ if database not in ["admin", "local"]:
+ database_count += 1
+ self.connection[database]['system.indexes'].count()
+ index_count += self.connection[database]['system.indexes'].count()
+ message = "Found %d indexes in %d databases" % (index_count, database_count)
+ return self.check_levels(index_count, warning_level, critical_level, message)
+
+ def check_queues(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_queues', 'warning')
+ critical_level = critical_level or self.get_default('check_queues', 'critical')
+ currentQueue = self.current_status['globalLock']['currentQueue']
+ currentQueue['total'] = currentQueue['readers'] + currentQueue['writers']
+ message = "Queue Sizes: read (%d) write(%d) total (%d)" % (currentQueue['readers'], currentQueue['writers'], currentQueue['total'])
+ return self.check_levels(currentQueue['total'], warning_level, critical_level, message)
+
+ def check_oplog(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_oplog', 'warning')
+ critical_level = critical_level or self.get_default('check_oplog', 'critical')
+ if 'local' not in self.connection.database_names() or 'oplog.rs' not in self.connection['local'].collection_names():
+ return "critical", "We do not seem to be in a replset!"
+ oplog = self.connection['local']['oplog.rs']
+ first_ts = oplog.find().sort("$natural", pymongo.ASCENDING).limit(1)[0]['ts']
+ last_ts = oplog.find().sort("$natural", pymongo.DESCENDING).limit(1)[0]['ts']
+ oplog_range = (last_ts.as_datetime() - first_ts.as_datetime())
+ oplog_range_hours = oplog_range.total_seconds() / 60 / 60
+ message = "Oplog Time is %d hours" % (oplog_range_hours)
+ return self.check_levels(int(oplog_range_hours), warning_level, critical_level, message)
+
+ def check_election(self, args, warning_level, critical_level):
+ replset_status = self.connection['admin'].command("replSetGetStatus")
+ for member in replset_status['members']:
+ if member['stateStr'] == "PRIMARY":
+ #last_primary = member.name
+ last_primary = member['name']
+ for member in replset_status['members']:
+ if member['stateStr'] == "PRIMARY":
+ current_primary = member['name']
+ message = "Old PRI: %s New PRI: %s" % (last_primary, current_primary)
+ if current_primary == last_primary:
+ return "ok", message
+ else:
+ return "critical", message
+
+ def is_balanced(self):
+ chunks = {}
+
+ # Loop through each of the chunks, tallying things up
+ for chunk in self.connection["config"]["chunks"].find():
+ namespace = chunk['ns']
+ shard = chunk['shard']
+ if namespace not in chunks:
+ chunks[namespace] = {'shards': {}, 'total': 0}
+ if shard not in chunks[namespace]['shards']:
+ chunks[namespace]['shards'][shard] = 0
+ chunks[namespace]['shards'][shard] += 1
+ chunks[namespace]['total'] += 1
+
+ shardsCount = self.connection["config"]["shards"].count()
+ chunksCount = self.connection["config"]["chunks"].count()
+
+ # Different migration thresholds depending on cluster size
+ # http://docs.mongodb.org/manual/core/sharding-internals/#sharding-migration-thresholds
+ if chunksCount < 20:
+ threshold = 2
+ elif chunksCount < 80 and chunksCount > 21:
+ threshold = 4
+ else:
+ threshold = 8
+
+ # Default to balanced state, any failure will then mark it as False forevermore
+ isBalanced = True
+ # Loop through each ns and determine if it's balanced or not
+ for ns in chunks:
+ balanced = chunks[ns]['total'] / shardsCount
+ for shard in chunks[ns]['shards']:
+ if shard > balanced - threshold and shard < balanced + threshold:
+ pass
+ else:
+ isBalanced = False
+
+ return isBalanced
+
+ def check_balance(self, args, warning_level, critical_level):
+ if self.is_balanced() is True:
+ return "ok", "Shards are balanced by chunk counts"
+ else:
+ return "critcal", "Shards are not balanced by chunk and need review"
+
+ def check_cannary_test(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_cannary_test', 'warning')
+ critical_level = critical_level or self.get_default('check_cannary_test', 'critical')
+ # this does not check for a timeout, we assume NRPE or Nagios will alert on that timeout.
+ try:
+ start = time.time()
+ self.connection[self.database][self.collection].find_one(self.query)
+ time_range = (time.time() - start).total_seconds
+ message = "Collection %s.%s query took: %d s" % (self.database, self.collection, time_range)
+ return self.check_levels(time_range, warning_level, critical_level, message)
+ except Exception, e:
+ message = "Collection %s.%s query FAILED: %s" % (self.database, self.collection, e)
+ return "critical", message
+
+ def check_repl_lag(self, args, warning_level, critical_level):
+ warning_level = warning_level or self.get_default('check_repl_lag', 'warning')
+ critical_level = critical_level or self.get_default('check_repl_lag', 'critical')
+
+ # make a write incase the client is not writing, but us an update to avoid wasting space
+ self.connection['test']['lag_check'].update({"_id":1}, {"_id": 1, "x": 1})
+ # get a fresh status for the replset
+ try:
+ replset_status = self.connection['admin'].command("replSetGetStatus")
+ except Exception, e:
+ return "critical", "Are your running with --replset? - %s" % (e)
+
+ for member in replset_status['members']:
+ if member['stateStr'] == "PRIMARY":
+ primary = member
+ if 'self' in member and member['self'] is True:
+ hostOptimeDate = member['optimeDate']
+
+ if primary is not None:
+ highest_optimeDate = primary['optimeDate']
+ highest_name = primary['name']
+ else:
+ # find the most current secondary as there is not primary
+ highest_optimeDate = time.gmtime(0)
+ for member in replset_status['members']:
+ if member['optimeDate'] > highest_optimeDate:
+ highest_optimeDate = member['optimeDate']
+ highest_name = member['name']
+
+ rep_lag_seconds = (highest_optimeDate - hostOptimeDate).seconds
+ rep_lag_hours = round(rep_lag_seconds/60/60, 4)
+ message = "Lagging %s by %.4f hours" % (highest_name, rep_lag_hours)
+ return self.check_levels(rep_lag_hours, warning_level, critical_level, message)
+
+#
+# main app
+#
+if __name__ == "__main__":
+ sys.exit(main(sys.argv[1:]))
+
+# ############################################################################
+# Documentation
+# ############################################################################
+"""
+=pod
+
+=head1 NAME
+
+pmp-check-mongo.py - MongoDB Nagios check script.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mongo.py [options]
+
+ Options:
+ -h, --help show this help message and exit
+ -H HOST, --host=HOST The hostname you want to connect to
+ -P PORT, --port=PORT The port mongodb is running on
+ -u USER, --user=USER The username you want to login as
+ -p PASSWD, --password=PASSWD
+ The password you want to use for that user
+ -W WARNING, --warning=WARNING
+ The warning threshold you want to set
+ -C CRITICAL, --critical=CRITICAL
+ The critical threshold you want to set
+ -A ACTION, --action=ACTION
+ The action you want to take. Valid choices are
+ (check_connections, check_election, check_lock_pct,
+ check_repl_lag, check_flushing, check_total_indexes,
+ check_balance, check_queues, check_cannary_test,
+ check_have_primary, check_oplog, check_index_ratio,
+ check_connect) Default: check_connect
+ -s SSL, --ssl=SSL Connect using SSL
+ -r REPLICASET, --replicaset=REPLICASET
+ Connect to replicaset
+ -c COLLECTION, --collection=COLLECTION
+ Specify the collection in check_cannary_test
+ -d DATABASE, --database=DATABASE
+ Specify the database in check_cannary_test
+ -q QUERY, --query=QUERY
+ Specify the query in check_cannary_test
+ --statusfile=STATUS_FILENAME
+ File to current store state data in for delta checks
+ --backup-statusfile=STATUS_FILENAME_BACKUP
+ File to previous store state data in for delta checks
+ --max-stale=MAX_STALE
+ Age of status file to make new checks (seconds)
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2014 Percona LLC and/or its affiliates.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mongo.py $VERSION$
+
+=cut
+
+"""
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deadlocks b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deadlocks
new file mode 100755
index 0000000..0545f06
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deadlocks
@@ -0,0 +1,189 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz
+# Depends-on: pt-deadlock-logger
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -i) shift; OPT_INTERVAL="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -T) shift; OPT_TABLE="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_WARN=${OPT_WARN:-12}
+ OPT_CRIT=${OPT_CRIT:-60}
+ OPT_INTERVAL=${OPT_INTERVAL:-1}
+ OPT_TABLE="${OPT_TABLE:-percona.deadlocks}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ LEVEL=$(mysql_exec "SELECT COUNT(*) FROM ${OPT_TABLE} WHERE server IN ('${OPT_HOST}', @@hostname) AND ts >= NOW() - INTERVAL ${OPT_INTERVAL}*60 SECOND")
+ if [ $? = 0 ]; then
+ NOTE="${LEVEL:-UNKNOWN} deadlocks in last ${OPT_INTERVAL} minutes"
+ if [ "${LEVEL:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ elif [ "${LEVEL:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE"
+ else
+ NOTE="OK $NOTE"
+ fi
+
+ # Build the common perf data output for graph trending
+ PERFDATA="deadlocks=${LEVEL:-0};${OPT_WARN};${OPT_CRIT};0;"
+ NOTE="$NOTE | $PERFDATA"
+ else
+ NOTE="UNK could not count deadlocks"
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_USER:+-u"${OPT_USER}"} \
+ ${OPT_PASS:+-p"${OPT_PASS}"} ${OPT_SOCK:+-S"${OPT_SOCK}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-deadlocks" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-deadlocks - Alert when pt-deadlock-logger has recorded too many recent deadlocks.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-deadlocks [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; default 60.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -i INTERVAL Interval over which to count, in minutes; default 1.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -T TABLE The database.table that pt-deadlock-logger uses; default percona.deadlocks.
+ -w WARN Warning threshold; default 12.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin looks at the table that pt-deadlock-logger (part of Percona
+Toolkit) maintains, and when there have been too many recent deadlocks, it
+alerts.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> from the C<pt-deadlock-logger> table.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-deadlocks $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deleted-files b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deleted-files
new file mode 100755
index 0000000..a23c098
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-deleted-files
@@ -0,0 +1,286 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -t) shift; OPT_TMPDIR="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # If any connection option was given, then try to log in to find the server's
+ # tmpdir.
+ if [ "${OPT_DEFT}${OPT_HOST}${OPT_USER}${OPT_PASS}${OPT_PORT}${OPT_SOCK}" ]; then
+ OPT_TMPDIR=$(mysql_exec "SELECT @@tmpdir") || exit $?
+ elif [ -z "${OPT_TMPDIR}" ]; then
+ OPT_TMPDIR="${TMPDIR:-/tmp/}"
+ fi
+
+ # TODO: We could auto-check every running instance, not just one.
+ local NOTE="OK no deleted files"
+ local PROC_ID=$(_pidof mysqld | head -n1)
+ if [ "${PROC_ID}" ]; then
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+ if _lsof "${PROC_ID}" > "${TEMP}" ; then
+ # If lsof exists, but you run it as non-root, you'll get a file with a
+ # bunch of this stuff:
+ # mysqld 15287 ... /proc/15287/cwd (readlink: Permission denied)
+ # We have to detect this and return UNK.
+ if grep -v -e denied -e COMMAND "${TEMP}" >/dev/null 2>&1; then
+ local FILES=$(check_deleted_files "${TEMP}" "${OPT_TMPDIR}")
+ NOTE="open but deleted files: ${FILES}"
+ if [ "${FILES}" -a -z "${OPT_WARN}" ]; then
+ NOTE="CRIT $NOTE"
+ elif [ "${FILES}" ]; then
+ NOTE="WARN $NOTE"
+ else
+ NOTE="OK no deleted files"
+ fi
+ else
+ NOTE="UNK You must execute lsof with root privileges"
+ fi
+ else
+ NOTE="UNK could not list MySQL's open files"
+ fi
+ else
+ NOTE="UNK could not find a mysqld process"
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# A wrapper around pidof, which might not exist. The first argument is the
+# command name to match.
+# ########################################################################
+_pidof() {
+ if ! pidof "${1}" 2>/dev/null; then
+ ps axo pid,ucomm | awk -v comm="${1}" '$2 == comm { print $1 }'
+ fi
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# A wrapper around lsof, which might not exist. The first argument is the
+# process ID to match. Otherwise, the fallback of listing /proc/pid/fd
+# will probably only work on Linux. For BSD, fstat will be used.
+# ########################################################################
+_lsof() {
+ PATH="$PATH:/usr/sbin:/sbin"
+ if ! lsof -p $1 2>/dev/null; then
+ if ! /bin/ls -l /proc/$1/fd 2>/dev/null; then
+ fstat -p $1 2>/dev/null
+ fi
+ fi
+}
+
+# ########################################################################
+# Generate a list of file handles that MySQL has open, but which are deleted,
+# and are not temp files such as /tmp/ib* files (InnoDB) or /tmp/ML* files
+# (binary logging). The first argument is a file containing the output of lsof
+# or ls -l for the open files. The second argument is the server's tmpdir.
+# ########################################################################
+check_deleted_files() {
+ awk -v tmpdir="${2}" '
+ /\(deleted\)/ { if ( index($0, tmpdir) == 0 ) {
+ if ( $NF ~ /deleted/ ) {
+ lf=NF-1;
+ }
+ else {
+ lf=NF;
+ }
+ print $lf;
+ }}' "${1}"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-deleted-files" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-deleted-files - Alert when MySQL's files are deleted.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-deleted-files [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; ignored.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -w WARN Warning threshold; changes the alert to WARN instead of CRIT.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin looks at the files that the mysqld process has open, and
+warns if any of them are deleted that shouldn't be. This typically happens when
+there is a poorly written logrotate script or when a human makes a mistake at
+the command line. This can cause several bad effects. If a table has been
+deleted, of course, it is a serious matter. Such a file can also potentially
+fill up the disk invisibly. If the file is the server's log, it might mean that
+logging is effectively broken and any problems the server experiences could be
+undiagnosable.
+
+The plugin accepts the -w and -c options for compatibility with standard Nagios
+plugin conventions, but they are not based on a threshold. Instead, the plugin
+raises a critical alert by default, and if the -w option is given, it raises a
+warning instead, regardless of the option's value.
+
+This plugin doesn't alert about deleted temporary files, which are not a
+problem. By default, this plugin assumes that the server's temporary directory
+is either the TMPDIR environment variable, or if that is not set, then /tmp/.
+If you specify MySQL authentication options, the value will log into the
+specified MySQL instance and look at the C<tmpdir> variable to find the
+temporary directory.
+
+This plugin looks at the first running instance of MySQL, as found in the
+system process table, so it will not work on systems that have multiple
+instances running. It probably works best on Linux, though it might work on
+other operating systems. It relies on either lsof or fstat or the ability to
+list the files in the process's /proc/pid/fd directory.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> the system variable C<@@tmpdir>.
+
+=back
+
+This plugin executes the following UNIX commands that may need special privileges:
+
+=over
+
+=item *
+
+ps
+
+=item *
+
+C<lsof> or C<ls /proc/$pid/fd> (Linux), C<fstat> (BSD)
+
+=back
+
+The plugin should be able to find mysqld PID using C<ps> command.
+
+On BSD, if C<sysctl> option C<security.bsd.see_other_uids> is set to 0, C<ps>
+will not return mysqld PID if the plugin run from non-root user.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-deleted-files $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-file-privs b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-file-privs
new file mode 100755
index 0000000..fa4df1c
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-file-privs
@@ -0,0 +1,289 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -g) shift; OPT_UNIX_GROUP="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -u) shift; OPT_UNIX_USER="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_UNIX_GROUP="${OPT_UNIX_GROUP:-mysql}"
+ OPT_UNIX_USER="${OPT_UNIX_USER:-mysql}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Set the exit status in case there are any problems.
+ NOTE="UNK could not determine the datadir location."
+
+ # Set up files to hold one or more data directory locations.
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ local DATADIRS=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' '${DATADIRS}' >/dev/null 2>&1" EXIT
+
+ # If any connection option was given, then try to log in to find the datadir.
+ if [ "${OPT_DEFT}${OPT_HOST}${OPT_USER}${OPT_PASS}${OPT_PORT}${OPT_SOCK}" ]; then
+ # If this fails (e.g. we can't log in), then there will be no line in the
+ # file, and later we won't change the exit code / note away from "UNK".
+ mysql_exec "SELECT IF(@@datadir LIKE '/%', @@datadir, CONCAT(@@basedir, @@datadir))" >> "${DATADIRS}"
+ else
+ # Find all MySQL server instances.
+ for pid in $(_pidof mysqld); do
+ ps -p ${pid} -o pid,command | grep "${pid}" >> "${TEMP}"
+ done
+ # The ${TEMP} file may now contain lines like the following sample:
+ # 13822 /usr/sbin/mysqld --defaults-file=/var/lib/mysql/my.cnf \
+ # --basedir=/usr --datadir=/var/lib/mysql/data/ \
+ # --pid-file=/var/run/mysqld/mysqld.pid \
+ # --socket=/var/run/mysqld/mysqld.sock
+ # Now the task is to read find any reference to a --datadir option.
+ # We store these into the $DATADIRS temp file.
+ # TODO: maybe in the future we can detect the user/group under which the
+ # process runs, and assume that is the right value, rather than defaulting
+ # to 'mysql'.
+ while read pid command; do
+ if echo "${command}" | grep datadir >/dev/null 2>&1; then
+ # Strip off everything up to and including --datadir=
+ command="${command##*--datadir=}"
+ # Strip off any options that follow this, assuming that there's not
+ # a space followed by a dash in the datadir's path.
+ echo "${command%% -*}" >> "${DATADIRS}"
+ fi
+ done < "${TEMP}"
+ fi
+
+ WRONG=""
+ NOTE2=""
+ > ${TEMP}
+ while read datadir; do
+ FILES="$(find "${datadir}" \! -group "${OPT_UNIX_GROUP}" -o \! -user "${OPT_UNIX_USER}" 2>>${TEMP})"
+ if [ "${FILES}" ]; then
+ WRONG=1
+ NOTE2="${NOTE2:+${NOTE2} }${FILES}"
+ fi
+ NOTE="OK all files/directories have correct ownership."
+ done < "${DATADIRS}"
+
+ if [ -s "${TEMP}" ]; then
+ NOTE="UNK `cat ${TEMP}`"
+ elif [ "${WRONG}" ]; then
+ if [ "${OPT_CRIT}" ]; then
+ NOTE="CRIT files with wrong ownership: ${NOTE2}"
+ else
+ NOTE="WARN files with wrong ownership: ${NOTE2}"
+ fi
+ fi
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# A wrapper around pidof, which might not exist. The first argument is the
+# command name to match.
+# ########################################################################
+_pidof() {
+ if ! pidof "${1}" 2>/dev/null; then
+ ps axo pid,ucomm | awk -v comm="${1}" '$2 == comm { print $1 }'
+ fi
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-file-privs" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-file-privs - Alert if MySQL data directory privileges are wrong.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-file-privs [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; makes a privilege issue critical.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -g GROUP The Unix group who should own the files; default mysql.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -u USER The Unix user who should own the files; default mysql.
+ -w WARN Warning threshold; ignored.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin checks to make sure that the MySQL data directory, and its
+contents, is owned by the correct Unix user and group. If the ownership is
+incorrect, then the server might fail due to lack of permission to modify its
+data. For example, suppose a system administrator enters a database directory
+and creates a file that is owned by root. Now a database administrator issues a
+DROP TABLE command, which fails because it is unable to remove the file and thus
+the non-empty directory cannot be removed either.
+
+The plugin accepts the -g and -u options to specify which Unix user and group
+should own the data directory and its contents. This is usually the user account
+under which MySQL runs, which is mysql by default on most systems. The plugin
+assumes that user and group by default, too.
+
+The plugin accepts the -w and -c options for compatibility with standard Nagios
+plugin conventions, but they are not based on a threshold. Instead, the plugin
+raises a warning by default, and if the -c option is given, it raises an error
+instead, regardless of the option's value.
+
+By default, this plugin will attempt to detect all running instances of MySQL,
+and verify the data directory ownership for each one. It does this purely by
+examining the Unix process table with the C<ps> tool. However, in some cases
+the process's command line does not list the path to the data directory. If the
+tool fails to detect the MySQL server process, or if you wish to limit the check
+to a single instance in the event that there are multiple instances on a single
+server, then you can specify MySQL authentication options. This will cause the
+plugin to skip examining the Unix processlist, log into MySQL, and examine the
+datadir variable from SHOW VARIABLES to find the location of the data directory.
+
+In case an user you are calling this plugin from has no permissions to examine
+the datadir the plugin raises an unknown with the explanation.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> the MySQL system variables C<@@datadir> and C<@@basedir>.
+
+=back
+
+This plugin executes the following UNIX commands that may need special privileges:
+
+=over
+
+=item *
+
+ps
+
+=item *
+
+find C<datadir>
+
+=back
+
+The plugin should be able to either get variables from MySQL or find mysqld
+PID using C<ps> command.
+
+On BSD, if C<sysctl> option C<security.bsd.see_other_uids> is set to 0, C<ps>
+will not return mysqld PID if the plugin run from non-root user.
+
+Also an user you run the plugin from should be able to access MySQL datadir
+files, so you may want to add it into mysql unix group etc.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-file-privs $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-innodb b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-innodb
new file mode 100755
index 0000000..038f564
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-innodb
@@ -0,0 +1,368 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -C) shift; OPT_CHEK="${1}"; shift; ;;
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_CHEK="${OPT_CHEK:-idle_blocker_duration}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+ NOTE="UNK could not find information about transactions"
+
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+
+ case "${OPT_CHEK}" in
+ idle_blocker_duration)
+ OPT_WARN=${OPT_WARN:-60}
+ OPT_CRIT=${OPT_CRIT:-600}
+ OUTPUT=$(mysql_exec "
+ SELECT MAX(COALESCE(p.time, 0)) AS idle_in_trx,
+ p.id,
+ CONCAT(p.user, '@', p.host) AS userhost
+ FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS AS w
+ INNER JOIN INFORMATION_SCHEMA.INNODB_TRX AS b ON b.trx_id = w.blocking_trx_id
+ INNER JOIN INFORMATION_SCHEMA.INNODB_TRX AS r ON r.trx_id = w.requesting_trx_id
+ LEFT JOIN INFORMATION_SCHEMA.PROCESSLIST AS p ON p.id = b.trx_mysql_thread_id AND p.command = 'Sleep'
+ GROUP BY p.id, p.user, p.host
+ ORDER BY idle_in_trx DESC LIMIT 1" 2>"${TEMP}")
+ if [ "$?" != 0 ]; then
+ if grep "Unknown table" "${TEMP}" >/dev/null 2>&1; then
+ # The I_S tables don't exist.
+ NOTE="OK The INFORMATION_SCHEMA.INNODB_% tables don't exist."
+ else
+ cat "${TEMP}"
+ fi
+ elif [ -z "${OUTPUT}" ]; then
+ OUTPUT=0
+ fi
+ ;;
+ waiter_count)
+ OPT_WARN=${OPT_WARN:-10}
+ OPT_CRIT=${OPT_CRIT:-25}
+ OUTPUT=$(mysql_exec "
+ SELECT COUNT(DISTINCT REQUESTING_TRX_ID) AS cnt
+ FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS AS w" 2>"${TEMP}")
+ if [ "$?" != 0 ]; then
+ if grep "Unknown table" "${TEMP}" >/dev/null 2>&1; then
+ # The I_S tables don't exist.
+ mysql_exec "SHOW /*!50000 ENGINE*/ INNODB STATUS\G" > "${TEMP}" || exit $?
+ OUTPUT=$(get_waiter_count "${TEMP}")
+ else
+ cat "${TEMP}"
+ fi
+ fi
+ ;;
+ max_duration)
+ OPT_WARN=${OPT_WARN:-60}
+ OPT_CRIT=${OPT_CRIT:-600}
+ OUTPUT=$(mysql_exec "
+ SET @@time_zone='SYSTEM';
+ SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(t.trx_started),
+ p.id,
+ CONCAT(p.user, '@', p.host)
+ FROM INFORMATION_SCHEMA.INNODB_TRX AS t
+ JOIN INFORMATION_SCHEMA.PROCESSLIST AS p ON p.id = t.trx_mysql_thread_id
+ ORDER BY t.trx_started LIMIT 1" 2>"${TEMP}")
+ if [ "$?" != 0 ]; then
+ if grep "Unknown table" "${TEMP}" >/dev/null 2>&1; then
+ # The I_S tables don't exist.
+ mysql_exec "SHOW /*!50000 ENGINE*/ INNODB STATUS\G" > "${TEMP}" || exit $?
+ OUTPUT=$(get_longest_trx "${TEMP}")
+ if [ -z "${OUTPUT}" ]; then
+ OUTPUT=0
+ fi
+ else
+ cat "${TEMP}"
+ fi
+ elif [ -z "${OUTPUT}" ]; then
+ OUTPUT=0
+ fi
+ ;;
+ *)
+ echo "Unknown value for -C: '${OPT_CHEK}'. Consult the documentation.";
+ exit 1;
+ ;;
+ esac
+
+ # $OUTPUT now contains either an empty string or three words: 1) Age of
+ # oldest transaction, 2) thread ID of oldest transaction, 3) user info.
+ if [ -n "${OUTPUT}" ]; then
+ LEVEL="$(echo ${OUTPUT} | awk '{print $1}')"
+ INFO="$(echo ${OUTPUT} | awk '{print "(thread "$2" by "$3")"}')"
+
+ case "${OPT_CHEK}" in
+ idle_blocker_duration)
+ NOTE="longest blocking idle transaction sleeps for ${LEVEL:-UNKNOWN} seconds"
+ ;;
+ waiter_count)
+ NOTE="${LEVEL:-UNKNOWN} transactions in LOCK WAIT status"
+ INFO=""
+ ;;
+ max_duration)
+ NOTE="longest transaction active for ${LEVEL:-UNKNOWN} seconds"
+ ;;
+ esac
+ if [ "${LEVEL:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE $INFO"
+ elif [ "${LEVEL:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE $INFO"
+ else
+ NOTE="OK $NOTE"
+ fi
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Gets max txn time in SHOW INNODB STATUS. File is $1.
+# ########################################################################
+get_longest_trx() {
+ awk '
+ BEGIN {
+ maxtime = 0;
+ thread = 0;
+ userinfo = "nobody";
+ }
+ /^TRANSACTIONS$/ {
+ tseen = 1;
+ }
+ {
+ if ( tseen == 1 && $0 ~ /^---TRANSACTION.*[0-9] sec/ ) {
+ if ( $2 ~ /,/ ) {
+ time = $4;
+ }
+ else {
+ time = $5;
+ }
+ }
+ if ( tseen == 1 && $0 ~ /^MySQL thread id/ ) {
+ if ( time > maxtime ) {
+ maxtime = time;
+ thread = substr($4, 1, length($4) - 1);
+ match($0, /query id [0-9]+ .+/);
+ userinfo = substr($0, RSTART, RLENGTH);
+ split(userinfo, a, " ");
+ userinfo = a[5]"@"a[4];
+ }
+ }
+ }
+ END {
+ print maxtime, thread, userinfo;
+ }
+ ' "${1}"
+}
+
+# ########################################################################
+# Counts the number of LOCK WAIT in SHOW INNODB STATUS. File is $1.
+# ########################################################################
+get_waiter_count() {
+ awk '
+ BEGIN {
+ lock_waits = 0;
+ }
+ /^TRANSACTIONS$/ {
+ tseen = 1;
+ }
+ {
+ if ( tseen == 1 && $0 ~ /TRX HAS BEEN WAITING/ ) {
+ lock_waits++;
+ }
+ }
+ END {
+ print lock_waits;
+ }
+ ' "${1}"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-innodb" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-innodb - Alert on problems inside InnoDB.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-innodb [OPTIONS]
+ Options:
+ -C CHECK What to alert on; default idle_blocker_duration.
+ Other options: waiter_count, max_duration.
+ -c CRIT Critical threshold; default varies.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -w WARN Warning threshold; default varies.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin alerts on various aspects of InnoDB status in several ways,
+depending on the value of the -C option:
+
+=over
+
+=item idle_blocker_duration
+
+This is the default behavior. It alerts when a long-running transaction is
+blocking another, and the blocker is idle (Sleep). The threshold is based on
+how long the transaction has been idle. Long-running idle transactions that
+have acquired locks but not released them are a frequent cause of application
+downtime due to lock wait timeouts and rollbacks, especially because
+applications are often not designed to handle such errors correctly. The
+problem is usually due to another error that causes a transaction not to be
+committed, such as performing very long tasks in the application while holding
+the transaction open.
+
+This check examines the INFORMATION_SCHEMA tables included with InnoDB version
+1.0 and newer. The default critical level is 600, and warning is 60. If the
+tables do not exist, the exit status is OK, with a note that the tables do not
+exist.
+
+=item waiter_count
+
+Alerts if too many transactions are in LOCK WAIT status. Uses information from
+SHOW ENGINE INNODB STATUS if the INFORMATION_SCHEMA tables are not available.
+The default critical level is 25, and warning is 10.
+
+=item max_duration
+
+Alerts if any transaction is too old. Uses information from SHOW ENGINE INNODB
+STATUS if the INFORMATION_SCHEMA tables are not available. The default critical
+level is 600, and warning is 60.
+
+=back
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SHOW ENGINE INNODB STATUS>.
+
+=item *
+
+C<SELECT> against the C<INFORMATION_SCHEMA> InnoDB transaction and lock tables.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-innodb $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-pidfile b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-pidfile
new file mode 100755
index 0000000..bd6c0e5
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-pidfile
@@ -0,0 +1,291 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Set the exit status in case there are any problems.
+ NOTE="UNK could not determine the PID file location."
+
+ # Set up files to hold one or more PID file locations.
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ local FILES=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' '${FILES}' >/dev/null 2>&1" EXIT
+
+ # If any connection option was given, then try to log in to find the PID
+ # file.
+ if [ "${OPT_DEFT}${OPT_HOST}${OPT_USER}${OPT_PASS}${OPT_PORT}${OPT_SOCK}" ]; then
+ # If this fails (e.g. we can't log in), then there will be no line in the
+ # file, and later we won't change the exit code / note away from "UNK".
+ if mysql_exec "SHOW GLOBAL VARIABLES" > "${TEMP}"; then
+ get_pidfile "${TEMP}" >> "${FILES}"
+ fi
+ else
+ # Find all MySQL server instances.
+ for pid in $(_pidof mysqld); do
+ ps -p ${pid} -o pid,command | grep "${pid}" >> "${TEMP}"
+ done
+ # The ${TEMP} file may now contain lines like the following sample:
+ # 13822 /usr/sbin/mysqld --defaults-file=/var/lib/mysql/my.cnf \
+ # --basedir=/usr --datadir=/var/lib/mysql/data/ \
+ # --pid-file=/var/run/mysqld/mysqld.pid \
+ # --socket=/var/run/mysqld/mysqld.sock
+ # Now the task is to read find any reference to a --pid-file or --pid_file option.
+ # We store these into the $FILES temp file.
+ while read pid command; do
+ if echo "${command}" | grep pid.file >/dev/null 2>&1; then
+ # Strip off everything up to and including --pid-file=
+ command="${command##*--pid?file=}"
+ # Strip off any options that follow this, assuming that there's not
+ # a space followed by a dash in the pidfile's path.
+ echo "${command%% -*}" >> "${FILES}"
+ fi
+ done < "${TEMP}"
+ fi
+
+ # TODO: maybe in the future we can also check whether the PID in the file is
+ # correct. TODO: maybe we should also alert on which PID is missing its
+ # pidfile.
+ MISSING=""
+ NOTE2=""
+ while read pidfile; do
+ if [ ! -e "${pidfile}" ]; then
+ MISSING=1
+ NOTE2="${NOTE2:+${NOTE2}; }missing ${pidfile}"
+ fi
+ NOTE="OK all PID files exist."
+ done < "${FILES}"
+
+ if [ "${MISSING}" ]; then
+ if [ "${OPT_CRIT}" ]; then
+ NOTE="CRIT ${NOTE2}"
+ else
+ NOTE="WARN ${NOTE2}"
+ fi
+ fi
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# A wrapper around pidof, which might not exist. The first argument is the
+# command name to match.
+# ########################################################################
+_pidof() {
+ if ! pidof "${1}" 2>/dev/null; then
+ ps axo pid,ucomm | awk -v comm="${1}" '$2 == comm { print $1 }'
+ fi
+}
+
+# ########################################################################
+# Unfortunately, MySQL 5.0 doesn't have a system variable @@pid_file, so
+# we have to use SHOW VARIABLES and a temp file. In 5.1 and newer we
+# could have done it in a single SQL statement:
+# SELECT IF(@@pid_file LIKE '/%', @@pid_file,
+# CONCAT(@@basedir, @@pid_file))" >> "${FILES}"
+# The first argument is the file that contains SHOW VARIABLES.
+# ########################################################################
+get_pidfile() {
+ awk '
+ /^pid_file/ { pid_file = $2 }
+ /^basedir/ { basedir = $2 }
+ END {
+ if ( substr(pid_file, 1, 1) != "/" ) {
+ pid_file = basedir pid_file;
+ }
+ print pid_file;
+ }
+ ' "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-pidfile" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-pidfile - Alert when the mysqld PID file is missing.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-pidfile [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; makes a missing PID file critical.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -w WARN Warning threshold; ignored.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin checks to make sure that the MySQL PID file is not missing.
+The PID file contains the process ID of the MySQL server process, and is used by
+init scripts to start and stop the server. If it is deleted for some reason,
+then it is likely that the init script will not work correctly. The file can be
+deleted by poorly written scripts, an accident, or a mistaken attempt to restart
+MySQL while it is already running, especially if mysqld is executed directly
+instead of using the init script.
+
+The plugin accepts the -w and -c options for compatibility with standard Nagios
+plugin conventions, but they are not based on a threshold. Instead, the plugin
+raises a warning by default, and if the -c option is given, it raises an error
+instead, regardless of the option.
+
+By default, this plugin will attempt to detect all running instances of MySQL,
+and verify the PID file's existence for each one. It does this purely by
+examining the Unix process table with the C<ps> tool. However, in some cases
+the process's command line does not list the path to the PID file. If the tool
+fails to detect the MySQL server process, or if you wish to limit the check to a
+single instance in the event that there are multiple instances on a single
+server, then you can specify MySQL authentication options. This will cause the
+plugin to skip examining the Unix processlist, log into MySQL, and examine the
+pid_file variable from SHOW VARIABLES to find the location of the PID file.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> the system variables C<@@pid_file> and C<@@basedir>.
+
+=back
+
+This plugin executes the following UNIX commands that may need special privileges:
+
+=over
+
+=item *
+
+ps
+
+=back
+
+The plugin should be able to either get variables from MySQL or find mysqld
+PID using C<ps> command.
+
+On BSD, if C<sysctl> option C<security.bsd.see_other_uids> is set to 0, C<ps>
+will not return mysqld PID if the plugin run from non-root user.
+
+Also an user you run the plugin from should be able to access MySQL PID file
+file, so you may want to add it into mysql unix group etc.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-pidfile $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-processlist b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-processlist
new file mode 100755
index 0000000..b2985f0
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-processlist
@@ -0,0 +1,323 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -C) shift; OPT_CHEK="${1}"; shift; ;;
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_CHEK="${OPT_CHEK:-states_count}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Get processlist into a temp file.
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+
+ case "${OPT_CHEK}" in
+ states_count)
+ OPT_WARN=${OPT_WARN:-16}
+ OPT_CRIT=${OPT_CRIT:-32}
+
+ # Capture a number of types of states, add some together, take the max,
+ # and compare to the threshold.
+ mysql_exec 'SHOW PROCESSLIST\G' > "${TEMP}"
+ if [ $? = 0 ]; then
+ UNAUTH=$(count_mysql_processlist "${TEMP}" "User" "unauthenticated user")
+ LOCKED1=$(count_mysql_processlist "${TEMP}" "State" "Locked")
+ LOCKED2=$(count_mysql_processlist "${TEMP}" "State" "Waiting for .* lock")
+ LOCKED3=$(count_mysql_processlist "${TEMP}" "State" "Table lock")
+ LOCKED4=$(count_mysql_processlist "${TEMP}" "State" "Waiting for table flush")
+ LOCKED5=$(count_mysql_processlist "${TEMP}" "State" "Waiting for tables")
+ COPYIN=$(count_mysql_processlist "${TEMP}" "State" ".*opy.* to.* table.*")
+ STATIS=$(count_mysql_processlist "${TEMP}" "State" "statistics")
+ LOCKED=$((${LOCKED1:-0} + ${LOCKED2:-0} + ${LOCKED3:-0} + ${LOCKED4:-0} + ${LOCKED5:-0}))
+ NOTE="${UNAUTH} unauthenticated, ${LOCKED} locked,"
+ NOTE="${NOTE} ${COPYIN} copy to table, ${STATIS} statistics"
+ MAX="$(max "${UNAUTH:-0}" "${LOCKED:-0}" "${COPYIN:-0}" "${STATIS:-0}")"
+ if [ "${MAX:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ elif [ "${MAX:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE"
+ else
+ NOTE="OK $NOTE"
+ fi
+
+ # Build the common perf data output for graph trending
+ PERFDATA="processes=${MAX:-0};${OPT_WARN};${OPT_CRIT};0;"
+ NOTE="$NOTE | $PERFDATA"
+ else
+ NOTE="UNK could not retrieve MySQL processlist"
+ fi
+ ;;
+ max_user_conn)
+ OPT_WARN=${OPT_WARN:-90}
+ OPT_CRIT=${OPT_CRIT:-95}
+
+ # Check if @@max_user_connections is set on MySQL
+ MAX_USER_CONN=$(mysql_exec 'SELECT @@max_user_connections')
+ if [ $? = 0 ]; then
+ if [ ${MAX_USER_CONN:-0} -gt 0 ]; then
+ # Capture a number of connections per user from the processlist, take the max,
+ # and compare to the threshold.
+ mysql_exec 'SHOW PROCESSLIST\G' > "${TEMP}"
+ if [ $? = 0 ]; then
+ MAX_USER=$(cat ${TEMP}|grep User|awk '{print $2}'|sort|uniq -c|sort -n|tail -1)
+ CNT=$(echo ${MAX_USER} | awk '{print $1}')
+ USER=$(echo ${MAX_USER} | awk '{print $2}')
+ MAX=$(expr ${CNT} \* 100 / ${MAX_USER_CONN})
+ NOTE="User with max connections: ${USER} (${CNT}) = ${MAX}%"
+ if [ "${MAX:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ elif [ "${MAX:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE"
+ else
+ NOTE="OK $NOTE"
+ fi
+
+ # Build the common perf data output for graph trending
+ PERFDATA="max_user_conn=${MAX:-0};${OPT_WARN};${OPT_CRIT};0;100"
+ NOTE="$NOTE | $PERFDATA"
+ else
+ NOTE="UNK could not retrieve MySQL processlist"
+ fi
+ else
+ NOTE="OK @@max_user_connections is not configured."
+ fi
+ else
+ NOTE="UNK could not retrieve @@max_user_connections"
+ fi
+ ;;
+ *)
+ echo "Unknown value for -C: '${OPT_CHEK}'. Consult the documentation.";
+ exit 1;
+ ;;
+ esac
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Extract a count from MySQL processlist. The arguments are:
+# $1 - file with the processlist.
+# $2 - the column to examine.
+# $3 - the value to count.
+# ########################################################################
+count_mysql_processlist() {
+ local FILE="${1}"
+ local COL="${2}"
+ local MATCH="${3}"
+ grep -c "^ *${COL}: ${MATCH}" "${FILE}"
+}
+
+# ########################################################################
+# Find the maximum argument, assuming nonnegative integers.
+# ########################################################################
+max() {
+ local MAX=0
+ for val; do
+ if [ "${val:-0}" -gt "${MAX}" ]; then
+ MAX="${val}"
+ fi
+ done
+ echo "${MAX:-0}"
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-processlist" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-processlist - Alert when MySQL processlist has dangerous patterns.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-processlist [OPTIONS]
+ Options:
+ -C CHECK What to alert on; default states_count.
+ Other options: max_user_conn.
+ -c CRIT Critical threshold; default varies.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -w WARN Warning threshold; default varies.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin examines MySQL processlist in several ways,
+depending on the value of the -C option:
+
+=over
+
+=item states_count
+
+Alerts when there are too many processes in various states.
+The list of checks is as follows:
+
+Unauthenticated users appear when DNS resolution is slow, and can be a warning
+sign of DNS performance problems that could cause a sudden denial of service to
+the server.
+
+Locked processes are the signature of MyISAM tables, but can also appear for
+other reasons.
+
+Too many processes copying to various kinds of temporary tables at one time is a
+typical symptom of a storm of poorly optimized queries.
+
+Too many processes in the "statistics" state is a signature of InnoDB
+concurrency problems causing query execution plan generation to take too long.
+
+The thresholds should be given as count. The default critical level is 32,
+and warning is 16.
+
+=item max_user_conn
+
+Alerts when C<@@max_user_connections> is configured on MySQL and any user reaches
+this limit. The output of this check will display the user with maximum
+connections consumed, its count and percentage of the actual limit.
+
+The thresholds should be given as percentage. The default critical level is 95,
+and warning is 90.
+
+=back
+
+Examples:
+
+ # /usr/lib64/nagios/plugins/pmp-check-mysql-processlist
+ OK 0 unauthenticated, 0 locked, 0 copy to table, 0 statistics | processes=0;16;32;0;
+
+ # /usr/lib64/nagios/plugins/pmp-check-mysql-processlist -C max_user_conn
+ OK User with max connections: myappuser (70) = 2% | max_user_conn=2;90;95;0;100
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SHOW PROCESSLIST;>
+
+=item *
+
+C<SELECT @@max_user_connections;>
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-processlist $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-delay b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-delay
new file mode 100755
index 0000000..1f02585
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-delay
@@ -0,0 +1,280 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ OPT_ENSURE_SBM=0
+ MIN_DELAY_SET=0
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -m) shift; OPT_MIN="${1}"; MIN_DELAY_SET=1; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -s) shift; OPT_SRVID="${1}"; shift; ;;
+ -T) shift; OPT_TABLE="${1}"; shift; ;;
+ -u) shift; OPT_UTC=1; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --master-conn) shift; OPT_MASTERCONN="${1}"; shift; ;;
+ --channel) shift; OPT_CHANNEL="${1}"; shift; ;;
+ --unconfigured) shift; OPT_REPLNOTSET=1; ;;
+ --ensure-sbm) shift; OPT_ENSURE_SBM=1; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_WARN=${OPT_WARN:-300}
+ OPT_CRIT=${OPT_CRIT:-600}
+ OPT_MIN=${OPT_MIN:-0}
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Get replication delay from a heartbeat table or from SHOW SLAVE STATUS.
+ get_slave_status $1
+ if [ "${OPT_TABLE}" ]; then
+ if [ -z "${OPT_UTC}" ]; then
+ NOW_FUNC='UNIX_TIMESTAMP()'
+ else
+ NOW_FUNC='UNIX_TIMESTAMP(UTC_TIMESTAMP)'
+ fi
+ if [ "${OPT_SRVID}" == "MASTER" ]; then
+ if [ "${MYSQL_CONN}" = 0 ]; then
+ OPT_SRVID=$(awk '/Master_Server_Id/{print $2}' "${TEMP_SLAVEDATA}")
+ fi
+ fi
+ SQL="SELECT MAX(${NOW_FUNC} - ROUND(UNIX_TIMESTAMP(ts))) AS delay
+ FROM ${OPT_TABLE} WHERE (${OPT_SRVID:-0} = 0 OR server_id = ${OPT_SRVID:-0})"
+ LEVEL=$(mysql_exec "${SQL}")
+ MYSQL_CONN=$?
+ else
+ if [ "${MYSQL_CONN}" = 0 ]; then
+ LEVEL=$(awk '/Seconds_Behind_Master/{print $2}' "${TEMP_SLAVEDATA}")
+ fi
+ fi
+
+ # Check for SQL thread errors
+ LAST_SLAVE_ERRNO=$(awk '/Last_SQL_Errno/{print $2}' "${TEMP_SLAVEDATA}")
+
+ # Build the common perf data output for graph trending
+ PERFDATA="replication_delay=${LEVEL:-0};${OPT_WARN};${OPT_CRIT};0;"
+
+ # Test whether the delay is too long.
+ if [ "$MYSQL_CONN" = 0 ]; then
+ NOTE="${LEVEL:-0} seconds of replication delay"
+ if [ "${LEVEL:-""}" = "NULL" ]; then
+ test ${MIN_DELAY_SET} -eq 1 && \
+ test ${LAST_SLAVE_ERRNO} -eq 0 && \
+ test ${OPT_ENSURE_SBM} -eq 0 && \
+ NOTE="OK NULL seconds of replication delay" || NOTE="UNK replica is stopped"
+ elif [ -z "${LEVEL}" -a "${OPT_REPLNOTSET}" ]; then
+ NOTE="UNK This server is not configured as a replica."
+ # pt-slave-delayed slave
+ elif [ ${MIN_DELAY_SET} -eq 1 ] && [ "${LEVEL:-0}" -lt "${OPT_MIN}" ]; then
+ NOTE="CRIT (delayed slave) $NOTE | $PERFDATA"
+ elif [ "${LEVEL:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE | $PERFDATA"
+ elif [ "${LEVEL:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE | $PERFDATA"
+ else
+ NOTE="OK $NOTE | $PERFDATA"
+ fi
+ else
+ NOTE="UNK could not determine replication delay"
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-replication-delay" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Captures the "SHOW SLAVE STATUS" output into a temp file.
+# ########################################################################
+get_slave_status() {
+ TEMP_SLAVEDATA=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP_SLAVEDATA}' >/dev/null 2>&1" EXIT
+ if [ -z "$1" ]; then
+ if [ "${OPT_MASTERCONN}" ]; then
+ # MariaDB multi-source replication
+ mysql_exec "SHOW SLAVE '${OPT_MASTERCONN}' STATUS\G" > "${TEMP_SLAVEDATA}"
+ elif [ "${OPT_CHANNEL}" ]; then
+ mysql_exec "SHOW SLAVE STATUS FOR CHANNEL '${OPT_CHANNEL}'\G" > "${TEMP_SLAVEDATA}"
+ else
+ # Leverage lock-free SHOW SLAVE STATUS if available
+ mysql_exec "SHOW SLAVE STATUS NONBLOCKING\G" > "${TEMP_SLAVEDATA}" 2>/dev/null ||
+ mysql_exec "SHOW SLAVE STATUS NOLOCK\G" > "${TEMP_SLAVEDATA}" 2>/dev/null ||
+ mysql_exec "SHOW SLAVE STATUS\G" > "${TEMP_SLAVEDATA}"
+ fi
+ MYSQL_CONN=$?
+ else
+ # This is for testing only.
+ cat "$1" > "${TEMP_SLAVEDATA}" 2>/dev/null
+ MYSQL_CONN=0
+ fi
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-replication-delay - Alert when MySQL replication becomes delayed.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-replication-delay [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; default 600.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -m CRIT Minimal threshold to ensure for delayed slaves; default 0.
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -s SERVERID MySQL server ID of master, if using pt-heartbeat table. If
+ the parameter is set to "MASTER" the plugin will lookup the
+ server_id of the master
+ -T TABLE Heartbeat table used by pt-heartbeat.
+ -u Use UTC time to count the delay in case pt-heartbeat is run
+ with --utc option.
+ -w WARN Warning threshold; default 300.
+ --master-conn NAME Master connection name for MariaDB multi-source replication.
+ --channel NAME Master channel name for multi-source replication (MySQL 5.7.6+).
+ --unconfigured Alert when replica is not configured at all; default no.
+ --ensure-sbm Disallow Seconds_Behind_Master to be NULL for delayed slaves when -m is used
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin examines whether MySQL replication is delayed too much. By
+default it uses SHOW SLAVE STATUS, but the output of the Seconds_behind_master
+column from this command is unreliable, so it is better to use pt-heartbeat from
+Percona Toolkit instead. Use the -T option to specify which table pt-heartbeat
+updates. Use the -s option to specify the master's server_id to compare
+against; otherwise the plugin reports the maximum delay from any server. Use
+the -s options with the value "MASTER" to have plugin lookup the master's server_id
+
+If you want to run this check against the delayed slaves, e.g. those running
+with pt-slave-delay tool, you may want to use -m option specifying the minimal
+delay that should be ongoing, otherwise the plugin will alert critical.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SHOW SLAVE STATUS [NONBLOCKING|NOLOCK]>
+
+or
+
+=item *
+
+C<SELECT> from the C<pt-heartbeat> table.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-replication-delay $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-running b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-running
new file mode 100755
index 0000000..27f2f18
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-replication-running
@@ -0,0 +1,242 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -d) shift; OPT_DELD=1; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --master-conn) shift; OPT_MASTERCONN="${1}"; shift; ;;
+ --channel) shift; OPT_CHANNEL="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Get replication status into a temp file. TODO: move this into a subroutine
+ # and test it. But, if there is a commandline argument left over after
+ # parsing options, then use that as the file instead.
+ local TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+ if [ -z "$1" ]; then
+ if [ "${OPT_MASTERCONN}" ]; then
+ # MariaDB multi-source replication
+ mysql_exec "SHOW SLAVE '${OPT_MASTERCONN}' STATUS\G" > "${TEMP}"
+ elif [ "${OPT_CHANNEL}" ]; then
+ mysql_exec "SHOW SLAVE STATUS FOR CHANNEL '${OPT_CHANNEL}'\G" > "${TEMP}"
+ else
+ # Leverage lock-free SHOW SLAVE STATUS if available
+ mysql_exec "SHOW SLAVE STATUS NONBLOCKING\G" > "${TEMP}" 2>/dev/null ||
+ mysql_exec "SHOW SLAVE STATUS NOLOCK\G" > "${TEMP}" 2>/dev/null ||
+ mysql_exec "SHOW SLAVE STATUS\G" > "${TEMP}"
+ fi
+ else
+ # This is just for testing. /dev/null it.
+ cat "$1" > "${TEMP}" 2>/dev/null
+ fi
+
+ if [ $? = 0 ]; then
+ # SHOW SLAVE STATUS isn't an error if the server isn't a replica. The file
+ # will be empty if that happens.
+ if [ -s "${TEMP}" ]; then
+ NOTE=$(awk '$1 ~ /_Running:|Last_Error:/{print substr($0, 1, 100)}' "${TEMP}")
+ if grep 'Last_Error: .' "${TEMP}" >/dev/null 2>&1; then
+ NOTE="CRIT $NOTE"
+ # pt-slave-delayed slave
+ elif [ -n "${OPT_DELD}" ] &&
+ grep 'Slave_IO_Running: Yes' "${TEMP}" >/dev/null 2>&1 &&
+ grep 'Slave_SQL_Running: No' "${TEMP}" >/dev/null 2>&1; then
+ NOTE="OK (delayed slave) $NOTE"
+ elif egrep "_Running: (No|Connecting)" "${TEMP}" >/dev/null 2>&1; then
+ if [ "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ else
+ NOTE="WARN $NOTE"
+ fi
+ else
+ NOTE="OK $NOTE"
+ fi
+ elif [ "${OPT_WARN}" ]; then
+ # Empty file; not a replica, but that's not supposed to happen.
+ NOTE="WARN This server is not configured as a replica."
+ else
+ # Empty file; not a replica.
+ NOTE="OK This server is not configured as a replica."
+ fi
+ else
+ NOTE="UNK could not determine replication status"
+ fi
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-replication-running" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-replication-running - Alert when MySQL replication stops.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-replication-running [OPTIONS]
+ Options:
+ -c CRIT Report CRITICAL when replication is stopped with or w/o errors.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -d Useful for slaves delayed by pt-slave-delay. It will not alert
+ when IO thread is running, SQL one is not and no errors.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -w WARN Report WARNING when SHOW SLAVE STATUS output is empty.
+ --master-conn NAME Master connection name for MariaDB multi-source replication.
+ --channel NAME Master channel name for multi-source replication (MySQL 5.7.6+).
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin examines whether replication is running. It is separate from
+the check for delay because it is confusing or impossible to handle all of the
+combinations of replication errors and delays correctly, and provide an
+appropriate type of alert, in a single program.
+
+By default, this plugin treats it as critical when the either thread stops with
+an error, and a warning when threads are stopped with no error. You can provide
+critical and warning thresholds with the -c and -w options, for compatibility
+with Nagios plugin conventions, but they don't work as thresholds. Instead, if
+you specify a critical threshold, this plugin will treat it as critical if
+either thread is stopped, with or without an error.
+
+The warning threshold makes the plugin report a warning when SHOW SLAVE STATUS
+produces no output, which means it is not configured as a replica. By default,
+this plugin will report that replication is healthy when a server isn't
+configured as a replica.
+
+If you want to run this check against the delayed slaves, e.g. those running
+with pt-slave-delay tool, you may want to specify -d option. It will not alert
+when Slave_IO_Running is Yes, Slave_SQL_Running is No and there are no errors.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SHOW SLAVE STATUS [NONBLOCKING|NOLOCK]>
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-replication-running $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-status b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-status
new file mode 100755
index 0000000..89c2a6a
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-status
@@ -0,0 +1,482 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -C) shift; OPT_COMP="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -I) shift; OPT_INCR="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -o) shift; OPT_OPER="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -T) shift; OPT_TRAN="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ -x) shift; OPT_VAR1="${1}"; shift; ;;
+ -y) shift; OPT_VAR2="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ # Set default option values
+ OPT_COMP="${OPT_COMP:->=}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ # Validate the options.
+ OPT_ERR=""
+ if [ -z "${OPT_CRIT}${OPT_WARN}" ]; then
+ OPT_ERR="you must specify either -c or -w"
+ elif [ -z "${OPT_VAR1}" ]; then
+ OPT_ERR="you must specify -x"
+ elif [ "${OPT_OPER}" -a -z "${OPT_VAR2}" ]; then
+ OPT_ERR="you specified -o but not -y"
+ elif [ "${OPT_VAR2}" -a -z "${OPT_OPER}" ]; then
+ OPT_ERR="you specified -y but not -o"
+ elif [ "${OPT_TRAN}" = 'pct' -a -z "${OPT_VAR2}" ]; then
+ OPT_ERR="you specified -T pct but not -y"
+ elif [ "${OPT_TRAN}" ]; then
+ case "${OPT_TRAN}" in
+ pct|str)
+ ;;
+ *)
+ OPT_ERR="-T must be one of: pct str"
+ ;;
+ esac
+ fi
+ case "${OPT_COMP}" in
+ '=='|'!='|'>='|'>'|'<'|'<=')
+ ;;
+ *)
+ OPT_ERR="-C must be one of: == != >= > < <="
+ ;;
+ esac
+ if [ "${OPT_OPER}" ]; then
+ case "${OPT_OPER}" in
+ /|'*'|+|-)
+ :
+ ;;
+ *)
+ OPT_ERR="-o must be one of: / * + -"
+ ;;
+ esac
+ fi
+ if [ "${OPT_ERR}" ]; then
+ echo "Error: $OPT_ERR. Try --help."
+ exit 1
+ fi
+
+ NOTE="UNK could not evaluate the expression."
+
+ # Set up a temporary file
+ local TEMP1=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ local TEMP2=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP1}' '${TEMP2}' >/dev/null 2>&1" EXIT
+
+ if get_status_variables "${TEMP1}" "${TEMP2}" "${OPT_INCR}"; then
+ LEVEL=$(compute_result "${TEMP1}" "${OPT_VAR1}" "${OPT_OPER}" "${OPT_VAR2}" "${OPT_TRAN}")
+ if [ $? = 0 -a -n "${LEVEL}" ]; then
+ NOTE="${OPT_VAR1}${OPT_OPER:+ ${OPT_OPER}}${OPT_VAR2:+ ${OPT_VAR2}}${OPT_TRAN:+ (${OPT_TRAN})}"
+ NOTE="${NOTE} = ${LEVEL}"
+
+ # XXX Make sure this line and the "case" don't get separated.
+ compare_result "${LEVEL}" "${OPT_CRIT}" "${OPT_WARN}" "${OPT_COMP}" "${OPT_TRAN}"
+ case $? in
+ $STATE_OK)
+ NOTE="OK $NOTE"
+ ;;
+ $STATE_CRITICAL)
+ NOTE="CRIT $NOTE"
+ ;;
+ $STATE_WARNING)
+ NOTE="WARN $NOTE"
+ ;;
+ esac
+
+ # Build the common perf data output for graph trending
+ if [ "${OPT_TRAN}" = 'pct' ]; then
+ PERFDATA_MAX=100
+ fi
+ PERFDATA="${OPT_VAR1}${OPT_OPER}${OPT_VAR2}=${LEVEL};${OPT_WARN};${OPT_CRIT};0;${PERFDATA_MAX}"
+ NOTE="$NOTE | $PERFDATA"
+ fi
+ else
+ NOTE="UNK could not get MySQL status/variables."
+ fi
+
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Compares the variable to the thresholds. Arguments: VAR CRIT WARN CMP TRAN
+# Returns nothing; exits with OK/WARN/CRIT.
+# ########################################################################
+compare_result() {
+ local VAR="${1}"
+ local CRIT="${2}"
+ local WARN="${3}"
+ local CMP="${4}"
+ local TRAN="${5}"
+ echo 1 | awk "END {
+ if ( \"${CRIT}\" != \"\" ) {
+ if ( \"${TRAN}\" == \"str\" ) {
+ if ( \"${VAR}\" ${CMP} \"${CRIT:-0}\" ) {
+ exit $STATE_CRITICAL
+ }
+ } else {
+ if ( ${VAR} ${CMP} ${CRIT:-0} ) {
+ exit $STATE_CRITICAL
+ }
+ }
+ }
+ if ( \"${WARN}\" != \"\" ) {
+ if ( \"${TRAN}\" == \"str\" ) {
+ if ( \"${VAR}\" ${CMP} \"${WARN:-0}\" ) {
+ exit $STATE_WARNING
+ }
+ } else {
+ if ( ${VAR} ${CMP} ${WARN:-0} ) {
+ exit $STATE_WARNING
+ }
+ }
+ }
+ exit $STATE_OK
+ }"
+}
+
+# ########################################################################
+# Computes an expression against the file of variables. Returns a float.
+# Arguments: TEMP VAR1 OPER VAR2 TRAN
+# ########################################################################
+compute_result() {
+ local TEMP="$1"
+ local VAR1="$2"
+ local OPER="$3"
+ local VAR2="$4"
+ local TRAN="$5"
+ if [ "${VAR2}" ]; then
+ # Extract two variables, apply an operator, and possibly apply a
+ # transform.
+ awk -F'\t' "
+ BEGIN {
+ got1 = \"Could not find variable ${VAR1}\";
+ got2 = \"Could not find variable ${VAR2}\";
+ }
+ \$1 == \"${VAR1}\" {
+ var1 = \$2;
+ got1 = \"\";
+ }
+ \$1 == \"${VAR2}\" {
+ var2 = \$2;
+ got2 = \"\";
+ }
+ END {
+ if ( got1 == \"\" && got2 == \"\" ) {
+ if ( var2 == 0 && \"${OPER}\" == \"/\" ) {
+ # Divide-by-zero; make the result simply 0
+ val = 0;
+ }
+ else {
+ val = var1 ${OPER} var2;
+ }
+ if ( \"${TRAN}\" == \"pct\" ) {
+ val = val * 100;
+ }
+ if ( val ~ /\.[0-9]/ ) {
+ printf \"%.6f\\n\", val;
+ }
+ else {
+ print val;
+ }
+ }
+ else {
+ print got1, got2 | \"cat 1>&2\";
+ exit 1;
+ }
+ }
+ " "${TEMP}"
+ else
+ # This is the simplest case. We're just extracting a single variable and
+ # returning it.
+ awk -F'\t' -v var1="${VAR1}" '
+ BEGIN {
+ got = 0;
+ }
+ $1 == var1 {
+ val = $2;
+ got = 1;
+ }
+ END {
+ if ( got == 1 ) {
+ print val;
+ }
+ else {
+ print "Unknown variable", var1 | "cat 1>&2";
+ exit 1;
+ }
+ }
+ ' "${TEMP}"
+ fi
+}
+
+# ########################################################################
+# Gets status variables. The first argument is the file to store the results.
+# Optional second argument is another temp file.
+# Optional third argument makes SHOW STATUS incremental/relative, and has the
+# added effect of filtering out non-numeric variables.
+# ########################################################################
+get_status_variables() {
+ if [ "$3" ]; then
+ mysql_exec "SHOW /*!50000 GLOBAL*/ STATUS" > "${2}" || exit 1
+ sleep "$3"
+ # Technically we ought to use another temp file, and check the return
+ # status of this mysql_exec, but if the first one worked it's likely that
+ # this one will too.
+ mysql_exec "SHOW /*!50000 GLOBAL*/ STATUS" | cat "${2}" - \
+ | awk -F'\t' '
+ /Aborted_clients/ { seen++; }
+ {
+ if ( seen > 1 && $2 !~ /[^0-9.]/ ) {
+ print $1 "\t" $2 - var[$1];
+ }
+ else {
+ var[$1] = $2;
+ }
+ }
+ ' > "${1}"
+ else
+ mysql_exec "SHOW /*!50000 GLOBAL*/ STATUS" > "${1}" || exit 1
+ fi
+ mysql_exec "SHOW /*!40101 GLOBAL*/ VARIABLES" >> "${1}"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-status" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-status - Check MySQL SHOW GLOBAL STATUS output.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-status [OPTIONS]
+ Options:
+ -c CRIT Critical threshold.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -C COMPARE Comparison operator to apply to -c and -w.
+ Possible values: == != >= > < <=. Default >=.
+ -H HOST MySQL hostname.
+ -I INCR Make SHOW STATUS incremental over this delay.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -o OPERATOR The operator to apply to -x and -y.
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -T TRANS Transformation to apply before comparing to -c and -w.
+ Possible values: pct str.
+ -w WARN Warning threshold.
+ -x VAR1 Required first status or configuration variable.
+ -y VAR2 Optional second status or configuration variable.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin captures SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES from
+MySQL and evaluates expressions against them. The general syntax is as follows:
+
+ VAR1 [ OPERATOR VAR2 [ TRANSFORM ] ]
+
+The result of evaluating this is compared against the -w and -c options as usual
+to determine whether to raise a warning or critical alert.
+
+Note that all of the examples provided below are simply for illustrative
+purposes and are not supposed to be recommendations for what to monitor. You
+should get advice from a professional if you are not sure what you should be
+monitoring.
+
+For our first example, we will raise a warning if Threads_running is 20 or over,
+and a critical alert if it is 40 or over:
+
+ -x Threads_running -w 20 -c 40
+
+The threshold is implemented as greater-or-equals by default, not strictly
+greater-than, so a value of 20 is a warning and a value of 40 is critical. You
+can switch this to less-or-equals or other operators with the -C option, which
+accepts the arithmetic comparison operators ==, !=, >, >=, <, and <=.
+
+You can use any variable that is present in SHOW VARIABLES or SHOW STATUS. If
+the variable is not found, there is an error. To warn if Threads_connected
+exceeds 80% of max_connections:
+
+ -x Threads_connected -o / -y max_connections -T pct -w 80
+
+The -T C<pct> option only works when you specify both -x and -y and implements
+percentage transformation. The plugin uses awk to do its
+computations and comparisons, so you can use floating-point math; you are not
+restricted to integers for comparisons. Floating-point numbers are printed with
+six digits of precision. The -o option accepts the arithmetic operators /, *,
++, and -. A division by zero results in zero, not an error.
+
+If you specify the -I option with an integer argument, the SHOW STATUS values
+become incremental instead of absolute. The argument is used as a delay in
+seconds, and instead of capturing a single sample of SHOW STATUS and using it
+for computations, the plugin captures two samples at the specified interval and
+subtracts the second from the first. This lets you evaluate expressions over a
+range of time. For example, to warn when there are 10 disk-based temporary
+tables per second, over a 5-second sampling period:
+
+ -x Created_tmp_disk_tables -o / -y Uptime -I 5 -w 10
+
+That is somewhat contrived, because it could also be written as follows:
+
+ -x Created_tmp_disk_tables -I 5 -w 50
+
+The -I option has the side effect of removing any non-numeric SHOW STATUS
+variables. Be careful not to set the -I option too large, or Nagios will simply
+time the plugin out, usually after about 10 seconds.
+
+This plugin does not support arbitrarily complex expressions, such as computing
+the query cache hit ratio and alerting if it is less than some percentage. If
+you are trying to do that, you might be doing it wrong. A dubious example for
+the query cache might be to alert if the hit-to-insert ratio falls below 2:1, as
+follows:
+
+ -x Qcache_hits -o / -y Qcache_inserts -C '<' -w 2
+
+Some people might suggest that the following is a more useful alert for the
+query cache:
+
+ -x query_cache_size -c 1
+
+To check Percona XtraDB Cluster node status you may want to use the following
+alert similar to what its clustercheck does:
+
+ -x wsrep_local_state -C '!=' -w 4
+
+To compare string variables use -T C<str> transformation. This is required as
+numeric and string comparisons are handled differently. The following example
+warns when the slave_exec_mode is IDEMPOTENT:
+
+ -x slave_exec_mode -C '==' -T str -w IDEMPOTENT
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SHOW STATUS>.
+
+=item *
+
+C<SHOW VARIABLES>.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-status $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-ts-count b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-ts-count
new file mode 100755
index 0000000..06ea3f4
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-mysql-ts-count
@@ -0,0 +1,210 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Ben Mildren
+# Depends-on: table with ts column, e.g. table written by pt-deadlock-logger
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -i) shift; OPT_INTERVAL="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -t) shift; OPT_TIMESTAMP="${1}"; shift; ;;
+ -T) shift; OPT_TABLE="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ -x) shift; OPT_TARGET="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_WARN=${OPT_WARN:-12}
+ OPT_CRIT=${OPT_CRIT:-60}
+ OPT_INTERVAL=${OPT_INTERVAL:-1}
+ OPT_TARGET="${OPT_TARGET:-deadlocks}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+ if [ "${OPT_TARGET}" == "kills" ]; then
+ OPT_TABLE="${OPT_TABLE:-percona.kill_log}"
+ OPT_TIMESTAMP="${OPT_TIMESTAMP:-timestamp}"
+ elif [ "${OPT_TARGET}" == "fkerrors" ]; then
+ OPT_TABLE="${OPT_TABLE:-percona.foreign_key_errors}"
+ OPT_TIMESTAMP="${OPT_TIMESTAMP:-ts}"
+ else
+ OPT_TABLE="${OPT_TABLE:-percona.deadlocks}"
+ OPT_TIMESTAMP="${OPT_TIMESTAMP:-ts}"
+ fi
+
+ LEVEL=$(mysql_exec "SELECT COUNT(*) FROM ${OPT_TABLE} WHERE ${OPT_TIMESTAMP} >= NOW() - INTERVAL ${OPT_INTERVAL}*60 SECOND")
+ if [ $? = 0 ]; then
+ NOTE="${LEVEL:-UNKNOWN} ${OPT_TARGET} in last ${OPT_INTERVAL} minutes"
+ if [ "${LEVEL:-0}" -gt "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ elif [ "${LEVEL:-0}" -gt "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE"
+ else
+ NOTE="OK $NOTE"
+ fi
+
+ # Build the common perf data output for graph trending
+ PERFDATA="${OPT_TARGET}=${LEVEL:-0};${OPT_WARN};${OPT_CRIT};0;"
+ NOTE="$NOTE | $PERFDATA"
+ else
+ NOTE="UNK could not count ${OPT_TARGET}"
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-mysql-ts-count" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-mysql-ts-count - Generic alert based on pmp-check-mysql-deadlocks to count number of rows written in the last interval.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-mysql-ts-count [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; default 60.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -i INTERVAL Interval over which to count, in minutes; default 1.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -t TIMESTAMP The name of the timestamp column to be monitored; default ts.
+ -T TABLE The database.table to be monitored; default percona.deadlocks.
+ -w WARN Warning threshold; default 12.
+ -x TARGET Metric monitored; default deadlocks.
+ Other options: kills, fkerrors.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin looks at a table and counts the number of rows since the
+last interval, and alerts if this exceeds the threshold. This could be the
+table referenced by pt-deadlock-logger, pt-kill, pt-fk-error-logger, or a
+custom table supplied.
+Default behaviour is the same as pmp-check-mysql-deadlocks, can also specify
+target to be C<kills> or C<fkerrors> to monitor default tables created by pt-kill
+or pt-fk-error-logger respectively, or supply custom metric and table.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> from the supplied table.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-mysql-ts-count $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-pt-table-checksum b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-pt-table-checksum
new file mode 100755
index 0000000..f8df9b8
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-pt-table-checksum
@@ -0,0 +1,239 @@
+#!/bin/bash
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+ # Get options
+ for o; do
+ case "${o}" in
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --defaults-file) shift; OPT_DEFT="${1}"; shift; ;;
+ -H) shift; OPT_HOST="${1}"; shift; ;;
+ -i) shift; OPT_INTERVAL="${1}"; shift; ;;
+ -l) shift; OPT_USER="${1}"; shift; ;;
+ -L) shift; OPT_LOPA="${1}"; shift; ;;
+ -p) shift; OPT_PASS="${1}"; shift; ;;
+ -P) shift; OPT_PORT="${1}"; shift; ;;
+ -S) shift; OPT_SOCK="${1}"; shift; ;;
+ -T) shift; OPT_TABLE="${1}"; shift; ;;
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_INTERVAL=${OPT_INTERVAL:-0}
+ OPT_TABLE="${OPT_TABLE:-percona.checksums}"
+ if [ -e '/etc/nagios/mysql.cnf' ]; then
+ OPT_DEFT="${OPT_DEFT:-/etc/nagios/mysql.cnf}"
+ fi
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ NOTE="UNK couldn't query the checksum table"
+
+ # Set up a temp file to hold error messages from MySQL.
+ TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+
+ # Get the query from the documentation and execute it.
+ SQL=$(get_magic_query "${0}" checksum_diff_query)
+ PROBLEMS=$(mysql_exec "${SQL/CHECKSUM_TABLE/${OPT_TABLE}}" 2>"${TEMP}")
+ if [ $? = 0 ]; then
+ if [ "${PROBLEMS}" ]; then
+ NOTE="pt-table-checksum found ${PROBLEMS}"
+ if [ "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ else
+ NOTE="WARN $NOTE"
+ fi
+ else
+ NOTE="OK pt-table-checksum found no out-of-sync tables"
+ if [ "${OPT_INTERVAL}" -gt 0 ]; then
+ RECENT_CHUNKS=$(mysql_exec "SELECT IF(COALESCE(MAX(ts), NOW()) > NOW() - INTERVAL ${OPT_INTERVAL} DAY, 1, 0) FROM ${OPT_TABLE}")
+ if [ "${RECENT_CHUNKS}" = 0 ]; then
+ NOTE="pt-table-checksum was not run over last ${OPT_INTERVAL} days"
+ if [ "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE"
+ else
+ NOTE="WARN $NOTE"
+ fi
+ fi
+ fi
+ fi
+ else
+ if grep "Table '${OPT_TABLE}' doesn't exist" "${TEMP}" >/dev/null 2>&1; then
+ NOTE="UNK table '${OPT_TABLE}' doesn't exist"
+ fi
+ fi
+ echo $NOTE
+}
+
+# ########################################################################
+# Execute a MySQL command.
+# ########################################################################
+mysql_exec() {
+ mysql ${OPT_DEFT:+--defaults-file="${OPT_DEFT}"} \
+ ${OPT_LOPA:+--login-path="${OPT_LOPA}"} \
+ ${OPT_HOST:+-h"${OPT_HOST}"} ${OPT_PORT:+-P"${OPT_PORT}"} \
+ ${OPT_USER:+-u"${OPT_USER}"} ${OPT_PASS:+-p"${OPT_PASS}"} \
+ ${OPT_SOCK:+-S"${OPT_SOCK}"} -ss -e "$1"
+}
+
+# ########################################################################
+# Retrieve a paragraph from the given file, which includes MAGIC_$2 as a
+# pattern.
+# ########################################################################
+get_magic_query() {
+ perl -00 -ne"m/MAGIC_$2/ && print" "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-pt-table-checksum" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-pt-table-checksum - Alert when pt-table-checksum finds data differences on a replica.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-pt-table-checksum [OPTIONS]
+ Options:
+ -c CRIT Raise a critical error instead of a warning.
+ --defaults-file FILE Only read mysql options from the given file.
+ Defaults to /etc/nagios/mysql.cnf if it exists.
+ -H HOST MySQL hostname.
+ -l USER MySQL username.
+ -L LOGIN-PATH Use login-path to access MySQL (with MySQL client 5.6).
+ -p PASS MySQL password.
+ -P PORT MySQL port.
+ -S SOCKET MySQL socket file.
+ -i INTERVAL Interval over which to ensure pt-table-checksum was run,
+ in days; default - not to check.
+ -T TABLE The checksum table; default percona.checksums
+ -w WARN Warning threshold; ignored.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin examines whether MySQL replication has drifted out of sync
+with the master's data, according to checks performed by the pt-table-checksum
+tool in Percona Toolkit. It uses the following query to determine whether the
+server's data matches its master's:
+
+ SELECT /* MAGIC_checksum_diff_query */
+ CONCAT(
+ COUNT(*),
+ ' chunks differ in ',
+ COUNT(DISTINCT CONCAT(db, tbl)),
+ ' tables, including ',
+ MIN(CONCAT(db, '.', tbl)))
+ FROM CHECKSUM_TABLE
+ WHERE master_cnt <> this_cnt OR master_crc <> this_crc
+ OR ISNULL(master_crc) <> ISNULL(this_crc)
+ HAVING COUNT(*) > 0
+
+The word CHECKSUM_TABLE is replaced by the value of the -T option. If the table
+specified by -T does not exist, unknown is raised.
+
+Optionally, you can specify an interval in days over which to ensure pt-table-checksum
+was run. It is useful in cases when the cron job doing the checksumming suddenly
+stopped working. This option will have an effect when no diffs are found and the
+checksum table is not empty.
+
+Alerts are raised at a WARNING level by default, but specifying the -c option
+with any value will change this to CRITICAL instead.
+
+=head1 PRIVILEGES
+
+This plugin executes the following commands against MySQL:
+
+=over
+
+=item *
+
+C<SELECT> against the specified table.
+
+=back
+
+This plugin executes no UNIX commands that may need special privileges.
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-pt-table-checksum $VERSION$
+
+=cut
+
+DOCUMENTATION
diff --git a/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-unix-memory b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-unix-memory
new file mode 100755
index 0000000..a9a3fdc
--- /dev/null
+++ b/nagios-plugins-contrib-24.20190301~bpo9+1/percona-nagios-plugins/nagios/bin/pmp-check-unix-memory
@@ -0,0 +1,207 @@
+#!/bin/sh
+
+# ########################################################################
+# This program is part of $PROJECT_NAME$
+# License: GPL License (see COPYING)
+# Authors:
+# Baron Schwartz, Roman Vynar
+# ########################################################################
+
+# ########################################################################
+# Redirect STDERR to STDOUT; Nagios doesn't handle STDERR.
+# ########################################################################
+exec 2>&1
+
+# ########################################################################
+# Set up constants, etc.
+# ########################################################################
+STATE_OK=0
+STATE_WARNING=1
+STATE_CRITICAL=2
+STATE_UNKNOWN=3
+STATE_DEPENDENT=4
+
+# ########################################################################
+# Run the program.
+# ########################################################################
+main() {
+
+ # Get options
+ for o; do
+ case "${o}" in
+ -w) shift; OPT_WARN="${1}"; shift; ;;
+ -d) shift; ;; # left for backward-compatibility
+ -c) shift; OPT_CRIT="${1}"; shift; ;;
+ --version) grep -A2 '^=head1 VERSION' "$0" | tail -n1; exit 0 ;;
+ --help) perl -00 -ne 'm/^ Usage:/ && print' "$0"; exit 0 ;;
+ -*) echo "Unknown option ${o}. Try --help."; exit 1; ;;
+ esac
+ done
+ OPT_WARN=${OPT_WARN:-90}
+ OPT_CRIT=${OPT_CRIT:-95}
+ if is_not_sourced; then
+ if [ -n "$1" ]; then
+ echo "WARN spurious command-line options: $@"
+ exit 1
+ fi
+ fi
+
+ NOTE="UNK cannot find memory statistics"
+ TEMP=$(mktemp -t "${0##*/}.XXXXXX") || exit $?
+ trap "rm -f '${TEMP}' >/dev/null 2>&1" EXIT
+ if [ -e /proc/meminfo ] && cat /proc/meminfo > "${TEMP}" ; then
+ USD_PCT=$(get_used_memory_linux "${TEMP}")
+ elif which sysctl > /dev/null && sysctl -a > "${TEMP}" ; then
+ USD_PCT=$(get_used_memory_bsd "${TEMP}")
+ else
+ echo $NOTE
+ exit
+ fi
+
+ NOTE="Memory ${USD_PCT}% used"
+ if [ "${USD_PCT:-0}" -ge "${OPT_CRIT}" ]; then
+ NOTE="CRIT $NOTE. $(get_largest_process)"
+ elif [ "${USD_PCT:-0}" -ge "${OPT_WARN}" ]; then
+ NOTE="WARN $NOTE. $(get_largest_process)"
+ else
+ NOTE="OK $NOTE"
+ fi
+
+ # Build the common perf data output for graph trending
+ PERFDATA="memory_used=${USD_PCT:-0};${OPT_WARN};${OPT_CRIT};0;100"
+ echo "$NOTE | $PERFDATA"
+}
+
+# ########################################################################
+# Find the largest process
+# ########################################################################
+get_largest_process () {
+ ALL_PROCS=$(ps axo pid,%mem,ucomm | sort -k2 -nr)
+ BIGGEST=$(echo $ALL_PROCS | head -n 1)
+ BIG_PID=$(echo $BIGGEST | cut -d' ' -f1)
+ BIG_MEM=$(echo $BIGGEST | cut -d' ' -f2)
+ BIG_COMMAND=$(echo $BIGGEST | cut -d' ' -f3)
+ echo "Largest process: ${BIG_COMMAND} (${BIG_PID}) = ${BIG_MEM}%"
+}
+
+# ########################################################################
+# Get the used memory from /proc/meminfo
+# Consider MemAvailable if available in the file (starting procps-ng 3.3.10).
+# See https://git.kernel.org/cgit/linux/kernel/git/torvalds/linux.git/commit/?id=34e431b0ae398fc54ea69ff85ec700722c9da773
+# ########################################################################
+get_used_memory_linux() {
+awk '/^MemTotal:/ {total = $2;}
+ /^MemFree:/ {free = $2;}
+ /^MemAvailable:/ {avail = $2;}
+ /^Buffers:/ {buffers = $2;}
+ /^Cached:/ {cached = $2;
+ if (avail == "") avail = free + buffers + cached;
+ printf "%d\n", (total - avail) / total * 100;}' "$1"
+}
+# ########################################################################
+# Get the used memory from sysctl for BSD systems
+# ########################################################################
+get_used_memory_bsd() {
+ awk '/vm.stats.vm.v_cache_count:/ {cache = $2}
+ /vm.stats.vm.v_inactive_count:/ {inactive = $2}
+ /vm.stats.vm.v_free_count:/ {free = $2}
+ /vm.stats.vm.v_page_count:/ {
+ total = $2;
+ used = total - inactive - cache - free;
+ printf "%d\n", used / total * 100}' "$1"
+}
+
+# ########################################################################
+# Determine whether this program is being executed directly, or sourced/included
+# from another file.
+# ########################################################################
+is_not_sourced() {
+ [ "${0##*/}" = "pmp-check-unix-memory" ] || [ "${0##*/}" = "bash" -a "$_" = "$0" ]
+}
+
+# ########################################################################
+# Execute the program if it was not included from another file.
+# This makes it possible to include without executing, and thus test.
+# ########################################################################
+if is_not_sourced; then
+ OUTPUT=$(main "$@")
+ EXITSTATUS=$STATE_UNKNOWN
+ case "${OUTPUT}" in
+ UNK*) EXITSTATUS=$STATE_UNKNOWN; ;;
+ OK*) EXITSTATUS=$STATE_OK; ;;
+ WARN*) EXITSTATUS=$STATE_WARNING; ;;
+ CRIT*) EXITSTATUS=$STATE_CRITICAL; ;;
+ esac
+ echo "${OUTPUT}"
+ exit $EXITSTATUS
+fi
+
+# ############################################################################
+# Documentation
+# ############################################################################
+: <<'DOCUMENTATION'
+=pod
+
+=head1 NAME
+
+pmp-check-unix-memory - Alert on low memory.
+
+=head1 SYNOPSIS
+
+ Usage: pmp-check-unix-memory [OPTIONS]
+ Options:
+ -c CRIT Critical threshold; default 95%.
+ -w WARN Warning threshold; default 90%.
+ --help Print help and exit.
+ --version Print version and exit.
+ Options must be given as --option value, not --option=value or -Ovalue.
+ Use perldoc to read embedded documentation with more details.
+
+=head1 DESCRIPTION
+
+This Nagios plugin examines C</proc/meminfo> (Linux) or the output of C<sysctl> (BSD)
+to check whether the system is running out of memory and finds the largest
+process in memory from C<ps> output.
+
+The plugin is tested on GNU/Linux and FreeBSD.
+
+=head1 PRIVILEGES
+
+This plugin does not access MySQL.
+
+This plugin executes the following UNIX commands that may need special privileges:
+
+=over
+
+=item *
+
+cat /proc/meminfo (Linux), sysctl (BSD)
+
+=item *
+
+ps
+
+=back
+
+=head1 COPYRIGHT, LICENSE, AND WARRANTY
+
+This program is copyright 2012-$CURRENT_YEAR$ Baron Schwartz, 2012-$CURRENT_YEAR$ Percona Inc.
+Feedback and improvements are welcome.
+
+THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
+WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+This program 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, version 2. You should have received a copy of the GNU General
+Public License along with this program; if not, write to the Free Software
+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+=head1 VERSION
+
+$PROJECT_NAME$ pmp-check-unix-memory $VERSION$
+
+=cut
+
+DOCUMENTATION
--
cgit v1.2.3