Debian Codegraph @

mysql-test/suite/rpl/r/rpl_encryption_master_key_rotation_at_startup.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 Restart the master enabling the rotate option only
7 include/rpl_restart_server.inc [server_number=1]
8 include/assert.inc [binlog_encryption option shall be OFF]
9 include/assert_grep.inc [Server ignored binlog_rotate_encryption_master_key_at_startup]
10 include/assert.inc [Binary log rotated]
11 include/assert.inc [2nd binary log is not encrypted on master]
12 include/rpl_stop_server.inc [server_number=1]
13 # Force the server to fail storing master key index
14 Try to restart the master enabling the options with debug instrumentation
15 include/assert_grep.inc [Server reported: Failed to store key]
16 include/assert_grep.inc [Server failed to initialize binlog encryption]
17 include/assert_grep.inc [Server did not failed to rotate binlog encryption master key at startup]
18 include/assert_grep.inc [Server aborted to start]
19 Restart the master enabling the options
20 include/rpl_start_server.inc [server_number=1]
21 include/assert.inc [binlog_encryption option shall be ON]
22 include/assert.inc [Binary log rotated]
23 include/assert.inc [3rd binary log is encrypted on master]
24 include/assert.inc [Binary log is encrypted with 2nd key]
25 include/rpl_stop_server.inc [server_number=1]
26 # Force the server to fail storing master key index
27 Try to restart the master enabling the options with debug instrumentation
28 include/assert_grep.inc [Server reported: Failed to store key]
29 include/assert_grep.inc [Server failed to initialize binlog encryption]
30 include/assert_grep.inc [Server did not failed to rotate binlog encryption master key at startup]
31 include/assert_grep.inc [Server aborted to start]
32 Restart the master enabling just the binlog_encryption option
33 include/rpl_start_server.inc [server_number=1]
34 include/assert.inc [binlog_encryption option shall be ON]
35 include/assert.inc [Binary log rotated]
36 include/assert.inc [4th binary log is encrypted on master]
37 include/assert.inc [Binary log is encrypted with 3th key]
38 CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT, c2 TEXT);
39 INSERT INTO t1 (c2) VALUES ("MySQL");
40 Restart the master enabling the options to generate key #4
41 include/rpl_restart_server.inc [server_number=1]
42 include/assert.inc [binlog_encryption option shall be ON]
43 include/assert.inc [Binary log rotated as expected]
44 include/assert.inc [Binary log is encrypted with key #4]
45 INSERT INTO t1 (c2) VALUES ("MySQL");
46 Restart the master enabling the options to generate key #5
47 include/rpl_restart_server.inc [server_number=1]
48 include/assert.inc [binlog_encryption option shall be ON]
49 include/assert.inc [Binary log rotated as expected]
50 include/assert.inc [Binary log is encrypted with key #5]
51 INSERT INTO t1 (c2) VALUES ("MySQL");
52 Restart the master enabling the options to generate key #6
53 include/rpl_restart_server.inc [server_number=1]
54 include/assert.inc [binlog_encryption option shall be ON]
55 include/assert.inc [Binary log rotated as expected]
56 include/assert.inc [Binary log is encrypted with key #6]
57 INSERT INTO t1 (c2) VALUES ("MySQL");
58 Restart the master enabling the options to generate key #7
59 include/rpl_restart_server.inc [server_number=1]
60 include/assert.inc [binlog_encryption option shall be ON]
61 include/assert.inc [Binary log rotated as expected]
62 include/assert.inc [Binary log is encrypted with key #7]
63 INSERT INTO t1 (c2) VALUES ("MySQL");
64 Restart the master enabling the options to generate key #8
65 include/rpl_restart_server.inc [server_number=1]
66 include/assert.inc [binlog_encryption option shall be ON]
67 include/assert.inc [Binary log rotated as expected]
68 include/assert.inc [Binary log is encrypted with key #8]
69 INSERT INTO t1 (c2) VALUES ("MySQL");
70 Restart the master enabling the options to generate key #9
71 include/rpl_restart_server.inc [server_number=1]
72 include/assert.inc [binlog_encryption option shall be ON]
73 include/assert.inc [Binary log rotated as expected]
74 include/assert.inc [Binary log is encrypted with key #9]
75 INSERT INTO t1 (c2) VALUES ("MySQL");
76 ==== Cleanup ====
77 * Disable encryption, cleanup database, and consume all encrypted logs.
78 [connection slave]
79 include/start_slave.inc
80 SET GLOBAL binlog_encryption = OFF;
81 [connection master]
82 SET GLOBAL binlog_encryption = OFF;
83 DROP TABLE t1;
84 include/sync_slave_sql_with_master.inc
85 * Remove all encrypted logs.
86 include/rpl_reset.inc
87 * Uninstall the plugin and delete the keyring.
88 [connection master]
89 UNINSTALL PLUGIN keyring_file;
90 * Restart the servers with the same command lines as before the test.
91 include/rpl_restart_server.inc [server_number=1]
92 include/rpl_restart_server.inc [server_number=2]
93 * Clean up replication test framework
94 [connection slave]
95 include/start_slave.inc
96 include/rpl_end.inc