1 #! /usr/bin/perl -w -I ..
2 #
3 # MySQL Database Server Tests via check_mysql
4 #
5 # $Id$
6 #
7 #
8 # These are the database permissions required for this test:
9 # GRANT SELECT ON $db.* TO $user@$host INDENTIFIED BY '$password';
10 # GRANT SUPER, REPLICATION CLIENT ON *.* TO $user@$host;
11 # Check with:
12 # mysql -u$user -p$password -h$host $db
14 use strict;
15 use Test::More;
16 use NPTest;
18 use vars qw($tests);
20 plan skip_all => "check_mysql not compiled" unless (-x "check_mysql");
22 plan tests => 15;
24 my $bad_login_output = '/Access denied for user /';
25 my $mysqlserver = getTestParameter(
26 "NP_MYSQL_SERVER",
27 "A MySQL Server hostname or IP with no slaves setup"
28 );
29 my $mysqlsocket = getTestParameter(
30 "NP_MYSQL_SOCKET",
31 "A MySQL Server socket with no slaves setup"
32 );
33 my $mysql_login_details = getTestParameter(
34 "MYSQL_LOGIN_DETAILS",
35 "Command line parameters to specify login access",
36 "-u user -ppw -d db",
37 );
38 my $with_slave = getTestParameter(
39 "NP_MYSQL_WITH_SLAVE",
40 "MySQL server with slaves setup"
41 );
42 my $with_slave_login = getTestParameter(
43 "NP_MYSQL_WITH_SLAVE_LOGIN",
44 "Login details for server with slave",
45 "-uroot -ppw"
46 );
48 my $result;
50 SKIP: {
51 skip "No mysql server defined", 5 unless $mysqlserver;
52 $result = NPTest->testCmd("./check_mysql -H $mysqlserver $mysql_login_details");
53 cmp_ok( $result->return_code, '==', 0, "Login okay");
55 $result = NPTest->testCmd("./check_mysql -H $mysqlserver -u dummy -pdummy");
56 cmp_ok( $result->return_code, '==', 2, "Login failure");
57 like( $result->output, $bad_login_output, "Expected login failure message");
59 $result = NPTest->testCmd("./check_mysql -S -H $mysqlserver $mysql_login_details");
60 cmp_ok( $result->return_code, "==", 1, "No slaves defined" );
61 like( $result->output, "/No slaves defined/", "Correct error message");
62 }
64 SKIP: {
65 skip "No mysql socket defined", 5 unless $mysqlsocket;
66 $result = NPTest->testCmd("./check_mysql -s $mysqlsocket $mysql_login_details");
67 cmp_ok( $result->return_code, '==', 0, "Login okay");
69 $result = NPTest->testCmd("./check_mysql -s $mysqlsocket -u dummy -pdummy");
70 cmp_ok( $result->return_code, '==', 2, "Login failure");
71 like( $result->output, $bad_login_output, "Expected login failure message");
73 $result = NPTest->testCmd("./check_mysql -S -s $mysqlsocket $mysql_login_details");
74 cmp_ok( $result->return_code, "==", 1, "No slaves defined" );
75 like( $result->output, "/No slaves defined/", "Correct error message");
76 }
78 SKIP: {
79 skip "No mysql server with slaves defined", 5 unless $with_slave;
80 $result = NPTest->testCmd("./check_mysql -H $with_slave $with_slave_login");
81 cmp_ok( $result->return_code, '==', 0, "Login okay");
83 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login");
84 cmp_ok( $result->return_code, "==", 0, "Slaves okay" );
86 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login -w 60");
87 cmp_ok( $result->return_code, '==', 0, 'Slaves are not > 60 seconds behind');
89 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login -w 60:");
90 cmp_ok( $result->return_code, '==', 1, 'Alert warning if < 60 seconds behind');
91 like( $result->output, "/^SLOW_SLAVE WARNING:/", "Output okay");
92 }