mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
199 lines
6 KiB
Text
199 lines
6 KiB
Text
flush status;
|
|
flush hosts;
|
|
flush user_resources;
|
|
flush privileges;
|
|
select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like '192.%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like '2001:%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
|
|
User Host
|
|
CREATE USER 'plug'@'santa.claus.ipv6.example.com'
|
|
IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
|
|
CREATE USER 'plug_dest'@'santa.claus.ipv6.example.com'
|
|
IDENTIFIED BY 'plug_test_passwd';
|
|
GRANT SELECT ON test.* TO 'plug_dest'@'santa.claus.ipv6.example.com';
|
|
connect con1,"::1",root,,test,$MASTER_MYPORT,;
|
|
select "Con1 is alive";
|
|
Con1 is alive
|
|
Con1 is alive
|
|
select current_user();
|
|
current_user()
|
|
root@localhost
|
|
disconnect con1;
|
|
connection default;
|
|
SET @saved_dbug = @@GLOBAL.debug_dbug;
|
|
set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
|
|
uninstall plugin test_plugin_server;
|
|
ERROR HY000: Plugin 'test_plugin_server' is not loaded
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 2001:db8::6:6
|
|
HOST santa.claus.ipv6.example.com
|
|
HOST_VALIDATED YES
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 0
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 0
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 1
|
|
COUNT_AUTH_PLUGIN_ERRORS 1
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 0
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
ERROR HY000: Plugin 'test_plugin_server' is not loaded
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 2001:db8::6:6
|
|
HOST santa.claus.ipv6.example.com
|
|
HOST_VALIDATED YES
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 0
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 0
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 0
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
install plugin test_plugin_server soname 'PLUGIN_AUTH';
|
|
ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 2001:db8::6:6
|
|
HOST santa.claus.ipv6.example.com
|
|
HOST_VALIDATED YES
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 0
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 0
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 1
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 2001:db8::6:6
|
|
HOST santa.claus.ipv6.example.com
|
|
HOST_VALIDATED YES
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 0
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 0
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 2
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
GRANT PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
|
|
TO 'plug'@'santa.claus.ipv6.example.com';
|
|
connect con4,"::1",plug,plug_dest,test,$MASTER_MYPORT,,,auth_test_plugin;
|
|
select "Con4 is alive";
|
|
Con4 is alive
|
|
Con4 is alive
|
|
select user();
|
|
user()
|
|
plug@santa.claus.ipv6.example.com
|
|
select current_user();
|
|
current_user()
|
|
plug_dest@santa.claus.ipv6.example.com
|
|
disconnect con4;
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 2001:db8::6:6
|
|
HOST santa.claus.ipv6.example.com
|
|
HOST_VALIDATED YES
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 0
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 0
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_AUTH_PLUGIN_ERRORS 2
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 2
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
REVOKE ALL PRIVILEGES ON *.* FROM 'plug_dest'@'santa.claus.ipv6.example.com';
|
|
REVOKE PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
|
|
FROM 'plug'@'santa.claus.ipv6.example.com';
|
|
DROP USER 'plug'@'santa.claus.ipv6.example.com';
|
|
DROP USER 'plug_dest'@'santa.claus.ipv6.example.com';
|
|
SET @@GLOBAL.debug_dbug = @saved_dbug;
|
|
delete from mysql.plugin where name='test_plugin_server';
|