Debian Codegraph @

mysql-test/suite/component_keyring_file/r/rpl_encryption_master_key_generation_recovery.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 include/master-slave.inc
4 Warnings:
5 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
6 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.
7 [connection master]
8 # Creating local configuration file for keyring component: component_keyring_file
9 # Creating manifest file for current MySQL server instance
10 [connection slave]
11 # Creating local configuration file for keyring component: component_keyring_file
12 # Creating manifest file for current MySQL server instance
13 [connection master]
14 # ----------------------------------------------------------------------
15 include/rpl_stop_server.inc [server_number=1]
16 # Force the server to fail storing new master key index
17 Try to restart the master enabling the option with debug instrumentation
18 include/assert_grep.inc [Server reported: Failed to store key]
19 include/assert_grep.inc [Server failed to initialize binlog encryption]
20 include/assert_grep.inc [Server aborted to start]
21 # Force the server to fail generating new master key
22 Try to restart the master enabling the option with debug instrumentation
23 include/assert_grep.inc [Server reported: Failed to generate key]
24 include/assert_grep.inc [Server failed to initialize binlog encryption]
25 include/assert_grep.inc [Server aborted to start]
26 # Force the server to fail storing master key index
27 Try to restart the master enabling the option 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 aborted to start]
31 Restart the master enabling the option
32 include/rpl_start_server.inc [server_number=1]
33 include/assert.inc [binlog_encryption option shall be ON]
34 include/assert.inc [Binary log rotated]
35 include/assert.inc [2th binary log is encrypted on master]
36 CREATE TABLE t1 (c1 INT PRIMARY KEY);
37 INSERT INTO t1 (c1) VALUES (1),(2),(3);
38 INSERT INTO t1 (c1) VALUES (4),(5),(6);
39 [connection slave]
40 include/assert.inc [1st binary log is not encrypted on slave]
41 Restart the slave with keyring installed
42 include/rpl_restart_server.inc [server_number=2]
43 include/assert.inc [binlog_encryption option shall be OFF]
44 include/assert.inc [2nd binary log is not encrypted on slave]
45 # Force the server to fail storing new master key index
46 SET GLOBAL binlog_encryption = ON;
47 ERROR HY000: Failed to store key, please check if keyring is loaded.
48 include/assert.inc [binlog_encryption option shall be OFF]
49 include/assert.inc [Binary log did not rotated]
50 # Force the server to fail generating new master key
51 SET GLOBAL binlog_encryption = ON;
52 ERROR HY000: Failed to generate key, please check if keyring is loaded.
53 include/assert.inc [binlog_encryption option shall be OFF]
54 include/assert.inc [Binary log did not rotated]
55 # Force the server to fail storing master key index
56 SET GLOBAL binlog_encryption = ON;
57 ERROR HY000: Failed to store key, please check if keyring is loaded.
58 include/assert.inc [binlog_encryption option shall be OFF]
59 include/assert.inc [Binary log did not rotated]
60 SET GLOBAL binlog_encryption = ON;
61 include/assert.inc [Binary log rotated]
62 include/assert.inc [5th binary log is encrypted on slave]
63 include/start_slave.inc
64 [connection master]
65 SET GLOBAL binlog_encryption = OFF;
66 DROP TABLE t1;
67 include/sync_slave_sql_with_master.inc
68 SET GLOBAL binlog_encryption = OFF;
69 [connection master]
70 # ----------------------------------------------------------------------
71 # Teardown
72 # Removing manifest file for current MySQL server instance
73 # Removing manifest file for current MySQL server instance
74 # Removing local keyring file for keyring component: component_keyring_file
75 # Removing local keyring file for keyring component: component_keyring_file
76 # Removing local configuration file for keyring component: component_keyring_file
77 # Removing local configuration file for keyring component: component_keyring_file
78 include/rpl_end.inc
79 # Restarting server without the manifest file
80 # ----------------------------------------------------------------------