[Nagiosplug-devel] [nagios-plugins] check_dbi: New plugin to query SQL databases using libdbi (#8)

[Sebastian Harl]

The plugin features checking the connection time, query execution
time and checking query results against specified thresholds or a
regular expression.

This plugin connects to an (SQL) database using libdbi and, optionally,
executes the specified query. The first column of the first row of the
result will be parsed and, in QUERY_RESULT mode, compared with the
warning and critical ranges. The result from the query has to be numeric
(strings representing numbers are fine).


You can merge this Pull Request by running:

  git pull https://github.com/tokkee/nagios-plugins sh/check_dbi

Or you can view, comment on it, or merge it online at:

  https://github.com/nagios-plugins/nagios-plugins/pull/8

-- Commit Summary --

* Initial version of the 'check_dbi' plugin.
* check_dbi: Include extra opts in help output.
* check_dbi: Added threshold ranges for the connection time.
* check_dbi: Check and report the time used by the query.
* check_dbi: Fixed/improved perfdata output.
* check_dbi: Replaced -W/-C with -m.
* check_dbi: Added QUERY_TIME metric.
* check_dbi: Added some examples to the help output.
* check_dbi: Added -e option.
* check_dbi: Added -r and -R options.
* check_dbi: Added SERVER_VERSION metric.
* check_dbi: Added simple regex example to help output.
* check_dbi: Hint the user about cause when dbi init fails.
* Added a few test cases for the check_dbi plugin.

-- File Changes --

M .gitignore (1)
M REQUIREMENTS (4)
M configure.in (13)
M plugins/Makefile.am (4)
A plugins/check_dbi.c (817)
A plugins/t/check_dbi.t (102)

-- Patch Links --

  https://github.com/nagios-plugins/nagios-plugins/pull/8.patch
  https://github.com/nagios-plugins/nagios-plugins/pull/8.diff

---
Reply to this email directly or view it on GitHub:
https://github.com/nagios-plugins/nagios-plugins/pull/8