Debian Codegraph @

mysql-test/suite/auth_sec/r/key_rotation_qa.result

raw
1 ALTER INSTANCE ROTATE MYISAM MASTER KEY;
2 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MYISAM MASTER KEY' at line 1
3 ALTER INSTANCE ROTATE INNODB;
4 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
5 ALTER INSTANCE STORE INNDB;
6 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STORE INNDB' at line 1
7 ALTER INSTANCE ROTATE INNODB SLAVE KEY;
8 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SLAVE KEY' at line 1
9 ALTER INSTANCE ROTATE INNODB MASTER KEY;
10 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
11
12 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
13 ERROR HY000: Function 'keyring_file' already exists
14
15 SHOW GLOBAL variables LIKE 'early-plugin-load';
16 Variable_name Value
17 SET @@global.early-plugin-load="keyring_file=keyring_file.so";
18 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-plugin-load="keyring_file=keyring_file.so"' at line 1
19
20 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
21 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
22 PLUGIN_NAME keyring_file
23 PLUGIN_VERSION 1.0
24 PLUGIN_STATUS ACTIVE
25
26 ALTER INSTANCE ROTATE INNODB MASTER KEY;
27 CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
28 INSERT INTO t1 VALUES(0, "aaaaa");
29 INSERT INTO t1 VALUES(1, "bbbbb");
30 INSERT INTO t1 VALUES(2, "ccccc");
31 SELECT * FROM t1;
32 c1 c2
33 0 aaaaa
34 1 bbbbb
35 2 ccccc
36 ALTER INSTANCE ROTATE INNODB MASTER KEY;
37 CREATE TABLE t2(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
38 INSERT INTO t2 SELECT * FROM t1;
39 SELECT COUNT(*) FROM t2;
40 COUNT(*)
41 3
42 # Remove keyring file
43
44 # Check for keyring file.
45 keyring_tmp
46
47 SELECT COUNT(*) FROM t2;
48 COUNT(*)
49 3
50 CREATE TABLE t3(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
51 INSERT INTO t3 VALUES(2, "ccccc");
52 # Check for keyring file.
53 keyring_tmp
54
55 ALTER INSTANCE ROTATE INNODB MASTER KEY;
56 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
57 # Check for keyring file.
58 keyring_tmp
59
60 SELECT * FROM t1;
61 c1 c2
62 0 aaaaa
63 1 bbbbb
64 2 ccccc
65 UNINSTALL PLUGIN keyring_file;
66 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
67 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
68 # Try to access encrypted table.
69 SELECT COUNT(*) FROM t1;
70 COUNT(*)
71 3
72 SELECT * FROM t2;
73 c1 c2
74 0 aaaaa
75 1 bbbbb
76 2 ccccc
77 CREATE TABLE t10(c1 INT, c2 char(20)) ENGINE = InnoDB;
78 # restart: --early-plugin-load=keyring_file=keyring_file.so --keyring_file_data=MYSQL_TMP_DIR/keyring/keyring
79 SELECT * FROM t1;
80 c1 c2
81 0 aaaaa
82 1 bbbbb
83 2 ccccc
84 SELECT * FROM t3;
85 c1 c2
86 2 ccccc
87 # restart: --early-plugin-load=keyring_file=keyring_file.so --keyring_file_data=MYSQL_TMP_DIR/keyring/keyring_new
88 SELECT * FROM t1;
89 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
90 CREATE TABLE t12(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
91 INSERT INTO t12 VALUES(2, "ccccchfc");
92 ALTER INSTANCE ROTATE INNODB MASTER KEY;
93 SELECT * FROM t12;
94 c1 c2
95 2 ccccchfc
96 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
97 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
98 PLUGIN_NAME keyring_file
99 PLUGIN_VERSION 1.0
100 PLUGIN_STATUS ACTIVE
101 SELECT * FROM t2;
102 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
103 CREATE TABLE t11(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
104 SELECT * FROM t2;
105 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
106 UNINSTALL PLUGIN keyring_file;
107 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
108 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
109 SELECT * FROM t11;
110 c1 c2
111 SELECT COUNT(*) FROM t1;
112 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
113 CREATE TABLE t4(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
114 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
115 ALTER INSTANCE ROTATE INNODB MASTER KEY;
116 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
117 CREATE TABLE t5(c1 INT, c2 char(20)) ENGINE = InnoDB;
118 INSERT INTO t5 VALUES(100, "without_enc");
119 keyring
120 DROP TABLE t11;
121 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
122 SET @@global.keyring_file_data='MYSQL_TMP_DIR/keyring/keyring';
123 SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
124 FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
125 PLUGIN_NAME keyring_file
126 PLUGIN_VERSION 1.0
127 PLUGIN_STATUS ACTIVE
128 CREATE TABLE t6(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
129 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
130 ALTER INSTANCE ROTATE INNODB MASTER KEY;
131 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
132 SELECT * FROM t3;
133 ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
134
135 SELECT * FROM t5;
136 c1 c2
137 100 without_enc
138 DROP TABLE t1,t2,t3,t5,t12,t10;
139 #End: