Gecko [ www.jdcpatala.org ]

Name	Size	Permission
access_credential_control.resu...	23.21 KB	-rw-r--r--
cert_verify.result	304 B	-rw-r--r--
early_plugin_load.result	789 B	-rw-r--r--
have_mysql_upgrade.result	21 B	-rw-r--r--
have_ssl.require	33 B	-rw-r--r--
install_keyring.result	263 B	-rw-r--r--
install_keyring_file.result	979 B	-rw-r--r--
key_rotation.result	427 B	-rw-r--r--
key_rotation_qa.result	7.57 KB	-rw-r--r--
key_value_auth.result	13 KB	-rw-r--r--
keyring_file.result	479 B	-rw-r--r--
keyring_file_data.result	1.17 KB	-rw-r--r--
keyring_file_data_qa.result	2.66 KB	-rw-r--r--
keyring_udf.result	29.95 KB	-rw-r--r--
multiple_plugins.result	5.46 KB	-rw-r--r--
mysql_native_plugin.result	10.46 KB	-rw-r--r--
mysql_no_login.result	2.03 KB	-rw-r--r--
mysql_protocol_types.result	2.38 KB	-rw-r--r--
mysql_protocol_types_windows.r...	1.93 KB	-rw-r--r--
mysql_sha256_plugin.result	9.84 KB	-rw-r--r--
mysql_ssl_connection.result	202 B	-rw-r--r--
mysql_ssl_rsa_setup.result	1.4 KB	-rw-r--r--
named_pipe_ssl.result	255 B	-rw-r--r--
not_embedded.require	16 B	-rw-r--r--
not_openssl.require	36 B	-rw-r--r--
not_ssl.require	32 B	-rw-r--r--
openssl.require	37 B	-rw-r--r--
openssl_cert_generation.result	7.37 KB	-rw-r--r--
openssl_cert_generation_debug....	577 B	-rw-r--r--
openssl_cert_generation_subjec...	435 B	-rw-r--r--
openssl_cert_validity.result	109 B	-rw-r--r--
openssl_skip_cert_generation.r...	442 B	-rw-r--r--
password_expired.result	16.4 KB	-rw-r--r--
password_expiry.result	8.09 KB	-rw-r--r--
require_secure_transport.resul...	1.49 KB	-rw-r--r--
require_secure_transport_windo...	2.08 KB	-rw-r--r--
secure_file_priv_error.result	358 B	-rw-r--r--
secure_file_priv_null.result	1.08 KB	-rw-r--r--
secure_file_priv_warnings.resu...	876 B	-rw-r--r--
secure_file_priv_warnings_not_...	582 B	-rw-r--r--
secure_file_priv_warnings_win....	454 B	-rw-r--r--
server_withssl_client_withouts...	6.18 KB	-rw-r--r--
server_withssl_client_withssl....	6.08 KB	-rw-r--r--
set_password_deprecated.result	4.76 KB	-rw-r--r--
ssl_auto_detect.result	1.82 KB	-rw-r--r--
ssl_auto_detect_openssl.result	361 B	-rw-r--r--
ssl_mode.result	5.16 KB	-rw-r--r--
tls.result	1.25 KB	-rw-r--r--
tls12_tls1.result	510 B	-rw-r--r--
wrong_keyring_file.result	166 B	-rw-r--r--
wrong_keyring_file_data.result	731 B	-rw-r--r--

Code Editor : key_rotation_qa.result

call mtr.add_suppression("\\[Error\\] InnoDB: Encryption can't find master key, please check the keyring plugin is loaded.");
call mtr.add_suppression("\\[Error\\] Plugin keyring_file reported: 'keyring_file initialization failure.");
call mtr.add_suppression("\\[Error\\] Function 'keyring_file' already exists");
call mtr.add_suppression("\\[Error\\] Couldn't load plugin named 'keyring_file' with soname 'keyring_file.so'.");
call mtr.add_suppression("\\[ERROR\\] Couldn't load plugin named 'keyring_file' with soname 'keyring_file.dll'.");
call mtr.add_suppression("\\[Error\\] InnoDB: Can't generate new master key, please check the keyring plugin is loaded.");
call mtr.add_suppression("\\[Error\\] InnoDB: Encryption information in datafile");
call mtr.add_suppression("\\[Error\\] InnoDB: Operating system error number 2 in a file operation.");
call mtr.add_suppression("\\[Error\\] InnoDB: The error means the system cannot find the path specified.");
call mtr.add_suppression("\\[Error\\] InnoDB: Could not find a valid tablespace file for");
call mtr.add_suppression("\\[Error\\] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
call mtr.add_suppression("\\[Error\\] InnoDB: Can't generate new master key for tablespace encryption, please check the keyring plugin is loaded.");
call mtr.add_suppression("\\[Warning\\] InnoDB: Ignoring tablespace `test/.*` because it could not be opened.");
call mtr.add_suppression("\\[Error\\] InnoDB: Failed to find tablespace for table");
call mtr.add_suppression("\\[Warning\\] InnoDB: Can't read encryption key from file");
call mtr.add_suppression("\\[Warning\\] InnoDB: Cannot open table .* from the internal data dictionary of InnoDB though the .frm file for the table exists.*");
call mtr.add_suppression("Could not flush keys to keyring's backup");
ALTER INSTANCE ROTATE MYISAM MASTER KEY;
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
ALTER INSTANCE ROTATE INNODB;
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
ALTER INSTANCE STORE INNDB;
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
ALTER INSTANCE ROTATE INNODB SLAVE KEY;
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
ALTER INSTANCE ROTATE INNODB MASTER KEY;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.

INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
ERROR HY000: Function 'keyring_file' already exists

SHOW GLOBAL variables LIKE 'early-plugin-load';
Variable_name	Value
SET @@global.early-plugin-load="keyring_file=keyring_file.so";
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

SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
PLUGIN_NAME	keyring_file
PLUGIN_VERSION	1.0
PLUGIN_STATUS	ACTIVE

ALTER INSTANCE ROTATE INNODB MASTER KEY;
CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
INSERT INTO t1 VALUES(0, "aaaaa");
INSERT INTO t1 VALUES(1, "bbbbb");
INSERT INTO t1 VALUES(2, "ccccc");
SELECT * FROM t1;
c1	c2
0	aaaaa
1	bbbbb
2	ccccc
ALTER INSTANCE ROTATE INNODB MASTER KEY;
CREATE TABLE t2(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
INSERT INTO t2 SELECT * FROM t1;
SELECT COUNT(*) FROM t2;
COUNT(*)
3
# Remove keyring file.

# Check for keyring file.
keyring_tmp

SELECT COUNT(*) FROM t2;
COUNT(*)
3
CREATE TABLE t3(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
INSERT INTO t3 VALUES(2, "ccccc");
# Check for keyring file.
keyring_tmp

ALTER INSTANCE ROTATE INNODB MASTER KEY;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
# Check for keyring file.
keyring_tmp

SELECT * FROM t1;
c1	c2
0	aaaaa
1	bbbbb
2	ccccc
UNINSTALL PLUGIN keyring_file;
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
# Try to access encrypted table.
SELECT COUNT(*) FROM t1;
COUNT(*)
3
SELECT * FROM t2;
c1	c2
0	aaaaa
1	bbbbb
2	ccccc
CREATE TABLE t10(c1 INT, c2 char(20)) ENGINE = InnoDB;
# restart: --early-plugin-load=keyring_file=keyring_file.so --keyring_file_data=MYSQL_TMP_DIR/keyring/keyring
SELECT * FROM t1;
c1	c2
0	aaaaa
1	bbbbb
2	ccccc
SELECT * FROM t3;
c1	c2
2	ccccc
# restart: --early-plugin-load=keyring_file=keyring_file.so --keyring_file_data=MYSQL_TMP_DIR/keyring/keyring_new
SELECT * FROM t1;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
CREATE TABLE t12(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
INSERT INTO t12 VALUES(2, "ccccchfc");
ALTER INSTANCE ROTATE INNODB MASTER KEY;
SELECT * FROM t12;
c1	c2
2	ccccchfc
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
PLUGIN_NAME	keyring_file
PLUGIN_VERSION	1.0
PLUGIN_STATUS	ACTIVE
SELECT * FROM t2;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
CREATE TABLE t11(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
SELECT * FROM t2;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
UNINSTALL PLUGIN keyring_file;
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
SELECT * FROM t11;
c1	c2
SELECT COUNT(*) FROM t1;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
CREATE TABLE t4(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
ALTER INSTANCE ROTATE INNODB MASTER KEY;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
CREATE TABLE t5(c1 INT, c2 char(20)) ENGINE = InnoDB;
INSERT INTO t5 VALUES(100, "without_enc");
keyring
DROP TABLE t11;
INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
SET @@global.keyring_file_data='MYSQL_TMP_DIR/keyring/keyring';
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file';
PLUGIN_NAME	keyring_file
PLUGIN_VERSION	1.0
PLUGIN_STATUS	ACTIVE
CREATE TABLE t6(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
ALTER INSTANCE ROTATE INNODB MASTER KEY;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.
SELECT * FROM t3;
ERROR HY000: Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully.

SELECT * FROM t5;
c1	c2
100	without_enc
DROP TABLE t1,t2,t3,t5,t12,t10;
#End:

${this.title}

Code Editor : key_rotation_qa.result