Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating custom global manifest file for MySQL server
4 # Creating custom global configuration file for keyring component: component_keyring_file
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 #
8 # wl9508: Show that explicit and implicit undo tablespaces can be encrypted.
9 #
10 use test;
11 CREATE table tab1(c1 int);
12 # create bootstrap file
13 # Stop the MTR default DB server
14 # Taking backup of global manifest file for MySQL server
15 # Run the bootstrap command of datadir1
16 # Restore global manifest file for MySQL server from backup
17 SELECT @@datadir;
18 @@datadir
19 MYSQLD_DATADIR1/
20 SHOW VARIABLES LIKE 'keyring_file%';
21 Variable_name Value
22 SELECT @@innodb_undo_log_encrypt;
23 @@innodb_undo_log_encrypt
24 1
25 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
26 CREATE DATABASE nath;
27 use nath;
28 CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB ENCRYPTION='Y';
29 INSERT INTO tab2 VALUES(2, 'VISH');
30 CREATE INDEX ix2 ON tab2(c2) ;
31 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
32 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
33 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
34 DELETE FROM tab2;
35 DROP UNDO TABLESPACE undo_003;
36 DROP UNDO TABLESPACE undo_004;
37 DROP TABLE tab2;
38 DROP DATABASE nath;
39 # Stop the encrypt server
40 SELECT @@datadir;
41 @@datadir
42 MYSQLD_OLD_DATADIR
43 use test;
44 DROP TABLE tab1;
45 #
46 # bug#29006275 : ENCRYPTION MASTER KEY IS GENERATED WITH BLANK UUID
47 #
48 # Stop the non-encrypted server
49 # Run the bootstrap command of datadir1
50 # Show that a master key with a blank Server UUID is not used.
51 SELECT * FROM performance_schema.keyring_keys where KEY_ID='INNODBKey--1';
52 KEY_ID KEY_OWNER BACKEND_KEY_ID
53 # Stop the encrypted server
54 # ----------------------------------------------------------------------
55 # Teardown
56 # Removing local keyring file for keyring component: component_keyring_file
57 # Removing global configuration file for keyring component: component_keyring_file
58 # Removing global manifest file for MySQL server
59 # Restarting server without the manifest file
60 # ----------------------------------------------------------------------