| 1 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Function 'keyring_file' already exists"); |
| 2 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Couldn't load plugin named 'keyring_file' with soname 'keyring_file.so'."); |
| 3 |
call mtr.add_suppression("keyring_file_data cannot be set to new value as the keyring file cannot be created/accessed in the provided path"); |
| 4 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'keyring_file initialization failure."); |
| 5 |
call mtr.add_suppression("Plugin keyring_file reported: 'Could not create keyring directory The keyring_file will stay unusable until correct path to the keyring directory gets provided"); |
| 6 |
call mtr.add_suppression("Error while loading keyring content. The keyring might be malformed"); |
| 7 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'File .*keyring' not found .*"); |
| 8 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'File .*keyring/' not found .*"); |
| 9 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'File 'MYSQL_test_invalid/dir/' not found .*"); |
| 10 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'File '/' not found .*"); |
| 11 |
call mtr.add_suppression("\\[ERROR\\] \\[[^]]*\\] \\[[^]]*\\] Plugin keyring_file reported: 'Incorrect Keyring file"); |
| 12 |
INSTALL PLUGIN keyring_file SONAME 'keyring_file.so'; |
| 13 |
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS |
| 14 |
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; |
| 15 |
PLUGIN_NAME keyring_file |
| 16 |
PLUGIN_VERSION 1.0 |
| 17 |
PLUGIN_STATUS ACTIVE |
| 18 |
|
| 19 |
SET @@global.keyring_file_data='keyring_file'; |
| 20 |
SELECT @@global.keyring_file_data; |
| 21 |
@@global.keyring_file_data |
| 22 |
keyring_file |
| 23 |
CREATE TABLE t1(c1 INT, c2 char(20)) ENCRYPTION="Y" ENGINE = InnoDB; |
| 24 |
SET @@global.keyring_file_data= 'MYSQL_TMP_DIR/new_keyring_file_data'; |
| 25 |
SELECT @@global.keyring_file_data; |
| 26 |
@@global.keyring_file_data |
| 27 |
MYSQL_TMP_DIR/new_keyring_file_data |
| 28 |
SET @@global.keyring_file_data=''; |
| 29 |
ERROR 42000: Variable 'keyring_file_data' can't be set to the value of '' |
| 30 |
SET @@global.keyring_file_data=1; |
| 31 |
ERROR 42000: Incorrect argument type to variable 'keyring_file_data' |
| 32 |
SET @@global.keyring_file_data='/'; |
| 33 |
ERROR 42000: Variable 'keyring_file_data' can't be set to the value of '/' |
| 34 |
SET @@global.keyring_file_data='/keyring/'; |
| 35 |
ERROR 42000: Variable 'keyring_file_data' can't be set to the value of '/keyring/' |
| 36 |
SET @@session.keyring_file_data= '$MYSQL_TMP_DIR/new_keyring_file_data'; |
| 37 |
ERROR HY000: Variable 'keyring_file_data' is a GLOBAL variable and should be set with SET GLOBAL |
| 38 |
SET @@local.keyring_file_data= '$MYSQL_TMP_DIR/new_keyring_file_data'; |
| 39 |
ERROR HY000: Variable 'keyring_file_data' is a GLOBAL variable and should be set with SET GLOBAL |
| 40 |
SET @@global.keyring_file_data= 'MYSQL_test_invalid/dir/'; |
| 41 |
ERROR 42000: Variable 'keyring_file_data' can't be set to the value of 'MYSQL_test_invalid/dir/' |
| 42 |
SELECT @@global.keyring_file_data; |
| 43 |
@@global.keyring_file_data |
| 44 |
MYSQL_TMP_DIR/new_keyring_file_data |
| 45 |
|
| 46 |
UNINSTALL PLUGIN keyring_file; |
| 47 |
SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS |
| 48 |
FROM INFORMATION_SCHEMA.PLUGINS WHERE plugin_name='keyring_file'; |
| 49 |
|
| 50 |
DROP TABLE t1; |
| 51 |
|
| 52 |
#End: |