Debian Codegraph @

mysql-test/suite/auth_sec/t/keyring_udf.test

raw
1
2 call mtr.add_suppression("Error while fetching key: key_id cannot be empty");
3 call mtr.add_suppression("Error while removing key: key_id cannot be empty");
4 call mtr.add_suppression("Error while generating key: invalid key_type");
5 call mtr.add_suppression("Error while generating key: key_id cannot be empty");
6 call mtr.add_suppression("Error while storing key: invalid key_type");
7 call mtr.add_suppression("Error while storing key: key_id cannot be empty");
8
9 --echo # Check what happens when we have not yet loaded keyring_udf or keyring_file
10 --source include/keyring_udf_missing_plugin.inc
11
12 #We need both plugins - keyring_file and keyring_udf in one place - to be able to load both plugins
13 if ($KEYRING_UDF_DIR != $KEYRING_PLUGIN_DIR)
14 {
15 --replace_regex /\.dll/.so/
16 --error 0,1
17 --remove_file $KEYRING_UDF_DIR/$KEYRING_PLUGIN
18 --replace_regex /\.dll/.so/
19 --copy_file $KEYRING_PLUGIN_DIR/$KEYRING_PLUGIN $KEYRING_UDF_DIR/$KEYRING_PLUGIN
20 }
21 --echo # Re-starting mysql server with keyring_file plugin.
22 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
23 -- send_shutdown
24 -- source include/wait_until_disconnected.inc
25 --exec echo "restart:--early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/keyring/keyring" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
26 --enable_reconnect
27 --source include/wait_until_connected_again.inc
28 --disable_reconnect
29
30 --echo # Check what happens when we have not yet loaded keyring_udf
31 --source include/keyring_udf_missing_plugin.inc
32
33 --replace_regex /\.dll/.so/
34 eval INSTALL PLUGIN keyring_udf SONAME '$KEYRING_UDF';
35
36 --echo # Check if keys are available after server restart
37 --replace_regex /\.dll/.so/
38 eval create function keyring_key_store returns integer soname '$KEYRING_UDF';
39 --replace_regex /\.dll/.so/
40 eval create function keyring_key_generate returns integer soname '$KEYRING_UDF';
41
42 select keyring_key_generate('Rob_AES_128','AES',16);
43 select keyring_key_store('Rob_AES_128_store','AES',"0123456789012345");
44
45 drop function keyring_key_generate;
46 drop function keyring_key_store;
47
48 --echo # Re-starting mysql server with keyring_file plugin.
49 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
50 -- send_shutdown
51 -- source include/wait_until_disconnected.inc
52 --exec echo "restart:--early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/keyring/keyring" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
53 --enable_reconnect
54 --source include/wait_until_connected_again.inc
55 --disable_reconnect
56
57 --replace_regex /\.dll/.so/
58 eval create function keyring_key_fetch returns string soname '$KEYRING_UDF';
59 --replace_regex /\.dll/.so/
60 eval create function keyring_key_type_fetch returns string soname '$KEYRING_UDF';
61 --replace_regex /\.dll/.so/
62 eval create function keyring_key_length_fetch returns integer soname '$KEYRING_UDF';
63 --replace_regex /\.dll/.so/
64 eval create function keyring_key_remove returns integer soname '$KEYRING_UDF';
65
66 select keyring_key_fetch('Rob_AES_128') into @x;
67 select LENGTH(@x);
68 select keyring_key_length_fetch('Rob_AES_128');
69 select keyring_key_type_fetch('Rob_AES_128');
70 select keyring_key_remove('Rob_AES_128');
71
72 select keyring_key_fetch('Rob_AES_128_store') into @x;
73 select LENGTH(@x);
74 select keyring_key_length_fetch('Rob_AES_128_store');
75 select keyring_key_type_fetch('Rob_AES_128_store');
76 select keyring_key_remove('Rob_AES_128_store');
77
78 drop function keyring_key_fetch;
79 drop function keyring_key_type_fetch;
80 drop function keyring_key_length_fetch;
81 drop function keyring_key_remove;
82
83 --echo # Test cases for keyring_udf and keyring_file plugins loaded
84 --source include/keyring_udf_keyring_plugin_loaded.inc
85 --source include/keyring_udf_keyring_plugin_loaded_store_operations.inc
86
87 # Cases only possible for keyring_file
88 # Generate AES_512
89 select keyring_key_generate('Rob_AES_512','AES',64);
90 set @x= keyring_key_fetch('Rob_AES_512');
91 select LENGTH(@x);
92 select keyring_key_type_fetch('Rob_AES_512');
93 select keyring_key_length_fetch('Rob_AES_512');
94 select keyring_key_remove('Rob_AES_512');
95 # Store AES_512
96 select keyring_key_store('Rob_AES_512','AES',"0123456789012345678901234567890123456789012345678901234567890123");
97 set @x= keyring_key_fetch('Rob_AES_512');
98 select LENGTH(@x);
99 select keyring_key_type_fetch('Rob_AES_512');
100 select keyring_key_length_fetch('Rob_AES_512');
101 select keyring_key_remove('Rob_AES_512');
102 # Case only possible for keyring_file
103 # Generate DES 512
104 select keyring_key_generate('Rob_DSA_4096','DSA',512);
105 set @x= keyring_key_fetch('Rob_DSA_4096');
106 select LENGTH(@x);
107 select keyring_key_type_fetch('Rob_DSA_4096');
108 select keyring_key_length_fetch('Rob_DSA_4096');
109 select keyring_key_remove('Rob_DSA_4096');
110 select CHARSET(keyring_key_type_fetch('Rob_DSA_4096'));
111 UNINSTALL PLUGIN keyring_file;
112 --echo # Test cases for keyring_udf loaded and keyring_file plugin not loaded
113 --source include/keyring_udf_keyring_plugin_not_loaded.inc
114
115 --replace_regex /\.dll/.so/
116 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
117
118 # Tests for SECRET data
119 --source include/keyring_udf_secret_data_before_restart.inc
120 --echo # Re-starting mysql server with keyring_file plugin.
121 let $restart_parameters = restart:--keyring_file_data=$MYSQL_TMP_DIR/keyring/keyring;
122 let $explicit_default_wait_counter=4000;
123 --source include/restart_mysqld_no_echo.inc
124 --source include/keyring_udf_secret_data_after_restart.inc
125
126 UNINSTALL PLUGIN keyring_udf;
127 --echo # Test cases for keyring_udf not loaded and keyring_file plugin loaded
128 --source include/keyring_udf_keyring_udf_plugin_not_loaded.inc
129
130 drop function keyring_key_store;
131 drop function keyring_key_fetch;
132 drop function keyring_key_remove;
133 drop function keyring_key_generate;
134 drop function keyring_key_type_fetch;
135 drop function keyring_key_length_fetch;
136
137 --source include/force_restart.inc