852926a72f8b723ecf968ad388331d410771084d
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 => 10;
24 my $bad_login_output = '/Access denied for user /';
25 my $mysqlserver = getTestParameter(
26 "NP_MYSQL_SERVER",
27 "A MySQL Server with no slaves setup"
28 );
29 my $mysql_login_details = getTestParameter(
30 "MYSQL_LOGIN_DETAILS",
31 "Command line parameters to specify login access",
32 "-u user -ppw -d db",
33 );
34 my $with_slave = getTestParameter(
35 "NP_MYSQL_WITH_SLAVE",
36 "MySQL server with slaves setup"
37 );
38 my $with_slave_login = getTestParameter(
39 "NP_MYSQL_WITH_SLAVE_LOGIN",
40 "Login details for server with slave",
41 "-uroot -ppw"
42 );
44 my $result;
46 SKIP: {
47 skip "No mysql server defined", 5 unless $mysqlserver;
48 $result = NPTest->testCmd("./check_mysql -H $mysqlserver $mysql_login_details");
49 cmp_ok( $result->return_code, '==', 0, "Login okay");
51 $result = NPTest->testCmd("./check_mysql -H $mysqlserver -u dummy -pdummy");
52 cmp_ok( $result->return_code, '==', 2, "Login failure");
53 like( $result->output, $bad_login_output, "Expected login failure message");
55 $result = NPTest->testCmd("./check_mysql -S -H $mysqlserver $mysql_login_details");
56 cmp_ok( $result->return_code, "==", 1, "No slaves defined" );
57 like( $result->output, "/No slaves defined/", "Correct error message");
58 }
60 SKIP: {
61 skip "No mysql server with slaves defined", 5 unless $with_slave;
62 $result = NPTest->testCmd("./check_mysql -H $with_slave $with_slave_login");
63 cmp_ok( $result->return_code, '==', 0, "Login okay");
65 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login");
66 cmp_ok( $result->return_code, "==", 0, "Slaves okay" );
68 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login -w 60");
69 cmp_ok( $result->return_code, '==', 0, 'Slaves are not > 60 seconds behind');
71 $result = NPTest->testCmd("./check_mysql -S -H $with_slave $with_slave_login -w 60:");
72 cmp_ok( $result->return_code, '==', 1, 'Alert warning if < 60 seconds behind');
73 like( $result->output, "/^SLOW_SLAVE WARNING:/", "Output okay");
74 }