1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
#
# MDEV-12160 Modern alternative to the SHA1 authentication plugin
#
source include/not_embedded.inc;
if (!$AUTH_ED25519_SO) {
skip No auth_ed25519 plugin;
}
replace_result dll so;
eval create function ed25519_password returns string soname "$AUTH_ED25519_SO";
error ER_CANT_INITIALIZE_UDF;
select ed25519_password();
error ER_CANT_INITIALIZE_UDF;
select ed25519_password(1);
error ER_CANT_INITIALIZE_UDF;
select ed25519_password("foo", "bar");
error ER_CANT_INITIALIZE_UDF;
select ed25519_password("foo");
install soname 'auth_ed25519';
select ed25519_password("foo");
select ed25519_password("foobar");
select ed25519_password("foo bar");
select ed25519_password(NULL);
replace_result dll so;
query_vertical select * from information_schema.plugins where plugin_name='ed25519';
let $pwd=`select ed25519_password("secret")`;
eval create user test1@localhost identified via ed25519 using '$pwd';
show grants for test1@localhost;
drop user test1@localhost;
--error ER_PASSWD_LENGTH
create user test1@localhost identified via ed25519 using 'foo';
--error ER_PASSWD_LENGTH
create user test1@localhost identified via ed25519 using '>>>1234567890123456789012345678901234567890';
create user test1@localhost identified via ed25519 using password('foo');
show grants for test1@localhost;
select ed25519_password('foo');
set password for test1@localhost = password('bar');
show create user test1@localhost;
select ed25519_password('bar');
eval set password for test1@localhost = '$pwd';
show create user test1@localhost;
replace_result $MASTER_MYPORT PORT $MASTER_MYSOCK SOCKET;
error ER_ACCESS_DENIED_ERROR;
connect con1, localhost, test1, public;
connect con1, localhost, test1, secret;
select current_user();
disconnect con1;
connection default;
create user test2@localhost identified via ed25519 using PASSWORD('');
show grants for test2@localhost;
connect con2, localhost, test2,;
select current_user();
disconnect con2;
replace_result $MASTER_MYSOCK MASTER_MYSOCK $MASTER_MYPORT MASTER_MYPORT;
error ER_ACCESS_DENIED_ERROR;
connect con3, localhost, test2, "wrong_pwd";
connection default;
drop user test2@localhost;
drop user test1@localhost;
uninstall plugin ed25519;
error ER_CANT_INITIALIZE_UDF;
select ed25519_password("foo");
drop function ed25519_password;
|
