Databases

check_bdd_request

Write a Review

Description:

Check if the result of a MySQL request is ==, , than a number which is warning and/or critical when check_type=NUMERIC.
This plugin could return a result of a SQL request for information only with check_type=TEXT.
It works with MySQL only for now, but it’s very simple to use another database.
This plugin requires that perl, perl-DBD-MySQL, perl-DBI package are installed on the system.
If you have specifics needs, this plugin browse the result of your query and you can make the treatment you want ! You just have to known base in PERL.
You really can do what you want, you just add a new function !

Current Version

1.0

Last Release Date

2013-03-01

Compatible With

  • Nagios 3.x

Owner

Alexandre Frandemiche

Website

http://sourceforge.net/projects/nagioschkbddreq

Download URL

http://sourceforge.net/projects/nagioschkbddreq/files/check_bdd_request.pl/download

License

GPL

Copy Page Link Recommend Contact Owner Login to Add to Favorites Login to Claim
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Download Now

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
Project Files
FileDescription
check_bdd_request.pl

nagios plugin

Project Notes
Usage: ./check_bdd_request.pl -H -u -p -d -P -q request -t check_type -o [-w -c -T ] -V -h, --help print this help message -H, --hostname=HOST name or IP address of MySQL server -u, --user=USER mysql user to login -p, --password=PASSWORD mysql password -d, --database=DATABASE mysql database name -P, --port=PORT Http port -q, --request="REQUEST" Request to execute on the server -t, --check_type=TYPE Type of return : NUMERIC, TEXT -o, --operator=OPERATOR Operator : EQ for =, LT for <, GT for >, LE for <=, GE for >=, DIF for != -w, --warn=INTEGER number that will cause a warning completed by the OPERATOR -1 for no warning -c, --critical=INTEGER number that will cause an error completed by the OPERATOR -T, --timeout=INTEGER timeout in seconds (Default: 15) -V, --version prints version number Note : The script will return * With warn and critical options: OK if we are able to connect to the MySQL server and #request count result respect , WARNING if we are able to connect to the MySQL server and #request count result unrespect , CRITICAL if we are able to connect to the MySQL server and #request count result unrespect , UNKNOWN if we aren't able to connect to the MySQL server Commands.cfg : # 'check_bdd_request_numeric' command definition define command{ command_name check_bdd_request_numeric command_line $USER1$/check_bdd_request.pl -H $HOSTADDRESS$ -u $ARG1$ -p $ARG2$ -d $ARG3$ -P $ARG4$ -q $ARG5$ -t $ARG6$ -o $ARG7$ -w $ARG8$ -c $ARG9$ } # 'check_bdd_request_text' command definition define command{ command_name check_bdd_request_text command_line $USER1$/check_bdd_request.pl -H $HOSTADDRESS$ -u $ARG1$ -p $ARG2$ -d $ARG3$ -P $ARG4$ -q $ARG5$ -t $ARG6$ } Services.cfg : define service{ use generic-service host_name my_bdd_server service_description A text value for display information like a version for example check_command check_bdd_request_text!user!password!database!port!"Select column_name from my table where row_text='value'"!TEXT normal_check_interval 60 } define service{ use generic-service host_name my_bdd_server service_description A numeric value for display information and compare with operator to the Warning or Critical values check_command check_bdd_request_text!user!password!database!port!"Select column_name from my table where row_text='value'"!NUMERIC!LT!2!5 normal_check_interval 60 } For more informations : http://www.slobberbone.net/dotclear/index.php?pages/check_bdd_request
Reviews (0) Add a Review
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
0 (0)
Favorites
0
Views
44,402