Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 #
8 # WL#13469: secure storage for sensitive system variables
9 #
10 # ----------------------------------------------------------------------
11 # 1. Tests for persisted SENSITIVE variables
12 INSTALL COMPONENT "file://component_test_sensitive_system_variables";
13 CREATE USER wl13469_no_privilege;
14 SET PERSIST test_component.sensitive_string_1 = 'haha';
15 SET PERSIST_ONLY test_component.sensitive_ro_string_1 = 'haha';
16
17 include/assert.inc [PFS table persisted_variables should show SENSITIVE variables for users with SENSITIVE_VARIABLES_OBSERVER privilege]
18
19 include/assert.inc [PFS table persisted_variables should not show SENSITIVE variables for users without SENSITIVE_VARIABLES_OBSERVER privilege]
20 DROP USER wl13469_no_privilege;
21 # Stop the running server.
22 # Restart server with keyring component
23 SELECT a.variable_name, b.variable_value, a.variable_source FROM performance_schema.variables_info AS a, performance_schema.global_variables AS b WHERE a.variable_name = b.variable_name AND a.variable_name LIKE 'test_component.sensitive%';
24 variable_name variable_value variable_source
25 test_component.sensitive_ro_string_1 haha PERSISTED
26 test_component.sensitive_ro_string_2 COMPILED
27 test_component.sensitive_ro_string_3 COMPILED
28 test_component.sensitive_string_1 haha PERSISTED
29 test_component.sensitive_string_2 COMPILED
30 test_component.sensitive_string_3 COMPILED
31 SET PERSIST test_component.sensitive_string_2 = 'hoho';
32 SET PERSIST_ONLY test_component.sensitive_ro_string_2 = 'hoho';
33 SET PERSIST test_component.sensitive_string_3 = 'hoho';
34 SET PERSIST_ONLY test_component.sensitive_ro_string_3 = 'hoho';
35 # Stop the running server.
36 # Restart server with keyring component
37 SELECT a.variable_name, b.variable_value, a.variable_source FROM performance_schema.variables_info AS a, performance_schema.global_variables AS b WHERE a.variable_name = b.variable_name AND a.variable_name LIKE 'test_component.sensitive%';
38 variable_name variable_value variable_source
39 test_component.sensitive_ro_string_1 haha PERSISTED
40 test_component.sensitive_ro_string_2 hoho PERSISTED
41 test_component.sensitive_ro_string_3 hoho PERSISTED
42 test_component.sensitive_string_1 haha PERSISTED
43 test_component.sensitive_string_2 hoho PERSISTED
44 test_component.sensitive_string_3 hoho PERSISTED
45 RESET PERSIST;
46 UNINSTALL COMPONENT "file://component_test_sensitive_system_variables";
47 # ----------------------------------------------------------------------
48 # ----------------------------------------------------------------------
49 # Teardown
50 # Removing manifest file for current MySQL server instance
51 # Removing local keyring file for keyring component: component_keyring_file
52 # Removing local configuration file for keyring component: component_keyring_file
53 # Restarting server without the manifest file
54 # ----------------------------------------------------------------------