Gecko [ www.jdcpatala.org ]

Name	Size	Permission
access_credential_control.resu...	23.21 KB	-rw-r--r--
cert_verify.result	304 B	-rw-r--r--
early_plugin_load.result	789 B	-rw-r--r--
have_mysql_upgrade.result	21 B	-rw-r--r--
have_ssl.require	33 B	-rw-r--r--
install_keyring.result	263 B	-rw-r--r--
install_keyring_file.result	979 B	-rw-r--r--
key_rotation.result	427 B	-rw-r--r--
key_rotation_qa.result	7.57 KB	-rw-r--r--
key_value_auth.result	13 KB	-rw-r--r--
keyring_file.result	479 B	-rw-r--r--
keyring_file_data.result	1.17 KB	-rw-r--r--
keyring_file_data_qa.result	2.66 KB	-rw-r--r--
keyring_udf.result	29.95 KB	-rw-r--r--
multiple_plugins.result	5.46 KB	-rw-r--r--
mysql_native_plugin.result	10.46 KB	-rw-r--r--
mysql_no_login.result	2.03 KB	-rw-r--r--
mysql_protocol_types.result	2.38 KB	-rw-r--r--
mysql_protocol_types_windows.r...	1.93 KB	-rw-r--r--
mysql_sha256_plugin.result	9.84 KB	-rw-r--r--
mysql_ssl_connection.result	202 B	-rw-r--r--
mysql_ssl_rsa_setup.result	1.4 KB	-rw-r--r--
named_pipe_ssl.result	255 B	-rw-r--r--
not_embedded.require	16 B	-rw-r--r--
not_openssl.require	36 B	-rw-r--r--
not_ssl.require	32 B	-rw-r--r--
openssl.require	37 B	-rw-r--r--
openssl_cert_generation.result	7.37 KB	-rw-r--r--
openssl_cert_generation_debug....	577 B	-rw-r--r--
openssl_cert_generation_subjec...	435 B	-rw-r--r--
openssl_cert_validity.result	109 B	-rw-r--r--
openssl_skip_cert_generation.r...	442 B	-rw-r--r--
password_expired.result	16.4 KB	-rw-r--r--
password_expiry.result	8.09 KB	-rw-r--r--
require_secure_transport.resul...	1.49 KB	-rw-r--r--
require_secure_transport_windo...	2.08 KB	-rw-r--r--
secure_file_priv_error.result	358 B	-rw-r--r--
secure_file_priv_null.result	1.08 KB	-rw-r--r--
secure_file_priv_warnings.resu...	876 B	-rw-r--r--
secure_file_priv_warnings_not_...	582 B	-rw-r--r--
secure_file_priv_warnings_win....	454 B	-rw-r--r--
server_withssl_client_withouts...	6.18 KB	-rw-r--r--
server_withssl_client_withssl....	6.08 KB	-rw-r--r--
set_password_deprecated.result	4.76 KB	-rw-r--r--
ssl_auto_detect.result	1.82 KB	-rw-r--r--
ssl_auto_detect_openssl.result	361 B	-rw-r--r--
ssl_mode.result	5.16 KB	-rw-r--r--
tls.result	1.25 KB	-rw-r--r--
tls12_tls1.result	510 B	-rw-r--r--
wrong_keyring_file.result	166 B	-rw-r--r--
wrong_keyring_file_data.result	731 B	-rw-r--r--

Code Editor : keyring_udf.result

call mtr.add_suppression("Error while fetching key: key_id cannot be empty");
call mtr.add_suppression("Error while removing key: key_id cannot be empty");
call mtr.add_suppression("Error while generating key: invalid key_type");
call mtr.add_suppression("Error while generating key: key_id cannot be empty");
call mtr.add_suppression("Error while storing key: invalid key_type");
call mtr.add_suppression("Error while storing key: key_id cannot be empty");
# Check what happens when we have not yet loaded keyring_udf or keyring_file
create function keyring_key_store returns integer soname 'keyring_udf.so';
create function keyring_key_fetch returns string soname 'keyring_udf.so';
create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
create function keyring_key_remove returns integer soname 'keyring_udf.so';
create function keyring_key_generate returns integer soname 'keyring_udf.so';
select * from mysql.func where name like '%keyring%' order by name;
name	ret	dl	type
keyring_key_fetch	0	keyring_udf.so	function
keyring_key_generate	2	keyring_udf.so	function
keyring_key_length_fetch	2	keyring_udf.so	function
keyring_key_remove	2	keyring_udf.so	function
keyring_key_store	2	keyring_udf.so	function
keyring_key_type_fetch	0	keyring_udf.so	function
select keyring_key_generate('Rob_AES_128','AES',16);
ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_type_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_length_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_remove('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install
drop function keyring_key_store;
drop function keyring_key_fetch;
drop function keyring_key_type_fetch;
drop function keyring_key_length_fetch;
drop function keyring_key_remove;
drop function keyring_key_generate;
# Re-starting mysql server with keyring_file plugin.
# Check what happens when we have not yet loaded keyring_udf
create function keyring_key_store returns integer soname 'keyring_udf.so';
create function keyring_key_fetch returns string soname 'keyring_udf.so';
create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
create function keyring_key_remove returns integer soname 'keyring_udf.so';
create function keyring_key_generate returns integer soname 'keyring_udf.so';
select * from mysql.func where name like '%keyring%' order by name;
name	ret	dl	type
keyring_key_fetch	0	keyring_udf.so	function
keyring_key_generate	2	keyring_udf.so	function
keyring_key_length_fetch	2	keyring_udf.so	function
keyring_key_remove	2	keyring_udf.so	function
keyring_key_store	2	keyring_udf.so	function
keyring_key_type_fetch	0	keyring_udf.so	function
select keyring_key_generate('Rob_AES_128','AES',16);
ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_type_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_length_fetch('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_remove('Rob_AES_128');
ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install
drop function keyring_key_store;
drop function keyring_key_fetch;
drop function keyring_key_type_fetch;
drop function keyring_key_length_fetch;
drop function keyring_key_remove;
drop function keyring_key_generate;
INSTALL PLUGIN keyring_udf SONAME 'keyring_udf.so';
# Check if keys are available after server restart
create function keyring_key_store returns integer soname 'keyring_udf.so';
create function keyring_key_generate returns integer soname 'keyring_udf.so';
select keyring_key_generate('Rob_AES_128','AES',16);
keyring_key_generate('Rob_AES_128','AES',16)
1
select keyring_key_store('Rob_AES_128_store','AES',"0123456789012345");
keyring_key_store('Rob_AES_128_store','AES',"0123456789012345")
1
drop function keyring_key_generate;
drop function keyring_key_store;
# Re-starting mysql server with keyring_file plugin.
create function keyring_key_fetch returns string soname 'keyring_udf.so';
create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
create function keyring_key_remove returns integer soname 'keyring_udf.so';
select keyring_key_fetch('Rob_AES_128') into @x;
select LENGTH(@x);
LENGTH(@x)
16
select keyring_key_length_fetch('Rob_AES_128');
keyring_key_length_fetch('Rob_AES_128')
16
select keyring_key_type_fetch('Rob_AES_128');
keyring_key_type_fetch('Rob_AES_128')
AES
select keyring_key_remove('Rob_AES_128');
keyring_key_remove('Rob_AES_128')
1
select keyring_key_fetch('Rob_AES_128_store') into @x;
select LENGTH(@x);
LENGTH(@x)
16
select keyring_key_length_fetch('Rob_AES_128_store');
keyring_key_length_fetch('Rob_AES_128_store')
16
select keyring_key_type_fetch('Rob_AES_128_store');
keyring_key_type_fetch('Rob_AES_128_store')
AES
select keyring_key_remove('Rob_AES_128_store');
keyring_key_remove('Rob_AES_128_store')
1
drop function keyring_key_fetch;
drop function keyring_key_type_fetch;
drop function keyring_key_length_fetch;
drop function keyring_key_remove;
# Test cases for keyring_udf and keyring_file plugins loaded
create function keyring_key_fetch returns string soname 'keyring_udf.so';
create function keyring_key_type_fetch returns string soname 'keyring_udf.so';
create function keyring_key_length_fetch returns integer soname 'keyring_udf.so';
create function keyring_key_remove returns integer soname 'keyring_udf.so';
create function keyring_key_generate returns integer soname 'keyring_udf.so';
select keyring_key_fetch('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch in number of arguments to the function.
select keyring_key_type_fetch('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; Mismatch in number of arguments to the function.
select keyring_key_length_fetch('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; Mismatch in number of arguments to the function.
select keyring_key_remove('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_remove'; Mismatch in number of arguments to the function.
select keyring_key_generate('Key_1');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
select keyring_key_generate('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
select keyring_key_generate('Key_1','');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch in number of arguments to the function.
select keyring_key_fetch('Key_1',NULL);
ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch in number of arguments to the function.
select keyring_key_fetch(1);
ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_fetch(NULL);
ERROR HY000: Can't initialize function 'keyring_key_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_type_fetch(1);
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_type_fetch(NULL);
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_length_fetch(1);
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_length_fetch(NULL);
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_generate('Key_1','AES','123');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
select keyring_key_generate(NULL,'AES','123');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_generate('Key_1',NULL,'123');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key type.
select keyring_key_generate('Key_1','AES',NULL);
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. An integer argument is expected for key length.
select keyring_key_generate(NULL,NULL,NULL);
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_generate(1,'AES',123);
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_generate('Key_1',123,'123');
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key type.
select keyring_key_generate('Key_invalid_key_type',123,123);
ERROR HY000: Can't initialize function 'keyring_key_generate'; Mismatch encountered. A string argument is expected for key type.
select keyring_key_remove(1);
ERROR HY000: Can't initialize function 'keyring_key_remove'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_remove(NULL);
ERROR HY000: Can't initialize function 'keyring_key_remove'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_generate('Rob_AES_8196','AES',2049);
ERROR HY000: Can't initialize function 'keyring_key_generate'; The key is to long. The max length of the key is 2048
select PLUGIN_NAME,PLUGIN_AUTHOR from information_schema.plugins where PLUGIN_NAME like '%keyring%';
PLUGIN_NAME	PLUGIN_AUTHOR
keyring_file	Oracle Corporation
keyring_udf	Oracle Corporation
select keyring_key_generate('Rob_AES_128','AES',16);
keyring_key_generate('Rob_AES_128','AES',16)
1
select keyring_key_fetch('Rob_AES_128') into @x;
select LENGTH(@x);
LENGTH(@x)
16
select keyring_key_type_fetch('Rob_AES_128');
keyring_key_type_fetch('Rob_AES_128')
AES
select keyring_key_length_fetch('Rob_AES_128');
keyring_key_length_fetch('Rob_AES_128')
16
select keyring_key_remove('Rob_AES_128');
keyring_key_remove('Rob_AES_128')
1
select keyring_key_generate('Rob_AES_192','AES',24);
keyring_key_generate('Rob_AES_192','AES',24)
1
select keyring_key_fetch('Rob_AES_192') into @x;
select LENGTH(@x);
LENGTH(@x)
24
select keyring_key_type_fetch('Rob_AES_192');
keyring_key_type_fetch('Rob_AES_192')
AES
select keyring_key_length_fetch('Rob_AES_192');
keyring_key_length_fetch('Rob_AES_192')
24
select keyring_key_remove('Rob_AES_192');
keyring_key_remove('Rob_AES_192')
1
select keyring_key_generate('Rob_AES_256','AES',32);
keyring_key_generate('Rob_AES_256','AES',32)
1
select keyring_key_fetch('Rob_AES_256') into @x;
select LENGTH(@x);
LENGTH(@x)
32
select keyring_key_type_fetch('Rob_AES_256');
keyring_key_type_fetch('Rob_AES_256')
AES
select keyring_key_length_fetch('Rob_AES_256');
keyring_key_length_fetch('Rob_AES_256')
32
select keyring_key_remove('Rob_AES_256');
keyring_key_remove('Rob_AES_256')
1
select keyring_key_generate('Rob_RSA_1024','RSA',128);
keyring_key_generate('Rob_RSA_1024','RSA',128)
1
select keyring_key_fetch('Rob_RSA_1024') into @x;
select LENGTH(@x);
LENGTH(@x)
128
select keyring_key_type_fetch('Rob_RSA_1024');
keyring_key_type_fetch('Rob_RSA_1024')
RSA
select keyring_key_length_fetch('Rob_RSA_1024');
keyring_key_length_fetch('Rob_RSA_1024')
128
select keyring_key_remove('Rob_RSA_1024');
keyring_key_remove('Rob_RSA_1024')
1
select keyring_key_generate('Rob_RSA_2048','RSA',256);
keyring_key_generate('Rob_RSA_2048','RSA',256)
1
select keyring_key_fetch('Rob_RSA_2048') into @x;
select keyring_key_type_fetch('Rob_RSA_2048');
keyring_key_type_fetch('Rob_RSA_2048')
RSA
select keyring_key_length_fetch('Rob_RSA_2048');
keyring_key_length_fetch('Rob_RSA_2048')
256
select LENGTH(@x);
LENGTH(@x)
256
select keyring_key_remove('Rob_RSA_2048');
keyring_key_remove('Rob_RSA_2048')
1
select keyring_key_generate('Rob_RSA_4096','RSA',512);
keyring_key_generate('Rob_RSA_4096','RSA',512)
1
select keyring_key_fetch('Rob_RSA_4096') into @x;
select keyring_key_type_fetch('Rob_RSA_4096');
keyring_key_type_fetch('Rob_RSA_4096')
RSA
select keyring_key_length_fetch('Rob_RSA_4096');
keyring_key_length_fetch('Rob_RSA_4096')
512
select LENGTH(@x);
LENGTH(@x)
512
select keyring_key_remove('Rob_RSA_4096');
keyring_key_remove('Rob_RSA_4096')
1
select keyring_key_generate('Rob_DSA_1024','DSA',128);
keyring_key_generate('Rob_DSA_1024','DSA',128)
1
select keyring_key_fetch('Rob_DSA_1024') into @x;
select LENGTH(@x);
LENGTH(@x)
128
select keyring_key_type_fetch('Rob_DSA_1024');
keyring_key_type_fetch('Rob_DSA_1024')
DSA
select keyring_key_length_fetch('Rob_DSA_1024');
keyring_key_length_fetch('Rob_DSA_1024')
128
select keyring_key_remove('Rob_DSA_1024');
keyring_key_remove('Rob_DSA_1024')
1
select keyring_key_generate('Rob_DSA_2048','DSA',256);
keyring_key_generate('Rob_DSA_2048','DSA',256)
1
select keyring_key_fetch('Rob_DSA_2048') into @x;
select LENGTH(@x);
LENGTH(@x)
256
select keyring_key_type_fetch('Rob_DSA_2048');
keyring_key_type_fetch('Rob_DSA_2048')
DSA
select keyring_key_length_fetch('Rob_DSA_2048');
keyring_key_length_fetch('Rob_DSA_2048')
256
select keyring_key_remove('Rob_DSA_2048');
keyring_key_remove('Rob_DSA_2048')
1
select keyring_key_generate('Rob_DSA_3072','DSA',384);
keyring_key_generate('Rob_DSA_3072','DSA',384)
1
select keyring_key_fetch('Rob_DSA_3072') into @x;
select LENGTH(@x);
LENGTH(@x)
384
select keyring_key_type_fetch('Rob_DSA_3072');
keyring_key_type_fetch('Rob_DSA_3072')
DSA
select keyring_key_length_fetch('Rob_DSA_3072');
keyring_key_length_fetch('Rob_DSA_3072')
384
select keyring_key_remove('Rob_DSA_3072');
keyring_key_remove('Rob_DSA_3072')
1
select keyring_key_fetch('key') into @x;
select @x;
@x
NULL
select keyring_key_type_fetch('key') into @x;
select @x;
@x
NULL
select keyring_key_length_fetch('key') into @x;
select @x;
@x
NULL
#Testing with AES_ENCRYPT/AES_DECRYPT
select keyring_key_generate('AES_128','AES',16);
keyring_key_generate('AES_128','AES',16)
1
select AES_ENCRYPT('secret message', keyring_key_fetch('AES_128')) into @cipher;
select AES_DECRYPT(@cipher, keyring_key_fetch('AES_128'));
AES_DECRYPT(@cipher, keyring_key_fetch('AES_128'))
secret message
select keyring_key_remove('AES_128');
keyring_key_remove('AES_128')
1
select keyring_key_fetch('Rob1');
keyring_key_fetch('Rob1')
NULL
select keyring_key_type_fetch('Rob1');
keyring_key_type_fetch('Rob1')
NULL
select keyring_key_length_fetch('Rob1');
keyring_key_length_fetch('Rob1')
NULL
select keyring_key_fetch('') into @x;
ERROR HY000: Function 'keyring_key_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_length_fetch('') into @x;
ERROR HY000: Function 'keyring_key_length_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_type_fetch('') into @x;
ERROR HY000: Function 'keyring_key_type_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_remove('Rob_not_existing') into @x;
ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_remove('') into @x;
ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_generate('Wrong_type','xxx', 16) into @x;
ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_generate('','AES', 16) into @x;
ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
# Testing privileges
select keyring_key_generate('roots_key', 'AES',16);
keyring_key_generate('roots_key', 'AES',16)
1
create definer=root@localhost procedure shared_key() select keyring_key_fetch('roots_key');
CREATE USER user_execute_test@localhost;
select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
ERROR HY000: Can't initialize function 'keyring_key_generate'; The user is not privileged to execute this function. User needs to have EXECUTE 
GRANT EXECUTE ON *.* TO 'user_execute_test'@'localhost';
select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
keyring_key_generate('Rob_DSA_no_privilege','DSA',384)
1
select keyring_key_generate('another_Rob_DSA_no_privilege','DSA',384);
keyring_key_generate('another_Rob_DSA_no_privilege','DSA',384)
1
#Check if user you can access another user's keys
select keyring_key_remove('roots_key');
ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
#Check that the user is able to access the key via procedure
call shared_key();
keyring_key_fetch('roots_key')
#
DROP PROCEDURE shared_key;
#Check if a user can create a key with id that already exist but belongs
#to another user.
select keyring_key_generate('Rob_DSA_no_privilege','DSA',384);
keyring_key_generate('Rob_DSA_no_privilege','DSA',384)
1
#Check if user with larger privileges can access another user's key
select keyring_key_remove('another_Rob_DSA_no_privilege');
ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
#Cleanup
select keyring_key_remove('Rob_DSA_no_privilege');
keyring_key_remove('Rob_DSA_no_privilege')
1
select keyring_key_remove('roots_key');
keyring_key_remove('roots_key')
1
select keyring_key_remove('Rob_DSA_no_privilege');
keyring_key_remove('Rob_DSA_no_privilege')
1
select keyring_key_remove('another_Rob_DSA_no_privilege');
keyring_key_remove('another_Rob_DSA_no_privilege')
1
DROP USER 'user_execute_test'@'localhost';
create function keyring_key_store returns integer soname 'keyring_udf.so';
select keyring_key_store('Key_1');
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch in number of arguments to the function.
select keyring_key_store('Key_1','AES');
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch in number of arguments to the function.
select keyring_key_store('Key_1','AES',123);
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key.
select keyring_key_store(NULL,'AES',123);
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_store('Key_1',NULL,123);
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key type.
select keyring_key_store('Key_1','AES',NULL);
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key.
select keyring_key_store(NULL,NULL,NULL);
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_store(1234,NULL,'53247@#$%^');
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_store(1,'AES','123');
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key id.
select keyring_key_store('Key_1',123,'123');
ERROR HY000: Can't initialize function 'keyring_key_store'; Mismatch encountered. A string argument is expected for key type.
select keyring_key_store('Rob_AES_128','AES',"0123456789012345");
keyring_key_store('Rob_AES_128','AES',"0123456789012345")
1
select keyring_key_fetch('Rob_AES_128') into @x;
select LENGTH(@x);
LENGTH(@x)
16
select keyring_key_type_fetch('Rob_AES_128');
keyring_key_type_fetch('Rob_AES_128')
AES
select keyring_key_length_fetch('Rob_AES_128');
keyring_key_length_fetch('Rob_AES_128')
16
select keyring_key_remove('Rob_AES_128');
keyring_key_remove('Rob_AES_128')
1
select keyring_key_store('Rob_AES_192','AES',"012345678901234567890%@3");
keyring_key_store('Rob_AES_192','AES',"012345678901234567890%@3")
1
select keyring_key_fetch('Rob_AES_192') into @x;
select LENGTH(@x);
LENGTH(@x)
24
select keyring_key_type_fetch('Rob_AES_192');
keyring_key_type_fetch('Rob_AES_192')
AES
select keyring_key_length_fetch('Rob_AES_192');
keyring_key_length_fetch('Rob_AES_192')
24
select keyring_key_remove('Rob_AES_192');
keyring_key_remove('Rob_AES_192')
1
select keyring_key_store('Rob_AES_256','AES',"01234567890123456789012345678901");
keyring_key_store('Rob_AES_256','AES',"01234567890123456789012345678901")
1
select keyring_key_fetch('Rob_AES_256') into @x;
select LENGTH(@x);
LENGTH(@x)
32
select keyring_key_type_fetch('Rob_AES_256');
keyring_key_type_fetch('Rob_AES_256')
AES
select keyring_key_length_fetch('Rob_AES_256');
keyring_key_length_fetch('Rob_AES_256')
32
select keyring_key_remove('Rob_AES_256');
keyring_key_remove('Rob_AES_256')
1
select keyring_key_store('Rob_RSA_1024','RSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123");
keyring_key_store('Rob_RSA_1024','RSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123")
1
select keyring_key_fetch('Rob_RSA_1024') into @x;
select LENGTH(@x);
LENGTH(@x)
128
select keyring_key_type_fetch('Rob_RSA_1024');
keyring_key_type_fetch('Rob_RSA_1024')
RSA
select keyring_key_length_fetch('Rob_RSA_1024');
keyring_key_length_fetch('Rob_RSA_1024')
128
select keyring_key_remove('Rob_RSA_1024');
keyring_key_remove('Rob_RSA_1024')
1
select keyring_key_store('Rob_DSA_1024','DSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123");
keyring_key_store('Rob_DSA_1024','DSA',"01234567890123456789012345678901234567890123456789012345678901230123456789012345678901234567890123456789012345678901234567890123")
1
select keyring_key_fetch('Rob_DSA_1024') into @x;
select LENGTH(@x);
LENGTH(@x)
128
select keyring_key_type_fetch('Rob_DSA_1024');
keyring_key_type_fetch('Rob_DSA_1024')
DSA
select keyring_key_length_fetch('Rob_DSA_1024');
keyring_key_length_fetch('Rob_DSA_1024')
128
select keyring_key_remove('Rob_DSA_1024');
keyring_key_remove('Rob_DSA_1024')
1
select keyring_key_store('Wrong_type','xxx', '0123456789012345') into @x;
ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_store('','AES', '0123456789012345') into @x;
ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select @x;
@x
NULL
select keyring_key_generate('Rob_AES_512','AES',64);
keyring_key_generate('Rob_AES_512','AES',64)
1
set @x= keyring_key_fetch('Rob_AES_512');
select LENGTH(@x);
LENGTH(@x)
64
select keyring_key_type_fetch('Rob_AES_512');
keyring_key_type_fetch('Rob_AES_512')
AES
select keyring_key_length_fetch('Rob_AES_512');
keyring_key_length_fetch('Rob_AES_512')
64
select keyring_key_remove('Rob_AES_512');
keyring_key_remove('Rob_AES_512')
1
select keyring_key_store('Rob_AES_512','AES',"0123456789012345678901234567890123456789012345678901234567890123");
keyring_key_store('Rob_AES_512','AES',"0123456789012345678901234567890123456789012345678901234567890123")
1
set @x= keyring_key_fetch('Rob_AES_512');
select LENGTH(@x);
LENGTH(@x)
64
select keyring_key_type_fetch('Rob_AES_512');
keyring_key_type_fetch('Rob_AES_512')
AES
select keyring_key_length_fetch('Rob_AES_512');
keyring_key_length_fetch('Rob_AES_512')
64
select keyring_key_remove('Rob_AES_512');
keyring_key_remove('Rob_AES_512')
1
select keyring_key_generate('Rob_DSA_4096','DSA',512);
keyring_key_generate('Rob_DSA_4096','DSA',512)
1
set @x= keyring_key_fetch('Rob_DSA_4096');
select LENGTH(@x);
LENGTH(@x)
512
select keyring_key_type_fetch('Rob_DSA_4096');
keyring_key_type_fetch('Rob_DSA_4096')
DSA
select keyring_key_length_fetch('Rob_DSA_4096');
keyring_key_length_fetch('Rob_DSA_4096')
512
select keyring_key_remove('Rob_DSA_4096');
keyring_key_remove('Rob_DSA_4096')
1
UNINSTALL PLUGIN keyring_file;
# Test cases for keyring_udf loaded and keyring_file plugin not loaded
#The keyring plugin was uninstalled, the keyring_udf functions should fail with
#appropriate error message
select keyring_key_store('Rob_uninstalled','AES','123');
ERROR HY000: Function 'keyring_key_store' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select keyring_key_fetch('Rob_uninstalled');
ERROR HY000: Function 'keyring_key_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select keyring_key_type_fetch('Rob_uninstalled');
ERROR HY000: Function 'keyring_key_type_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select keyring_key_length_fetch('Rob_uninstalled');
ERROR HY000: Function 'keyring_key_length_fetch' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select keyring_key_remove('Rob_uninstalled');
ERROR HY000: Function 'keyring_key_remove' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
select keyring_key_generate('Rob_uninstalled_generate','DSA',128);
ERROR HY000: Function 'keyring_key_generate' failed because underlying keyring service returned an error. Please check if a keyring plugin is installed and that provided arguments are valid for the keyring you are using.
INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
UNINSTALL PLUGIN keyring_udf;
# Test cases for keyring_udf not loaded and keyring_file plugin loaded
select keyring_key_store('Rob_uninstalled','AES','123');
ERROR HY000: Can't initialize function 'keyring_key_store'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_fetch('Rob_uninstalled');
ERROR HY000: Can't initialize function 'keyring_key_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_type_fetch('Rob_uninstalled');
ERROR HY000: Can't initialize function 'keyring_key_type_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_length_fetch('Rob_uninstalled');
ERROR HY000: Can't initialize function 'keyring_key_length_fetch'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_remove('Rob_uninstalled');
ERROR HY000: Can't initialize function 'keyring_key_remove'; This function requires keyring_udf plugin which is not installed. Please install
select keyring_key_generate('Rob_uninstalled_generate','DSA',128);
ERROR HY000: Can't initialize function 'keyring_key_generate'; This function requires keyring_udf plugin which is not installed. Please install
drop function keyring_key_store;
drop function keyring_key_fetch;
drop function keyring_key_remove;
drop function keyring_key_generate;
drop function keyring_key_type_fetch;
drop function keyring_key_length_fetch;

${this.title}

Code Editor : keyring_udf.result