Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # This test case will force failures in the binlog encryption master key
4 # generation using debug instrumentation.
5 #
6 # On the master, it will exercise the recovery process while setting the
7 # option as a startup parameter.
8 #
9 # On the slave, it will exercise the recovery process while setting the
10 # option in a client session.
11 #
12 # ==== Related Bugs and Worklogs ====
13 #
14 # WL#10957: Binary log encryption at rest
15 #
16
17 --source include/have_debug.inc
18 # This test case is binary log format agnostic
19 --source include/have_binlog_format_row.inc
20 --let $rpl_skip_start_slave= 1
21 --source include/master-slave.inc
22
23 #
24 # On master
25 #
26
27 --let $master_debug=`SELECT @@GLOBAL.debug`
28 --let $MASTER_DATADIR= `select @@datadir`
29 --let $master_error_log= $MYSQL_TMP_DIR/master.err
30 --let $keyring_master= $MYSQL_TMP_DIR/keyring_master
31
32 --let $rpl_server_number= 1
33 --source include/rpl_stop_server.inc
34 # Master is not able to run some queries from includes until restarted
35 --connection slave
36 --remove_file $master_error_log
37
38 --let $point=0
39 while ($point < 3)
40 {
41 --inc $point
42 --let $debug_point=rpl_encryption_first_time_enable_$point
43 --let $rpl_server_error= 0
44 if ($point == 1)
45 {
46 --echo # Force the server to fail storing new master key index
47 --let $rpl_server_error= 1
48 --let $error_message=Failed to store key
49 }
50 if ($point == 2)
51 {
52 --echo # Force the server to fail generating new master key
53 --let $rpl_server_error= 1
54 --let $error_message=Failed to generate key
55 }
56 if ($point == 3)
57 {
58 --echo # Force the server to fail storing master key index
59 --let $rpl_server_error= 1
60 --let $error_message=Failed to store key
61 }
62 --let $rpl_server_number= 1
63 --let $rpl_server_parameters= $KEYRING_PLUGIN_OPT $KEYRING_PLUGIN_LOAD --loose-keyring_file_data=$keyring_master --binlog_encryption=ON --debug=d,$debug_point --log-error=$MYSQL_TMP_DIR/master.err
64 --echo Try to restart the master enabling the option with debug instrumentation
65 --error 0,1
66 --exec $MYSQLD --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.$rpl_server_number $rpl_server_parameters
67 --let $assert_file= $master_error_log
68 --let $assert_text= Server reported: $error_message
69 --let $assert_select= $error_message
70 --let $assert_count= 1
71 --source include/assert_grep.inc
72 --let $assert_text= Server failed to initialize binlog encryption
73 --let $assert_select= Failed to initialize binlog encryption
74 --let $assert_count= 1
75 --source include/assert_grep.inc
76 --let $assert_text= Server aborted to start
77 --let $assert_select= Server.*Aborting
78 --let $assert_count= 1
79 --source include/assert_grep.inc
80 --remove_file $master_error_log
81 }
82
83 --echo Restart the master enabling the option
84 --let $rpl_server_number= 1
85 --let $rpl_server_parameters= $KEYRING_PLUGIN_OPT $KEYRING_PLUGIN_LOAD --keyring_file_data=$keyring_master --binlog_encryption=ON --log-error=$MYSQL_TMP_DIR/master.err
86 --let $rpl_server_error= 0
87 --let $rpl_omit_print_server_parameters= 1
88 --source include/rpl_start_server.inc
89 --connection master
90 --let $assert_text=binlog_encryption option shall be ON
91 --let $option_value = `SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = "binlog_encryption"`
92 --let $assert_cond= "$option_value" = "ON"
93 --source include/assert.inc
94 --let $binlog_file=query_get_value(SHOW MASTER STATUS, File, 1)
95 --let $assert_text=Binary log rotated
96 --let $assert_cond= RIGHT("$binlog_file", 6) = "000002"
97 --source include/assert.inc
98 --let $assert_text= 2th binary log is encrypted on master
99 --let $assert_cond= "[SHOW BINARY LOGS, Encrypted, 2]" = "Yes"
100 --source include/assert.inc
101 # Generate some traffic for replication
102 CREATE TABLE t1 (c1 INT PRIMARY KEY);
103 INSERT INTO t1 (c1) VALUES (1),(2),(3);
104 INSERT INTO t1 (c1) VALUES (4),(5),(6);
105
106 #
107 # On slave
108 #
109
110 # Restart the slave loading the keyring
111 --source include/rpl_connection_slave.inc
112 --let $SLAVE_DATADIR= `select @@datadir`
113 --let $keyring_slave= $MYSQL_TMP_DIR/keyring_slave
114 --let $assert_text= 1st binary log is not encrypted on slave
115 --let $assert_cond= "[SHOW BINARY LOGS, Encrypted, 1]" = "No"
116 --source include/assert.inc
117 --echo Restart the slave with keyring installed
118 --let $rpl_server_number= 2
119 --let $rpl_server_parameters= $KEYRING_PLUGIN_OPT $KEYRING_PLUGIN_LOAD --keyring_file_data=$keyring_slave --skip-replica-start
120 --let $rpl_server_error= 0
121 --let $rpl_omit_print_server_parameters= 1
122 --source include/rpl_restart_server.inc
123 --let $assert_text=binlog_encryption option shall be OFF
124 --let $option_value = `SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = "binlog_encryption"`
125 --let $assert_cond= "$option_value" = "OFF"
126 --source include/assert.inc
127 --let $assert_text= 2nd binary log is not encrypted on slave
128 --let $assert_cond= "[SHOW BINARY LOGS, Encrypted, 2]" = "No"
129 --source include/assert.inc
130
131 --let $point=0
132 while ($point < 3)
133 {
134 --inc $point
135 --let $debug_point=rpl_encryption_first_time_enable_$point
136 --let $debug_point_silent=1
137 --source include/add_debug_point.inc
138 --let $expected_error=0
139 if ($point == 1)
140 {
141 --echo # Force the server to fail storing new master key index
142 --let $expected_error=ER_RPL_ENCRYPTION_FAILED_TO_STORE_KEY
143 }
144 if ($point == 2)
145 {
146 --echo # Force the server to fail generating new master key
147 --let $expected_error=ER_RPL_ENCRYPTION_FAILED_TO_GENERATE_KEY
148 }
149 if ($point == 3)
150 {
151 --echo # Force the server to fail storing master key index
152 --let $expected_error=ER_RPL_ENCRYPTION_FAILED_TO_STORE_KEY
153 }
154 --error $expected_error
155 SET GLOBAL binlog_encryption = ON;
156 --source include/remove_debug_point.inc
157 --let $assert_text=binlog_encryption option shall be OFF
158 --let $option_value = `SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = "binlog_encryption"`
159 --let $assert_cond= "$option_value" = "OFF"
160 --source include/assert.inc
161 --let $binlog_file=query_get_value(SHOW MASTER STATUS, File, 1)
162 --let $assert_text=Binary log did not rotated
163 --let $assert_cond= RIGHT("$binlog_file", 6) = "000002"
164 --source include/assert.inc
165 }
166
167 # Without warnings
168 SET GLOBAL binlog_encryption = ON;
169 --let $assert_text=binlog_encryption option shall be ON
170 --let $option_value = `SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = "binlog_encryption"`
171 --let $assert_cond= "$option_value" = "ON"
172 --let $binlog_file=query_get_value(SHOW MASTER STATUS, File, 1)
173 --let $assert_text=Binary log rotated
174 --let $assert_cond= RIGHT("$binlog_file", 6) = "000003"
175 --source include/assert.inc
176 --let $assert_text= 5th binary log is encrypted on slave
177 --let $assert_cond= "[SHOW BINARY LOGS, Encrypted, 3]" = "Yes"
178 --source include/assert.inc
179
180 --echo ==== Cleanup ====
181
182 --echo * Disable encryption, cleanup database, and consume all encrypted logs.
183 --source include/rpl_connection_slave.inc
184 --source include/start_slave.inc
185 SET GLOBAL binlog_encryption = OFF;
186
187 --source include/rpl_connection_master.inc
188 SET GLOBAL binlog_encryption = OFF;
189 DROP TABLE t1;
190 --source include/sync_slave_sql_with_master.inc
191
192 --echo * Remove all encrypted logs.
193 --source include/rpl_reset.inc
194
195 --echo * Uninstall the plugins and delete the keyrings.
196 --source include/rpl_connection_master.inc
197 UNINSTALL PLUGIN keyring_file;
198 --remove_file $keyring_master
199 --source include/rpl_connection_slave.inc
200 UNINSTALL PLUGIN keyring_file;
201 --remove_file $keyring_slave
202
203 --echo * Restart the servers with the same command lines as before the test.
204 --let $rpl_server_number = 1
205 --let $rpl_server_parameters =
206 --let $rpl_omit_print_server_parameters = 1
207 --source include/rpl_restart_server.inc
208 --let $rpl_server_number= 2
209 --source include/rpl_restart_server.inc
210
211 --echo * Clean up replication test framework
212 --source include/rpl_connection_slave.inc
213 --source include/start_slave.inc
214 --source include/rpl_end.inc