⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
r
/
View File Name :
import_compress_encrypt_upgrade.result
# # Bug#31313533 : IMPORT FAILS FOR ENCRYPT AND COMPRESSION ENABLED TDE TABLES # upgrade section # # Test 4 : check table from old version are read correctly after upgrade # Stop the running the server # Copy and unzip the datadir. # Restart the server against the unzipped datadir # restart: --datadir=DATADIR --innodb-page-size=16k --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=DATADIR/keyring KEYRING_PLUGIN_OPT # Verify tables after upgrade USE test; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` varchar(65000) DEFAULT NULL, `c3` varchar(255) GENERATED ALWAYS AS (substr(`c2`,2,100)) STORED, `c4` varchar(255) GENERATED ALWAYS AS (substr(`c2`,10,200)) VIRTUAL, `b` bit(64) DEFAULT NULL, `p_c1` bigint(20) DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB AUTO_INCREMENT=56000 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y' SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50001 l��>�!u�w l��>�!u�w� w���[�s� 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� # Run some DML statements INSERT INTO t1(c2,b,p_c1) VALUES(AES_ENCRYPT("5dd0786a3c7adf503202b8e234a95cbe643bc752028e1792ca8e6ef86c69582eb1cc478670c8e5d6c0133d1b4e5c98017aeb893f9db5f1bff397bc9e0f5fde48","abc"),10,100); DELETE FROM t1 WHERE c1=50001; # Verify results SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10; c1 SUBSTRING(c2, 10, 10) SUBSTRING(c3, 10, 10) SUBSTRING(c4, 10, 10) b 50002 l��>�!u�w l��>�!u�w� w���[�s� 50003 l��>�!u�w l��>�!u�w� w���[�s� 50004 l��>�!u�w l��>�!u�w� w���[�s� 50005 l��>�!u�w l��>�!u�w� w���[�s� 50006 l��>�!u�w l��>�!u�w� w���[�s� 50007 l��>�!u�w l��>�!u�w� w���[�s� 50008 l��>�!u�w l��>�!u�w� w���[�s� 50009 l��>�!u�w l��>�!u�w� w���[�s� 50010 l��>�!u�w l��>�!u�w� w���[�s� 50011 l��>�!u�w l��>�!u�w� w���[�s� # Cleanup DROP TABLE t1; # restart # Remove copied files