Debian Codegraph @

mysql-test/suite/group_replication/t/gr_recovery_donor_public_key.test

raw
1 ################################################################################
2 # Validate the correct behaviour of
3 # group_replication_recovery_get_public_key and
4 # group_replication_recovery_public_key_path options on Group Replication.
5 #
6 # Test:
7 # 0. The test requires two servers: M1 and M2.
8 # 1. Bootstrap group on server1.
9 # 2. Prepare server2 configuration to force public key
10 # authentication.
11 # 3. Disable fetch donor public key and do not set donor
12 # public key, recovery must fail and the member status must
13 # change to ERROR.
14 # 4. Disable fetch donor public key and do set a donor invalid
15 # public key, recovery must fail and the member status must
16 # change to ERROR.
17 # 5. Disable fetch donor public key and do set a donor valid
18 # public key, recovery must succeed and the member status
19 # must change to ONLINE.
20 # 6. Clean up.
21 ################################################################################
22
23 --source include/have_group_replication_xcom_communication_stack.inc
24 --source include/big_test.inc
25 --source include/set_privilege_checks_user_as_system_user.inc
26 --let $rpl_privilege_checks_user_grant_option = 1
27 --source include/have_group_replication_plugin.inc
28 --let $rpl_skip_group_replication_start= 1
29 --source include/group_replication.inc
30
31 --echo
32 --echo ############################################################
33 --echo # 1. Bootstrap group on server1.
34 --let $rpl_connection_name= server1
35 --source include/rpl_connection.inc
36
37 CREATE USER 'u1_caching_sha2_password'@'127.0.0.1' IDENTIFIED WITH 'caching_sha2_password' BY 'pwd';
38 GRANT REPLICATION SLAVE ON *.* TO 'u1_caching_sha2_password'@'127.0.0.1';
39 FLUSH PRIVILEGES;
40
41 --source include/start_and_bootstrap_group_replication.inc
42
43
44 --echo
45 --echo ############################################################
46 --echo # 2. Prepare server2 configuration to force public key
47 --echo # authentication.
48 --let $rpl_connection_name= server2
49 --source include/rpl_connection.inc
50 SET @group_replication_recovery_get_public_key= @@GLOBAL.group_replication_recovery_get_public_key;
51 SET @group_replication_recovery_public_key_path= @@GLOBAL.group_replication_recovery_public_key_path;
52
53 # We need to disable encrypted connection to force
54 # public key authentication.
55 SET @group_replication_recovery_use_ssl= @@GLOBAL.group_replication_recovery_use_ssl;
56 SET GLOBAL group_replication_recovery_use_ssl= FALSE;
57
58 # Reduce the retry count to try only once.
59 SET @group_replication_recovery_retry_count= @@GLOBAL.group_replication_recovery_retry_count;
60 SET GLOBAL group_replication_recovery_retry_count= 1;
61
62 CHANGE REPLICATION SOURCE TO SOURCE_USER='u1_caching_sha2_password', SOURCE_PASSWORD='pwd' FOR CHANNEL 'group_replication_recovery';
63
64 SET SESSION sql_log_bin= 0;
65 call mtr.add_suppression("There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials.*");
66 call mtr.add_suppression("For details please check performance_schema.replication_connection_status table*");
67 call mtr.add_suppression("Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.");
68 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
69 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
70 call mtr.add_suppression("Can't locate server public key '.*mysql-test/std_data/invalid_rsa_public_key.pem'");
71 call mtr.add_suppression("Public key is not in Privacy Enhanced Mail format: '.*mysql-test/std_data/invalid_rsa_public_key.pem'");
72 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
73 SET SESSION sql_log_bin= 1;
74
75
76 --echo
77 --echo ############################################################
78 --echo # 3. Disable fetch donor public key and do not set donor
79 --echo # public key, recovery must fail and the member status must
80 --echo # change to ERROR.
81 --let $rpl_connection_name= server2
82 --source include/rpl_connection.inc
83 SET GLOBAL group_replication_recovery_get_public_key= FALSE;
84 SET GLOBAL group_replication_recovery_public_key_path= "";
85
86 --let $group_replication_start_member_state= ERROR
87 --source include/start_group_replication.inc
88
89 --source include/stop_group_replication.inc
90
91
92 --echo
93 --echo ############################################################
94 --echo # 4. Disable fetch donor public key and do set a donor invalid
95 --echo # public key, recovery must fail and the member status must
96 --echo # change to ERROR.
97 --let $rpl_connection_name= server2
98 --source include/rpl_connection.inc
99 SET GLOBAL group_replication_recovery_get_public_key= FALSE;
100 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
101 --eval SET GLOBAL group_replication_recovery_public_key_path= "$MYSQL_TEST_DIR/std_data/invalid_rsa_public_key.pem"
102
103 --let $group_replication_start_member_state= ERROR
104 --source include/start_group_replication.inc
105
106 --source include/stop_group_replication.inc
107
108
109 --echo
110 --echo ############################################################
111 --echo # 5. Disable fetch donor public key and do set a donor valid
112 --echo # public key, recovery must succeed and the member status
113 --echo # must change to ONLINE.
114 --let $rpl_connection_name= server2
115 --source include/rpl_connection.inc
116 SET GLOBAL group_replication_recovery_get_public_key= FALSE;
117 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
118 --eval SET GLOBAL group_replication_recovery_public_key_path= "$MYSQL_TEST_DIR/std_data/rsa_public_key.pem"
119
120 --let $group_replication_start_member_state= ONLINE
121 --source include/start_group_replication.inc
122
123
124 --echo
125 --echo ############################################################
126 --echo # 6. Clean up.
127 --let $rpl_connection_name= server1
128 --source include/rpl_connection.inc
129 DROP USER 'u1_caching_sha2_password'@'127.0.0.1';
130
131 --let $rpl_connection_name= server2
132 --source include/rpl_connection.inc
133 SET GLOBAL group_replication_recovery_use_ssl= @group_replication_recovery_use_ssl;
134 SET GLOBAL group_replication_recovery_retry_count= @group_replication_recovery_retry_count;
135
136 SET GLOBAL group_replication_recovery_get_public_key= @group_replication_recovery_get_public_key;
137 SET GLOBAL group_replication_recovery_public_key_path= @group_replication_recovery_public_key_path;
138
139 --source include/group_replication_end.inc