[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