check_bdd_request

Project Notes

Usage: ./check_bdd_request.pl -H <host> -u <user> -p <password> -d <database> -P <port> -q request -t check_type -o <operator> [-w <warn_level> -c <crit_level> -T <timeout>] -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 <warn_level>,
WARNING if we are able to connect to the MySQL server and #request count result unrespect <warn_level>,
CRITICAL if we are able to connect to the MySQL server and #request count result unrespect <crit_level>,
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