Debian Codegraph @

mysql-test/suite/rpl/r/rpl_encryption.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 CALL mtr.add_suppression('Failed to store key');
7 CALL mtr.add_suppression('Failed to initialize binlog encryption');
8 CALL mtr.add_suppression('Unable to recover binlog encryption master key');
9 CALL mtr.add_suppression('Aborting');
10 CALL mtr.add_suppression('Cannot get file password for encrypted replication log file');
11 CALL mtr.add_suppression('Could not parse relay log event entry');
12 CALL mtr.add_suppression('Failed to fetch key from keyring');
13 [connection slave]
14 [connection master]
15 # Part 1
16 SET @@GLOBAL.binlog_encryption = ON;
17 ERROR HY000: Unable to recover binlog encryption master key, please check if keyring is loaded.
18 include/assert.inc [binlog_encryption option shall be OFF]
19 include/assert.inc [Binary log was not rotated]
20 include/assert.inc [Binary log is not encrypted]
21 include/assert.inc [1st binary log is not encrypted on master]
22 include/rpl_stop_server.inc [server_number=1]
23 Starting the server with "--binlog_encryption=ON" but no keyring installed
24 include/assert_grep.inc [Server failed to initialize binlog encryption]
25 include/assert_grep.inc [Server aborted to start]
26 # Part 2
27 Starting the master with "--binlog_encryption=ON" and keyring installed
28 include/rpl_start_server.inc [server_number=1]
29 include/assert.inc [binlog_encryption option shall be ON]
30 include/assert.inc [2nd binary log is encrypted on master]
31 include/assert.inc [Binary log is encrypted using 1st master key]
32 include/assert.inc [Binary log rotated as expected at master startup]
33 SET PERSIST binlog_encryption = ON;
34 Restart the master with keyring installed
35 include/rpl_restart_server.inc [server_number=1]
36 include/assert.inc [binlog_encryption option shall be ON]
37 include/assert.inc [3rd binary log is encrypted on master]
38 include/assert.inc [Binary log is encrypted using 1st master key]
39 include/assert.inc [Binary log rotated as expected at master startup]
40 [connection slave]
41 include/assert.inc [1st binary log is not encrypted on slave]
42 include/assert.inc [Relay log is not encrypted for slave-relay-bin.000001]
43 Restart the slave with keyring installed
44 include/rpl_restart_server.inc [server_number=2]
45 include/assert.inc [binlog_encryption option shall be OFF]
46 include/assert.inc [2nd binary log is not encrypted on slave]
47 include/assert.inc [Relay log is not encrypted for slave-relay-bin.000002]
48 SET GLOBAL binlog_encryption = ON;
49 include/assert.inc [binlog_encryption option shall be ON]
50 include/assert.inc [3rd binary log is encrypted on slave]
51 include/assert.inc [Binary log rotated as expected at server startup]
52 include/assert.inc [New binary log is encrypted using 1st master key]
53 include/assert.inc [Relay log rotated as expected at server startup]
54 include/assert.inc [Relay log is encrypted for slave-relay-bin.000003]
55 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
56 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
57 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
58 include/assert.inc [The third relay log is re-encrypted using second master key]
59 include/assert.inc [The after relay log is encrypted using second master key]
60 # Part 3
61 [connection master]
62 CREATE TABLE t1 (c1 INT PRIMARY KEY);
63 INSERT INTO t1 (c1) VALUES (1), (2), (3);
64 INSERT INTO t1 (c1) VALUES (4), (5), (6);
65 [connection slave]
66 include/start_slave.inc
67 [connection master]
68 include/sync_slave_sql_with_master.inc
69 # Part 4
70 [connection slave]
71 UNINSTALL PLUGIN keyring_file;
72 [connection master]
73 include/sync_slave_sql_with_master.inc
74 FLUSH LOGS;
75 include/assert.inc [5th binary log is encrypted on slave]
76 include/assert.inc [Binary log rotated as expected by the FLUSH LOGS]
77 include/assert.inc [New binary log is still encrypted]
78 include/wait_for_slave_sql_error.inc [errno=13121]
79 include/stop_slave_io.inc
80 RESET SLAVE ALL;
81 Warnings:
82 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
83 include/assert.inc [New relay log is still encrypted]
84 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_MYPORT, SOURCE_USER='root';
85 Warnings:
86 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
87 Note 1760 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.
88 include/assert.inc [New relay log is still encrypted]
89 START SLAVE SQL_THREAD;
90 Warnings:
91 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
92 include/wait_for_slave_sql_error.inc [errno=13117]
93 SET GLOBAL binlog_encryption = OFF;
94 include/assert.inc [6th binary log is not encrypted on slave]
95 include/assert.inc [Binary log rotated as expected when disabling the option]
96 include/assert.inc [New binary log is not encrypted]
97 RESET SLAVE ALL;
98 Warnings:
99 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
100 include/assert.inc [New relay log is not encrypted]
101 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_MYPORT, SOURCE_USER='root';
102 Warnings:
103 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
104 Note 1760 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.
105 include/assert.inc [New relay log is not encrypted]
106 include/start_slave.inc
107 [connection master]
108 third_binary_log: master-bin.000003
109 include/assert.inc [the third binary log is encrypted using first master key]
110 # Part 5
111 # Adding debug point 'verify_unusable_encryption_keys_are_purged' to @@GLOBAL.debug
112 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
113 # Removing debug point 'verify_unusable_encryption_keys_are_purged' from @@GLOBAL.debug
114 include/assert.inc [the fourth binary log is encrypted on master]
115 include/assert.inc [the third binary log is re-encrypted using second master key]
116 include/assert.inc [the fourth binary log is encrypted using second master key]
117 SET PERSIST binlog_encryption = OFF;
118 include/assert.inc [5th binary log is not encrypted on master]
119 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
120 ERROR HY000: Cannot rotate binary log master key when 'binlog-encryption' is off.
121 RESET PERSIST binlog_encryption;
122 UNINSTALL PLUGIN keyring_file;
123 DROP TABLE t1;
124 include/sync_slave_sql_with_master.inc
125 include/stop_slave.inc
126 include/rpl_restart_server.inc [server_number=1]
127 include/rpl_restart_server.inc [server_number=2]
128 include/start_slave.inc
129 include/rpl_end.inc