Debian Codegraph @

mysql-test/suite/auth_sec/r/keyring_udf.result

raw
1 call mtr.add_suppression("Error while fetching key: key_id cannot be empty");
2 call mtr.add_suppression("Error while removing key: key_id cannot be empty");
3 call mtr.add_suppression("Error while generating key: invalid key_type");
4 call mtr.add_suppression("Error while generating key: key_id cannot be empty");
5 call mtr.add_suppression("Error while storing key: invalid key_type");
6 call mtr.add_suppression("Error while storing key: key_id cannot be empty");
7 # Check what happens when we have not yet loaded keyring_udf or keyring_file
8 create function keyring_key_store returns integer soname 'keyring_udf.so';
9 create function keyring_key_fetch returns string soname 'keyring_udf.so';
10 create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
11 create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
12 create function keyring_key_remove returns integer soname 'keyring_udf.so';
13 create function keyring_key_generate returns integer soname 'keyring_udf.so';
14 select * from mysql.func where name like '%keyring%' order by name;
15 name ret dl type
16 keyring_key_fetch 0 keyring_udf.so function
17 keyring_key_generate 2 keyring_udf.so function
18 keyring_key_length_fetch 2 keyring_udf.so function
19 keyring_key_remove 2 keyring_udf.so function
20 keyring_key_store 2 keyring_udf.so function
21 keyring_key_type_fetch 0 keyring_udf.so function
22 select keyring_key_generate('Rob_AES_128','AES',16);
23 ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
24 select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
25 ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
26 select keyring_key_fetch('Rob_AES_128');
27 ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
28 select keyring_key_type_fetch('Rob_AES_128');
29 ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
30 select keyring_key_length_fetch('Rob_AES_128');
31 ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
32 select keyring_key_remove('Rob_AES_128');
33 ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
34 drop function keyring_key_store;
35 drop function keyring_key_fetch;
36 drop function keyring_key_type_fetch;
37 drop function keyring_key_length_fetch;
38 drop function keyring_key_remove;
39 drop function keyring_key_generate;
40 # Re-starting mysql server with keyring_file plugin.
41 # Check what happens when we have not yet loaded keyring_udf
42 create function keyring_key_store returns integer soname 'keyring_udf.so';
43 create function keyring_key_fetch returns string soname 'keyring_udf.so';
44 create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
45 create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
46 create function keyring_key_remove returns integer soname 'keyring_udf.so';
47 create function keyring_key_generate returns integer soname 'keyring_udf.so';
48 select * from mysql.func where name like '%keyring%' order by name;
49 name ret dl type
50 keyring_key_fetch 0 keyring_udf.so function
51 keyring_key_generate 2 keyring_udf.so function
52 keyring_key_length_fetch 2 keyring_udf.so function
53 keyring_key_remove 2 keyring_udf.so function
54 keyring_key_store 2 keyring_udf.so function
55 keyring_key_type_fetch 0 keyring_udf.so function
56 select keyring_key_generate('Rob_AES_128','AES',16);
57 ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
58 select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
59 ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
60 select keyring_key_fetch('Rob_AES_128');
61 ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
62 select keyring_key_type_fetch('Rob_AES_128');
63 ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
64 select keyring_key_length_fetch('Rob_AES_128');
65 ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
66 select keyring_key_remove('Rob_AES_128');
67 ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
68 drop function keyring_key_store;
69 drop function keyring_key_fetch;
70 drop function keyring_key_type_fetch;
71 drop function keyring_key_length_fetch;
72 drop function keyring_key_remove;
73 drop function keyring_key_generate;
74 INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so';
75 # Check if keys are available after server restart
76 create function keyring_key_store returns integer soname 'keyring_udf.so';
77 create function keyring_key_generate returns integer soname 'keyring_udf.so';
78 select keyring_key_generate('Rob_AES_128','AES',16);
79 keyring_key_generate('Rob_AES_128','AES',16)
80 1
81 select keyring_key_store('Rob_AES_128_store','AES',"0123456789012345");
82 keyring_key_store('Rob_AES_128_store','AES',"0123456789012345")
83 1
84 drop function keyring_key_generate;
85 drop function keyring_key_store;
86 # Re-starting mysql server with keyring_file plugin.
87 create function keyring_key_fetch returns string soname 'keyring_udf.so';
88 create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
89 create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
90 create function keyring_key_remove returns integer soname 'keyring_udf.so';
91 select keyring_key_fetch('Rob_AES_128') into @x;
92 select LENGTH(@x);
93 LENGTH(@x)
94 16
95 select keyring_key_length_fetch('Rob_AES_128');
96 keyring_key_length_fetch('Rob_AES_128')
97 16
98 select keyring_key_type_fetch('Rob_AES_128');
99 keyring_key_type_fetch('Rob_AES_128')
100 AES
101 select keyring_key_remove('Rob_AES_128');
102 keyring_key_remove('Rob_AES_128')
103 1
104 select keyring_key_fetch('Rob_AES_128_store') into @x;
105 select LENGTH(@x);
106 LENGTH(@x)
107 16
108 select keyring_key_length_fetch('Rob_AES_128_store');
109 keyring_key_length_fetch('Rob_AES_128_store')
110 16
111 select keyring_key_type_fetch('Rob_AES_128_store');
112 keyring_key_type_fetch('Rob_AES_128_store')
113 AES
114 select keyring_key_remove('Rob_AES_128_store');
115 keyring_key_remove('Rob_AES_128_store')
116 1
117 drop function keyring_key_fetch;
118 drop function keyring_key_type_fetch;
119 drop function keyring_key_length_fetch;
120 drop function keyring_key_remove;
121 # Test cases for keyring_udf and keyring_file plugins loaded
122 create function keyring_key_fetch returns string soname 'keyring_udf.so';
123 create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
124 create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
125 create function keyring_key_remove returns integer soname 'keyring_udf.so';
126 create function keyring_key_generate returns integer soname 'keyring_udf.so';
127 select keyring_key_fetch('Key_1','AES');
128 ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch in number of arguments to the function.
129 select keyring_key_type_fetch('Key_1','AES');
130 ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; Mismatch in number of arguments to the function.
131 select keyring_key_length_fetch('Key_1','AES');
132 ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; Mismatch in number of arguments to the function.
133 select keyring_key_remove('Key_1','AES');
134 ERROR HY000: Can't initialize function 'keyring_key_remove'; Mismatch in number of arguments to the function.
135 select keyring_key_generate('Key_1');
136 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
137 select keyring_key_generate('Key_1','AES');
138 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
139 select keyring_key_generate('Key_1','');
140 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
141 select keyring_key_fetch('Key_1',NULL);
142 ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch in number of arguments to the function.
143 select keyring_key_fetch(1);
144 ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch encountered. A string argument is expected for key id.
145 select keyring_key_fetch(NULL);
146 keyring_key_fetch(NULL)
147 NULL
148 select keyring_key_type_fetch(1);
149 ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; Mismatch encountered. A string argument is expected for key id.
150 select keyring_key_type_fetch(NULL);
151 keyring_key_type_fetch(NULL)
152 NULL
153 select keyring_key_length_fetch(1);
154 ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; Mismatch encountered. A string argument is expected for key id.
155 select keyring_key_length_fetch(NULL);
156 keyring_key_length_fetch(NULL)
157 NULL
158 select keyring_key_generate('Key_1','AES','123');
159 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
160 select keyring_key_generate(NULL,'AES','123');
161 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
162 select keyring_key_generate('Key_1',NULL,'123');
163 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
164 select keyring_key_generate('Key_1','AES',NULL);
165 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
166 select keyring_key_generate(NULL,NULL,NULL);
167 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
168 select keyring_key_generate(1,'AES',123);
169 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key id.
170 select keyring_key_generate('Key_1',123,'123');
171 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key type.
172 select keyring_key_generate('Key_invalid_key_type',123,123);
173 ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key type.
174 select keyring_key_remove(1);
175 ERROR HY000: Can't initialize function 'keyring_key_remove'; Mismatch encountered. A string argument is expected for key id.
176 select keyring_key_remove(NULL);
177 keyring_key_remove(NULL)
178 NULL
179 select PLUGIN_NAME,PLUGIN_AUTHOR from information_schema.plugins where PLUGIN_NAME like '%keyring%';
180 PLUGIN_NAME PLUGIN_AUTHOR
181 keyring_file Oracle Corporation
182 daemon_keyring_proxy_plugin Oracle
183 keyring_udf Oracle Corporation
184 select keyring_key_generate('Rob_AES_128','AES',16);
185 keyring_key_generate('Rob_AES_128','AES',16)
186 1
187 select keyring_key_fetch('Rob_AES_128') into @x;
188 select LENGTH(@x);
189 LENGTH(@x)
190 16
191 select keyring_key_type_fetch('Rob_AES_128');
192 keyring_key_type_fetch('Rob_AES_128')
193 AES
194 select keyring_key_length_fetch('Rob_AES_128');
195 keyring_key_length_fetch('Rob_AES_128')
196 16
197 select keyring_key_remove('Rob_AES_128');
198 keyring_key_remove('Rob_AES_128')
199 1
200 select keyring_key_generate('Rob_AES_192','AES',24);
201 keyring_key_generate('Rob_AES_192','AES',24)
202 1
203 select keyring_key_fetch('Rob_AES_192') into @x;
204 select LENGTH(@x);
205 LENGTH(@x)
206 24
207 select keyring_key_type_fetch('Rob_AES_192');
208 keyring_key_type_fetch('Rob_AES_192')
209 AES
210 select keyring_key_length_fetch('Rob_AES_192');
211 keyring_key_length_fetch('Rob_AES_192')
212 24
213 select keyring_key_remove('Rob_AES_192');
214 keyring_key_remove('Rob_AES_192')
215 1
216 select keyring_key_generate('Rob_AES_256','AES',32);
217 keyring_key_generate('Rob_AES_256','AES',32)
218 1
219 select keyring_key_fetch('Rob_AES_256') into @x;
220 select LENGTH(@x);
221 LENGTH(@x)
222 32
223 select keyring_key_type_fetch('Rob_AES_256');
224 keyring_key_type_fetch('Rob_AES_256')
225 AES
226 select keyring_key_length_fetch('Rob_AES_256');
227 keyring_key_length_fetch('Rob_AES_256')
228 32
229 select keyring_key_remove('Rob_AES_256');
230 keyring_key_remove('Rob_AES_256')
231 1
232 select keyring_key_generate('Rob_RSA_1024','RSA',128);
233 keyring_key_generate('Rob_RSA_1024','RSA',128)
234 1
235 select keyring_key_fetch('Rob_RSA_1024') into @x;
236 select LENGTH(@x);
237 LENGTH(@x)
238 128
239 select keyring_key_type_fetch('Rob_RSA_1024');
240 keyring_key_type_fetch('Rob_RSA_1024')
241 RSA
242 select keyring_key_length_fetch('Rob_RSA_1024');
243 keyring_key_length_fetch('Rob_RSA_1024')
244 128
245 select keyring_key_remove('Rob_RSA_1024');
246 keyring_key_remove('Rob_RSA_1024')
247 1
248 select keyring_key_generate('Rob_RSA_2048','RSA',256);
249 keyring_key_generate('Rob_RSA_2048','RSA',256)
250 1
251 select keyring_key_fetch('Rob_RSA_2048') into @x;
252 select keyring_key_type_fetch('Rob_RSA_2048');
253 keyring_key_type_fetch('Rob_RSA_2048')
254 RSA
255 select keyring_key_length_fetch('Rob_RSA_2048');
256 keyring_key_length_fetch('Rob_RSA_2048')
257 256
258 select LENGTH(@x);
259 LENGTH(@x)
260 256
261 select keyring_key_remove('Rob_RSA_2048');
262 keyring_key_remove('Rob_RSA_2048')
263 1
264 select keyring_key_generate('Rob_RSA_4096','RSA',512);
265 keyring_key_generate('Rob_RSA_4096','RSA',512)
266 1
267 select keyring_key_fetch('Rob_RSA_4096') into @x;
268 select keyring_key_type_fetch('Rob_RSA_4096');
269 keyring_key_type_fetch('Rob_RSA_4096')
270 RSA
271 select keyring_key_length_fetch('Rob_RSA_4096');
272 keyring_key_length_fetch('Rob_RSA_4096')
273 512
274 select LENGTH(@x);
275 LENGTH(@x)
276 512
277 select keyring_key_remove('Rob_RSA_4096');
278 keyring_key_remove('Rob_RSA_4096')
279 1
280 select keyring_key_generate('Rob_DSA_1024','DSA',128);
281 keyring_key_generate('Rob_DSA_1024','DSA',128)
282 1
283 select keyring_key_fetch('Rob_DSA_1024') into @x;
284 select LENGTH(@x);
285 LENGTH(@x)
286 128
287 select keyring_key_type_fetch('Rob_DSA_1024');
288 keyring_key_type_fetch('Rob_DSA_1024')
289 DSA
290 select keyring_key_length_fetch('Rob_DSA_1024');
291 keyring_key_length_fetch('Rob_DSA_1024')
292 128
293 select keyring_key_remove('Rob_DSA_1024');
294 keyring_key_remove('Rob_DSA_1024')
295 1
296 select keyring_key_generate('Rob_DSA_2048','DSA',256);
297 keyring_key_generate('Rob_DSA_2048','DSA',256)
298 1
299 select keyring_key_fetch('Rob_DSA_2048') into @x;
300 select LENGTH(@x);
301 LENGTH(@x)
302 256
303 select keyring_key_type_fetch('Rob_DSA_2048');
304 keyring_key_type_fetch('Rob_DSA_2048')
305 DSA
306 select keyring_key_length_fetch('Rob_DSA_2048');
307 keyring_key_length_fetch('Rob_DSA_2048')
308 256
309 select keyring_key_remove('Rob_DSA_2048');
310 keyring_key_remove('Rob_DSA_2048')
311 1
312 select keyring_key_generate('Rob_DSA_3072','DSA',384);
313 keyring_key_generate('Rob_DSA_3072','DSA',384)
314 1
315 select keyring_key_fetch('Rob_DSA_3072') into @x;
316 select LENGTH(@x);
317 LENGTH(@x)
318 384
319 select keyring_key_type_fetch('Rob_DSA_3072');
320 keyring_key_type_fetch('Rob_DSA_3072')
321 DSA
322 select keyring_key_length_fetch('Rob_DSA_3072');
323 keyring_key_length_fetch('Rob_DSA_3072')
324 384
325 select keyring_key_remove('Rob_DSA_3072');
326 keyring_key_remove('Rob_DSA_3072')
327 1
328 select keyring_key_fetch('key') into @x;
329 select @x;
330 @x
331 NULL
332 select keyring_key_type_fetch('key') into @x;
333 select @x;
334 @x
335 NULL
336 select keyring_key_length_fetch('key') into @x;
337 select @x;
338 @x
339 NULL
340 #Testing with AES_ENCRYPT/AES_DECRYPT
341 select keyring_key_generate('AES_128','AES',16);
342 keyring_key_generate('AES_128','AES',16)
343 1
344 select AES_ENCRYPT('secret message', keyring_key_fetch('AES_128')) into @cipher;
345 select AES_DECRYPT(@cipher, keyring_key_fetch('AES_128'));
346 AES_DECRYPT(@cipher, keyring_key_fetch('AES_128'))
347 secret message
348 select keyring_key_remove('AES_128');
349 keyring_key_remove('AES_128')
350 1
351 select keyring_key_fetch('Rob1');
352 keyring_key_fetch('Rob1')
353 NULL
354 select keyring_key_type_fetch('Rob1');
355 keyring_key_type_fetch('Rob1')
356 NULL
357 select keyring_key_length_fetch('Rob1');
358 keyring_key_length_fetch('Rob1')
359 NULL
360 select keyring_key_fetch('') into @x;
361 ERROR HY000: Function 'keyring_key_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
362 select @x;
363 @x
364 NULL
365 select keyring_key_length_fetch('') into @x;
366 ERROR HY000: Function 'keyring_key_length_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
367 select @x;
368 @x
369 NULL
370 select keyring_key_type_fetch('') into @x;
371 ERROR HY000: Function 'keyring_key_type_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
372 select @x;
373 @x
374 NULL
375 select keyring_key_remove('Rob_not_existing') into @x;
376 ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
377 select @x;
378 @x
379 NULL
380 select keyring_key_remove('') into @x;
381 ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
382 select @x;
383 @x
384 NULL
385 select keyring_key_generate('Wrong_type','xxx', 16) into @x;
386 ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
387 select @x;
388 @x
389 NULL
390 select keyring_key_generate('','AES', 16) into @x;
391 ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
392 select @x;
393 @x
394 NULL
395 # Testing privileges
396 select keyring_key_generate('roots_key', 'AES',16);
397 keyring_key_generate('roots_key', 'AES',16)
398 1
399 create definer=root@localhost procedure shared_key() select keyring_key_fetch('roots_key');
400 CREATE USER user_execute_test@localhost;
401 select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
402 ERROR HY000: Can't initialize function 'keyring_key_generate'; The user is not privileged to execute this function. User needs to have EXECUTE permission.
403 GRANT EXECUTE ON *.* TO 'user_execute_test'@'localhost';
404 select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
405 keyring_key_generate('Rob_DSA_no_privilege','DSA',384)
406 1
407 select keyring_key_generate('another_Rob_DSA_no_privilege','DSA',384);
408 keyring_key_generate('another_Rob_DSA_no_privilege','DSA',384)
409 1
410 #Check if user you can access another user's keys
411 select keyring_key_remove('roots_key');
412 ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
413 #Check that the user is able to access the key via procedure
414 call shared_key();
415 keyring_key_fetch('roots_key')
416 #
417 DROP PROCEDURE shared_key;
418 #Check if a user can create a key with id that already exist but belongs
419 #to another user.
420 select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
421 keyring_key_generate('Rob_DSA_no_privilege','DSA',384)
422 1
423 #Check if user with larger privileges can access another user's key
424 select keyring_key_remove('another_Rob_DSA_no_privilege');
425 ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
426 #Cleanup
427 select keyring_key_remove('Rob_DSA_no_privilege');
428 keyring_key_remove('Rob_DSA_no_privilege')
429 1
430 select keyring_key_remove('roots_key');
431 keyring_key_remove('roots_key')
432 1
433 select keyring_key_remove('Rob_DSA_no_privilege');
434 keyring_key_remove('Rob_DSA_no_privilege')
435 1
436 select keyring_key_remove('another_Rob_DSA_no_privilege');
437 keyring_key_remove('another_Rob_DSA_no_privilege')
438 1
439 DROP USER 'user_execute_test'@'localhost';
440 create function keyring_key_store returns integer soname 'keyring_udf.so';
441 select keyring_key_store('Key_1');
442 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch in number of arguments to the function.
443 select keyring_key_store('Key_1','AES');
444 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch in number of arguments to the function.
445 select keyring_key_store('Key_1','AES',123);
446 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key.
447 select keyring_key_store(NULL,'AES',123);
448 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key.
449 select keyring_key_store('Key_1',NULL,123);
450 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key.
451 select keyring_key_store('Key_1','AES',NULL);
452 keyring_key_store('Key_1','AES',NULL)
453 NULL
454 select keyring_key_store(NULL,NULL,NULL);
455 keyring_key_store(NULL,NULL,NULL)
456 NULL
457 select keyring_key_store(1234,NULL,'53247@#$%^');
458 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
459 select keyring_key_store(1,'AES','123');
460 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
461 select keyring_key_store('Key_1',123,'123');
462 ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key type.
463 select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
464 keyring_key_store('Rob_AES_128','AES',"0123456789012345")
465 1
466 select keyring_key_fetch('Rob_AES_128') into @x;
467 select LENGTH(@x);
468 LENGTH(@x)
469 16
470 select keyring_key_type_fetch('Rob_AES_128');
471 keyring_key_type_fetch('Rob_AES_128')
472 AES
473 select keyring_key_length_fetch('Rob_AES_128');
474 keyring_key_length_fetch('Rob_AES_128')
475 16
476 select keyring_key_remove('Rob_AES_128');
477 keyring_key_remove('Rob_AES_128')
478 1
479 select keyring_key_store('Rob_AES_192','AES',"012345678901234567890%@3");
480 keyring_key_store('Rob_AES_192','AES',"012345678901234567890%@3")
481 1
482 select keyring_key_fetch('Rob_AES_192') into @x;
483 select LENGTH(@x);
484 LENGTH(@x)
485 24
486 select keyring_key_type_fetch('Rob_AES_192');
487 keyring_key_type_fetch('Rob_AES_192')
488 AES
489 select keyring_key_length_fetch('Rob_AES_192');
490 keyring_key_length_fetch('Rob_AES_192')
491 24
492 select keyring_key_remove('Rob_AES_192');
493 keyring_key_remove('Rob_AES_192')
494 1
495 select keyring_key_store('Rob_AES_256','AES',"01234567890123456789012345678901");
496 keyring_key_store('Rob_AES_256','AES',"01234567890123456789012345678901")
497 1
498 select keyring_key_fetch('Rob_AES_256') into @x;
499 select LENGTH(@x);
500 LENGTH(@x)
501 32
502 select keyring_key_type_fetch('Rob_AES_256');
503 keyring_key_type_fetch('Rob_AES_256')
504 AES
505 select keyring_key_length_fetch('Rob_AES_256');
506 keyring_key_length_fetch('Rob_AES_256')
507 32
508 select keyring_key_remove('Rob_AES_256');
509 keyring_key_remove('Rob_AES_256')
510 1
511 select keyring_key_store('Rob_RSA_1024','RSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123");
512 keyring_key_store('Rob_RSA_1024','RSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123")
513 1
514 select keyring_key_fetch('Rob_RSA_1024') into @x;
515 select LENGTH(@x);
516 LENGTH(@x)
517 128
518 select keyring_key_type_fetch('Rob_RSA_1024');
519 keyring_key_type_fetch('Rob_RSA_1024')
520 RSA
521 select keyring_key_length_fetch('Rob_RSA_1024');
522 keyring_key_length_fetch('Rob_RSA_1024')
523 128
524 select keyring_key_remove('Rob_RSA_1024');
525 keyring_key_remove('Rob_RSA_1024')
526 1
527 select keyring_key_store('Rob_DSA_1024','DSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123");
528 keyring_key_store('Rob_DSA_1024','DSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123")
529 1
530 select keyring_key_fetch('Rob_DSA_1024') into @x;
531 select LENGTH(@x);
532 LENGTH(@x)
533 128
534 select keyring_key_type_fetch('Rob_DSA_1024');
535 keyring_key_type_fetch('Rob_DSA_1024')
536 DSA
537 select keyring_key_length_fetch('Rob_DSA_1024');
538 keyring_key_length_fetch('Rob_DSA_1024')
539 128
540 select keyring_key_remove('Rob_DSA_1024');
541 keyring_key_remove('Rob_DSA_1024')
542 1
543 select keyring_key_store('Wrong_type','xxx', '0123456789012345') into @x;
544 ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
545 select @x;
546 @x
547 NULL
548 select keyring_key_store('','AES', '0123456789012345') into @x;
549 ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
550 select @x;
551 @x
552 NULL
553 select repeat('abcdefgh', 2049) into @x;
554 select keyring_key_store('long_key', 'AES', @x);
555 ERROR HY000: Function 'keyring_key_store' failed because key length is too long.
556 select repeat('abcdefgh', 17) into @x;
557 select keyring_key_generate('Rob_AES_512','AES',64);
558 keyring_key_generate('Rob_AES_512','AES',64)
559 1
560 set @x= keyring_key_fetch('Rob_AES_512');
561 select LENGTH(@x);
562 LENGTH(@x)
563 64
564 select keyring_key_type_fetch('Rob_AES_512');
565 keyring_key_type_fetch('Rob_AES_512')
566 AES
567 select keyring_key_length_fetch('Rob_AES_512');
568 keyring_key_length_fetch('Rob_AES_512')
569 64
570 select keyring_key_remove('Rob_AES_512');
571 keyring_key_remove('Rob_AES_512')
572 1
573 select keyring_key_store('Rob_AES_512','AES',"0123456789012345678901234567890123456789012345678901234567890123");
574 keyring_key_store('Rob_AES_512','AES',"0123456789012345678901234567890123456789012345678901234567890123")
575 1
576 set @x= keyring_key_fetch('Rob_AES_512');
577 select LENGTH(@x);
578 LENGTH(@x)
579 64
580 select keyring_key_type_fetch('Rob_AES_512');
581 keyring_key_type_fetch('Rob_AES_512')
582 AES
583 select keyring_key_length_fetch('Rob_AES_512');
584 keyring_key_length_fetch('Rob_AES_512')
585 64
586 select keyring_key_remove('Rob_AES_512');
587 keyring_key_remove('Rob_AES_512')
588 1
589 select keyring_key_generate('Rob_DSA_4096','DSA',512);
590 keyring_key_generate('Rob_DSA_4096','DSA',512)
591 1
592 set @x= keyring_key_fetch('Rob_DSA_4096');
593 select LENGTH(@x);
594 LENGTH(@x)
595 512
596 select keyring_key_type_fetch('Rob_DSA_4096');
597 keyring_key_type_fetch('Rob_DSA_4096')
598 DSA
599 select keyring_key_length_fetch('Rob_DSA_4096');
600 keyring_key_length_fetch('Rob_DSA_4096')
601 512
602 select keyring_key_remove('Rob_DSA_4096');
603 keyring_key_remove('Rob_DSA_4096')
604 1
605 select CHARSET(keyring_key_type_fetch('Rob_DSA_4096'));
606 CHARSET(keyring_key_type_fetch('Rob_DSA_4096'))
607 utf8mb4
608 UNINSTALL PLUGIN keyring_file;
609 # Test cases for keyring_udf loaded and keyring_file plugin not loaded
610 #The keyring plugin was uninstalled, the keyring_udf functions should fail with
611 #appropriate error message
612 select keyring_key_store('Rob_uninstalled','AES','123');
613 ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
614 select keyring_key_fetch('Rob_uninstalled');
615 ERROR HY000: Function 'keyring_key_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
616 select keyring_key_type_fetch('Rob_uninstalled');
617 ERROR HY000: Function 'keyring_key_type_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
618 select keyring_key_length_fetch('Rob_uninstalled');
619 ERROR HY000: Function 'keyring_key_length_fetch' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
620 select keyring_key_remove('Rob_uninstalled');
621 ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
622 select keyring_key_generate('Rob_uninstalled_generate','DSA',128);
623 ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring is installed and that provided arguments are valid for the keyring you are using.
624 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
625 SELECT keyring_key_store('secret_test_keystore', 'SECRET', 'abcdefgh');
626 keyring_key_store('secret_test_keystore', 'SECRET', 'abcdefgh')
627 1
628 SELECT keyring_key_type_fetch('secret_test_keystore');
629 keyring_key_type_fetch('secret_test_keystore')
630 SECRET
631 SELECT keyring_key_length_fetch('secret_test_keystore');
632 keyring_key_length_fetch('secret_test_keystore')
633 8
634 SELECT keyring_key_fetch('secret_test_keystore');
635 keyring_key_fetch('secret_test_keystore')
636 abcdefgh
637 SELECT keyring_key_generate('secret_test_keygenerate', 'SECRET', 8);
638 keyring_key_generate('secret_test_keygenerate', 'SECRET', 8)
639 1
640 SELECT keyring_key_type_fetch('secret_test_keygenerate');
641 keyring_key_type_fetch('secret_test_keygenerate')
642 SECRET
643 SELECT keyring_key_length_fetch('secret_test_keygenerate');
644 keyring_key_length_fetch('secret_test_keygenerate')
645 8
646 SELECT keyring_key_fetch('secret_test_keystore') into @keystore_retrieved;
647 select LENGTH(@keystore_retrieved);
648 LENGTH(@keystore_retrieved)
649 8
650 CREATE TABLE t1(id INT AUTO_INCREMENT, c1 TEXT, PRIMARY KEY(id));
651 LOAD DATA INFILE '../../std_data/secret_data_cert.txt' INTO TABLE t1 LINES TERMINATED BY 'hahaha' (c1);
652 SELECT c1 FROM t1 WHERE id = 1 INTO @cert_value_table;
653 SELECT keyring_key_store('secret_test_pemfile', 'SECRET', @cert_value_table);
654 keyring_key_store('secret_test_pemfile', 'SECRET', @cert_value_table)
655 1
656 SELECT keyring_key_type_fetch('secret_test_pemfile');
657 keyring_key_type_fetch('secret_test_pemfile')
658 SECRET
659 SELECT keyring_key_length_fetch('secret_test_pemfile');
660 keyring_key_length_fetch('secret_test_pemfile')
661 1374
662 SELECT keyring_key_fetch('secret_test_pemfile') INTO @cert_value_keyring;
663 SELECT @cert_value_table = @cert_value_keyring;
664 @cert_value_table = @cert_value_keyring
665 1
666 SET @store_length = 16384;
667 SET @generate_length = @store_length;
668 SELECT REPEAT('a',@store_length) INTO @long_store;
669 SELECT keyring_key_store('secret_test_longstore', 'SECRET', @long_store);
670 keyring_key_store('secret_test_longstore', 'SECRET', @long_store)
671 1
672 SELECT keyring_key_fetch('secret_test_longstore') INTO @long_store_retrieved;
673 SELECT @long_store = @long_store_retrieved;
674 @long_store = @long_store_retrieved
675 1
676 SELECT keyring_key_generate('secret_test_longgenerated', 'SECRET', @generate_length);
677 keyring_key_generate('secret_test_longgenerated', 'SECRET', @generate_length)
678 1
679 SELECT keyring_key_fetch('secret_test_longgenerated') INTO @long_generated_retrieved;
680 SELECT keyring_key_length_fetch('secret_test_longgenerated');
681 keyring_key_length_fetch('secret_test_longgenerated')
682 16384
683 SELECT keyring_key_fetch('secret_test_longstore') INTO @secret_test_longstore_retrieved;
684 select LENGTH(@secret_test_longstore_retrieved);
685 LENGTH(@secret_test_longstore_retrieved)
686 16384
687 SELECT KEY_ID, KEY_OWNER FROM performance_schema.keyring_keys WHERE
688 KEY_ID LIKE 'secret_test%' ORDER BY KEY_ID, KEY_OWNER;
689 KEY_ID KEY_OWNER
690 secret_test_keygenerate root@localhost
691 secret_test_keystore root@localhost
692 secret_test_longgenerated root@localhost
693 secret_test_longstore root@localhost
694 secret_test_pemfile root@localhost
695 # Re-starting mysql server with keyring_file plugin.
696 SELECT keyring_key_type_fetch('secret_test_keystore');
697 keyring_key_type_fetch('secret_test_keystore')
698 SECRET
699 SELECT keyring_key_length_fetch('secret_test_keystore');
700 keyring_key_length_fetch('secret_test_keystore')
701 8
702 SELECT keyring_key_fetch('secret_test_keystore');
703 keyring_key_fetch('secret_test_keystore')
704 abcdefgh
705 SELECT c1 FROM t1 WHERE id = 1 INTO @cert_value_table;
706 SELECT keyring_key_type_fetch('secret_test_pemfile');
707 keyring_key_type_fetch('secret_test_pemfile')
708 SECRET
709 SELECT keyring_key_length_fetch('secret_test_pemfile');
710 keyring_key_length_fetch('secret_test_pemfile')
711 1374
712 SELECT keyring_key_fetch('secret_test_pemfile') INTO @cert_value_keyring;
713 SELECT @cert_value_table = @cert_value_keyring;
714 @cert_value_table = @cert_value_keyring
715 1
716 SET @length = 16384;
717 SELECT REPEAT('a',@length) INTO @long_store;
718 SELECT keyring_key_fetch('secret_test_longstore') INTO @long_store_retrieved;
719 SELECT @long_store = @long_store_retrieved;
720 @long_store = @long_store_retrieved
721 1
722 SELECT keyring_key_fetch('secret_test_longgenerated') INTO @long_generated_retrieved;
723 SELECT keyring_key_length_fetch('secret_test_longgenerated');
724 keyring_key_length_fetch('secret_test_longgenerated')
725 16384
726 SELECT KEY_ID, KEY_OWNER FROM performance_schema.keyring_keys WHERE
727 KEY_ID LIKE 'secret_test%' ORDER BY KEY_ID, KEY_OWNER;
728 KEY_ID KEY_OWNER
729 secret_test_keygenerate root@localhost
730 secret_test_keystore root@localhost
731 secret_test_longgenerated root@localhost
732 secret_test_longstore root@localhost
733 secret_test_pemfile root@localhost
734 SELECT keyring_key_remove('secret_test_keystore');
735 keyring_key_remove('secret_test_keystore')
736 1
737 SELECT keyring_key_remove('secret_test_keygenerate');
738 keyring_key_remove('secret_test_keygenerate')
739 1
740 SELECT keyring_key_remove('secret_test_pemfile');
741 keyring_key_remove('secret_test_pemfile')
742 1
743 SELECT keyring_key_remove('secret_test_longstore');
744 keyring_key_remove('secret_test_longstore')
745 1
746 SELECT keyring_key_remove('secret_test_longgenerated');
747 keyring_key_remove('secret_test_longgenerated')
748 1
749 DROP TABLE t1;
750 UNINSTALL PLUGIN keyring_udf;
751 # Test cases for keyring_udf not loaded and keyring_file plugin loaded
752 select keyring_key_store('Rob_uninstalled','AES','123');
753 ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
754 select keyring_key_fetch('Rob_uninstalled');
755 ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
756 select keyring_key_type_fetch('Rob_uninstalled');
757 ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
758 select keyring_key_length_fetch('Rob_uninstalled');
759 ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
760 select keyring_key_remove('Rob_uninstalled');
761 ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
762 select keyring_key_generate('Rob_uninstalled_generate','DSA',128);
763 ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install keyring_udf plugin and try again.
764 drop function keyring_key_store;
765 drop function keyring_key_fetch;
766 drop function keyring_key_remove;
767 drop function keyring_key_generate;
768 drop function keyring_key_type_fetch;
769 drop function keyring_key_length_fetch;