Debian Codegraph @

mysql-test/suite/rpl/t/password_expiration.test

raw
1 #
2 # Test a slave connection is properly handled when the replication
3 # user has an expired password
4 #
5
6 --source include/not_embedded.inc
7 --source include/have_binlog_format_mixed.inc
8 --source include/master-slave.inc
9
10 --connection slave
11 --source include/stop_slave.inc
12
13 --connection master
14 create user 'repl_user' password expire;
15 grant replication slave on *.* to repl_user;
16 flush privileges;
17 set global disconnect_on_expired_password=ON;
18
19 --connection slave
20 --let $master_user= query_get_value(SHOW SLAVE STATUS, Master_User, 1)
21 CHANGE MASTER TO MASTER_USER= 'repl_user';
22
23 START SLAVE;
24 # ER_MUST_CHANGE_PASSWORD_LOGIN
25 --let $slave_io_errno= 1862
26 --source include/wait_for_slave_io_error.inc
27
28 # restart slave
29 --source include/stop_slave_sql.inc
30 RESET SLAVE;
31
32 --connection master
33 # force sandbox mode for repl_user
34 set global disconnect_on_expired_password=OFF;
35
36 --connection slave
37 START SLAVE;
38 # ER_MUST_CHANGE_PASSWORD
39 --let $slave_io_errno= 1820
40 --source include/wait_for_slave_io_error.inc
41
42 --connection master
43 DROP USER 'repl_user';
44 set global disconnect_on_expired_password=default;
45
46 --connection slave
47 --source include/stop_slave_sql.inc
48 eval CHANGE MASTER TO MASTER_USER='$master_user';
49 RESET SLAVE;
50
51 --let $rpl_only_running_threads= 1
52 --source include/rpl_end.inc
53