mirror of
https://github.com/MariaDB/server.git
synced 2025-02-14 09:25:35 +01:00
0a0dfd63d9
SQL service added. It provides the limited set of client library functions to be used by plugin.
77 lines
3.4 KiB
Text
77 lines
3.4 KiB
Text
create function ed25519_password returns string soname "auth_ed25519.so";
|
|
select ed25519_password();
|
|
ERROR HY000: Can't initialize function 'ed25519_password'; Wrong arguments to ed25519_password()
|
|
select ed25519_password(1);
|
|
ERROR HY000: Can't initialize function 'ed25519_password'; Wrong arguments to ed25519_password()
|
|
select ed25519_password("foo", "bar");
|
|
ERROR HY000: Can't initialize function 'ed25519_password'; Wrong arguments to ed25519_password()
|
|
select ed25519_password("foo");
|
|
ERROR HY000: Can't initialize function 'ed25519_password'; Authentication plugin ed25519 is not loaded
|
|
install soname 'auth_ed25519';
|
|
select ed25519_password("foo");
|
|
ed25519_password("foo")
|
|
vubFBzIrapbfHct1/J72dnUryz5VS7lA6XHH8sIx4TI
|
|
select ed25519_password("foobar");
|
|
ed25519_password("foobar")
|
|
qv2mG6HWCuy32Slb5xhV4THStewNz2VINVPbgk+XAJ8
|
|
select ed25519_password("foo bar");
|
|
ed25519_password("foo bar")
|
|
Y5fV74JAVRMOK2cdnUsYS+WW9sXaaL/o+6WGKOgqnzc
|
|
select ed25519_password(NULL);
|
|
ed25519_password(NULL)
|
|
NULL
|
|
select * from information_schema.plugins where plugin_name='ed25519';
|
|
PLUGIN_NAME ed25519
|
|
PLUGIN_VERSION 1.1
|
|
PLUGIN_STATUS ACTIVE
|
|
PLUGIN_TYPE AUTHENTICATION
|
|
PLUGIN_TYPE_VERSION 2.2
|
|
PLUGIN_LIBRARY auth_ed25519.so
|
|
PLUGIN_LIBRARY_VERSION 1.15
|
|
PLUGIN_AUTHOR Sergei Golubchik
|
|
PLUGIN_DESCRIPTION Elliptic curve ED25519 based authentication
|
|
PLUGIN_LICENSE GPL
|
|
LOAD_OPTION ON
|
|
PLUGIN_MATURITY Stable
|
|
PLUGIN_AUTH_VERSION 1.1
|
|
create user test1@localhost identified via ed25519 using 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY';
|
|
show grants for test1@localhost;
|
|
Grants for test1@localhost
|
|
GRANT USAGE ON *.* TO `test1`@`localhost` IDENTIFIED VIA ed25519 USING 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY'
|
|
drop user test1@localhost;
|
|
create user test1@localhost identified via ed25519 using 'foo';
|
|
ERROR HY000: Password hash should be 43 characters long
|
|
create user test1@localhost identified via ed25519 using '>>>1234567890123456789012345678901234567890';
|
|
ERROR HY000: Password hash should be base64 encoded
|
|
create user test1@localhost identified via ed25519 using password('foo');
|
|
show grants for test1@localhost;
|
|
Grants for test1@localhost
|
|
GRANT USAGE ON *.* TO `test1`@`localhost` IDENTIFIED VIA ed25519 USING 'vubFBzIrapbfHct1/J72dnUryz5VS7lA6XHH8sIx4TI'
|
|
select ed25519_password('foo');
|
|
ed25519_password('foo')
|
|
vubFBzIrapbfHct1/J72dnUryz5VS7lA6XHH8sIx4TI
|
|
set password for test1@localhost = password('bar');
|
|
show create user test1@localhost;
|
|
CREATE USER for test1@localhost
|
|
CREATE USER `test1`@`localhost` IDENTIFIED VIA ed25519 USING 'pfzkeWMzkTefY1oshXS+/kATeN51M+4jxi3/cbyTd10'
|
|
select ed25519_password('bar');
|
|
ed25519_password('bar')
|
|
pfzkeWMzkTefY1oshXS+/kATeN51M+4jxi3/cbyTd10
|
|
set password for test1@localhost = 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY';
|
|
show create user test1@localhost;
|
|
CREATE USER for test1@localhost
|
|
CREATE USER `test1`@`localhost` IDENTIFIED VIA ed25519 USING 'ZIgUREUg5PVgQ6LskhXmO+eZLS0nC8be6HPjYWR4YJY'
|
|
connect(localhost,test1,public,test,PORT,SOCKET);
|
|
connect con1, localhost, test1, public;
|
|
ERROR 28000: Access denied for user 'test1'@'localhost' (using password: YES)
|
|
connect con1, localhost, test1, secret;
|
|
select current_user();
|
|
current_user()
|
|
test1@localhost
|
|
disconnect con1;
|
|
connection default;
|
|
drop user test1@localhost;
|
|
uninstall plugin ed25519;
|
|
select ed25519_password("foo");
|
|
ERROR HY000: Can't initialize function 'ed25519_password'; Authentication plugin ed25519 is not loaded
|
|
drop function ed25519_password;
|