Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result

raw
1 install soname 'auth_ed25519';
2 flush global status;
3 flush hosts;
4 flush user_resources;
5 flush privileges;
6 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
7 User Host
8 select `User`, `Host` from mysql.`user` where `user` like '192.%';
9 User Host
10 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
11 User Host
12 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
13 User Host
14 create user plug1@'santa.claus.ipv4.example.com'
15 identified with ed25519;
16 update mysql.global_priv set priv=json_set(priv, '$.authentication_string', 'foo') where user='plug1';
17 flush privileges;
18 create user plug2@'santa.claus.ipv4.example.com'
19 identified with ED25519 as 'vubFBzIrapbfHct1/J72dnUryz5VS7lA6XHH8sIx4TI';
20 set @saved_dbug = @@global.debug_dbug;
21 set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
22 connect(127.0.0.1,plug1,foo,test,PORT,SOCKET);
23 connect con1, 127.0.0.1, plug1,foo,,$MASTER_MYPORT;
24 ERROR 28000: Access denied for user 'plug1'@'santa.claus.ipv4.example.com' (using password: YES)
25 # Dumping performance_schema.host_cache
26 IP 192.0.2.4
27 HOST santa.claus.ipv4.example.com
28 HOST_VALIDATED YES
29 SUM_CONNECT_ERRORS 1
30 COUNT_HOST_BLOCKED_ERRORS 0
31 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
32 COUNT_NAMEINFO_PERMANENT_ERRORS 0
33 COUNT_FORMAT_ERRORS 0
34 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
35 COUNT_ADDRINFO_PERMANENT_ERRORS 0
36 COUNT_FCRDNS_ERRORS 0
37 COUNT_HOST_ACL_ERRORS 0
38 COUNT_NO_AUTH_PLUGIN_ERRORS 0
39 COUNT_AUTH_PLUGIN_ERRORS 0
40 COUNT_HANDSHAKE_ERRORS 1
41 COUNT_PROXY_USER_ERRORS 0
42 COUNT_PROXY_USER_ACL_ERRORS 0
43 COUNT_AUTHENTICATION_ERRORS 0
44 COUNT_SSL_ERRORS 0
45 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
46 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
47 COUNT_DEFAULT_DATABASE_ERRORS 0
48 COUNT_INIT_CONNECT_ERRORS 0
49 COUNT_LOCAL_ERRORS 0
50 COUNT_UNKNOWN_ERRORS 0
51 FIRST_ERROR_SEEN set
52 LAST_ERROR_SEEN set
53 connect(127.0.0.1,plug2,bar,test,PORT,SOCKET);
54 connect con1, 127.0.0.1, plug2,bar,,$MASTER_MYPORT;
55 ERROR 28000: Access denied for user 'plug2'@'santa.claus.ipv4.example.com' (using password: YES)
56 # Dumping performance_schema.host_cache
57 IP 192.0.2.4
58 HOST santa.claus.ipv4.example.com
59 HOST_VALIDATED YES
60 SUM_CONNECT_ERRORS 1
61 COUNT_HOST_BLOCKED_ERRORS 0
62 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
63 COUNT_NAMEINFO_PERMANENT_ERRORS 0
64 COUNT_FORMAT_ERRORS 0
65 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
66 COUNT_ADDRINFO_PERMANENT_ERRORS 0
67 COUNT_FCRDNS_ERRORS 0
68 COUNT_HOST_ACL_ERRORS 0
69 COUNT_NO_AUTH_PLUGIN_ERRORS 0
70 COUNT_AUTH_PLUGIN_ERRORS 0
71 COUNT_HANDSHAKE_ERRORS 1
72 COUNT_PROXY_USER_ERRORS 0
73 COUNT_PROXY_USER_ACL_ERRORS 0
74 COUNT_AUTHENTICATION_ERRORS 1
75 COUNT_SSL_ERRORS 0
76 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
77 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
78 COUNT_DEFAULT_DATABASE_ERRORS 0
79 COUNT_INIT_CONNECT_ERRORS 0
80 COUNT_LOCAL_ERRORS 0
81 COUNT_UNKNOWN_ERRORS 0
82 FIRST_ERROR_SEEN set
83 LAST_ERROR_SEEN set
84 connect con1, 127.0.0.1, plug2,foo,,$MASTER_MYPORT;
85 select current_user();
86 current_user()
87 [email protected]
88 disconnect con1;
89 connection default;
90 # Dumping performance_schema.host_cache
91 IP 192.0.2.4
92 HOST santa.claus.ipv4.example.com
93 HOST_VALIDATED YES
94 SUM_CONNECT_ERRORS 0
95 COUNT_HOST_BLOCKED_ERRORS 0
96 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
97 COUNT_NAMEINFO_PERMANENT_ERRORS 0
98 COUNT_FORMAT_ERRORS 0
99 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
100 COUNT_ADDRINFO_PERMANENT_ERRORS 0
101 COUNT_FCRDNS_ERRORS 0
102 COUNT_HOST_ACL_ERRORS 0
103 COUNT_NO_AUTH_PLUGIN_ERRORS 0
104 COUNT_AUTH_PLUGIN_ERRORS 0
105 COUNT_HANDSHAKE_ERRORS 1
106 COUNT_PROXY_USER_ERRORS 0
107 COUNT_PROXY_USER_ACL_ERRORS 0
108 COUNT_AUTHENTICATION_ERRORS 1
109 COUNT_SSL_ERRORS 0
110 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
111 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
112 COUNT_DEFAULT_DATABASE_ERRORS 0
113 COUNT_INIT_CONNECT_ERRORS 0
114 COUNT_LOCAL_ERRORS 0
115 COUNT_UNKNOWN_ERRORS 0
116 FIRST_ERROR_SEEN set
117 LAST_ERROR_SEEN set
118 drop user plug1@'santa.claus.ipv4.example.com';
119 drop user plug2@'santa.claus.ipv4.example.com';
120 set @@global.debug_dbug = @saved_dbug;
121 uninstall plugin ed25519;