mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
56 lines
1.7 KiB
Text
56 lines
1.7 KiB
Text
#
|
|
# Tests for the performance_schema host_cache.
|
|
#
|
|
# Test authorization with auth plugins.
|
|
# error reporting in:
|
|
# - column COUNT_AUTH_PLUGIN_ERRORS
|
|
# - column COUNT_PROXY_USER_ERRORS
|
|
# - column COUNT_PROXY_USER_ACL_ERRORS
|
|
|
|
source include/not_embedded.inc;
|
|
source include/have_debug.inc;
|
|
source include/have_perfschema.inc;
|
|
source include/have_plugin_auth.inc;
|
|
source include/have_hostname_cache.inc;
|
|
|
|
if (!$AUTH_ED25519_SO) {
|
|
skip No auth_ed25519 plugin;
|
|
}
|
|
install soname 'auth_ed25519';
|
|
|
|
# Enforce a clean state
|
|
source ../include/wait_for_pfs_thread_count.inc;
|
|
source ../include/hostcache_set_state.inc;
|
|
|
|
create user plug1@'santa.claus.ipv4.example.com'
|
|
identified with ed25519;
|
|
update mysql.global_priv set priv=json_set(priv, '$.authentication_string', 'foo') where user='plug1';
|
|
flush privileges;
|
|
|
|
create user plug2@'santa.claus.ipv4.example.com'
|
|
identified with ED25519 as 'vubFBzIrapbfHct1/J72dnUryz5VS7lA6XHH8sIx4TI';
|
|
|
|
set @saved_dbug = @@global.debug_dbug;
|
|
set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
|
|
|
|
replace_result $MASTER_MYPORT PORT $MASTER_MYSOCK SOCKET;
|
|
error ER_ACCESS_DENIED_ERROR;
|
|
connect con1, 127.0.0.1, plug1,foo,,$MASTER_MYPORT;
|
|
source ../include/hostcache_dump.inc;
|
|
|
|
replace_result $MASTER_MYPORT PORT $MASTER_MYSOCK SOCKET;
|
|
error ER_ACCESS_DENIED_ERROR;
|
|
connect con1, 127.0.0.1, plug2,bar,,$MASTER_MYPORT;
|
|
source ../include/hostcache_dump.inc;
|
|
|
|
connect con1, 127.0.0.1, plug2,foo,,$MASTER_MYPORT;
|
|
select current_user();
|
|
disconnect con1;
|
|
connection default;
|
|
source ../include/hostcache_dump.inc;
|
|
|
|
drop user plug1@'santa.claus.ipv4.example.com';
|
|
drop user plug2@'santa.claus.ipv4.example.com';
|
|
|
|
set @@global.debug_dbug = @saved_dbug;
|
|
uninstall plugin ed25519;
|