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

Sebastian Harl <reply+i-4967066-72aebfdd9e23a0a0eba49f8589ceb7823eeca0b0-1651316-EymDizFzQUca5t4wFMVjgA@public.gmane.org>
Newsgroups gmane.network.nagios.plugins.devel
Message-ID <nagios-plugins/nagios-plugins/pull/[email protected]>
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

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________________
Nagios Plugin Development Mailing List Nagiosplug-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Unsubscribe at https://lists.sourceforge.net/lists/listinfo/nagiosplug-devel
::: Please include plugins version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.