Debian Codegraph @

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

raw
1 flush status;
2 TRUNCATE TABLE performance_schema.host_cache;
3 flush user_resources;
4 flush privileges;
5 select @@global.debug;
6 @@global.debug
7
8 select @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 select @@global.max_user_connections;
12 @@global.max_user_connections
13 0
14 select @@global.max_connections;
15 @@global.max_connections
16 151
17 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
18 User Host
19 select `User`, `Host` from mysql.`user` where `user` like '192.%';
20 User Host
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 User Host
23 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
24 User Host
25 CREATE USER 'plug'@'santa.claus.ipv6.example.com'
26 IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
27 CREATE USER 'plug_dest'@'santa.claus.ipv6.example.com'
28 IDENTIFIED BY 'plug_test_passwd';
29 GRANT SELECT ON test.* TO 'plug_dest'@'santa.claus.ipv6.example.com';
30 select "Con1 is alive";
31 Con1 is alive
32 Con1 is alive
33 select current_user();
34 current_user()
35 root@localhost
36 set global debug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
37 uninstall plugin test_plugin_server;
38 ERROR HY000: Plugin 'test_plugin_server' is not loaded
39 "Dumping performance_schema.host_cache"
40 IP 2001:db8::6:6
41 HOST santa.claus.ipv6.example.com
42 HOST_VALIDATED YES
43 SUM_CONNECT_ERRORS 0
44 COUNT_HOST_BLOCKED_ERRORS 0
45 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
46 COUNT_NAMEINFO_PERMANENT_ERRORS 0
47 COUNT_FORMAT_ERRORS 0
48 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
49 COUNT_ADDRINFO_PERMANENT_ERRORS 0
50 COUNT_FCRDNS_ERRORS 0
51 COUNT_HOST_ACL_ERRORS 0
52 COUNT_NO_AUTH_PLUGIN_ERRORS 1
53 COUNT_AUTH_PLUGIN_ERRORS 1
54 COUNT_HANDSHAKE_ERRORS 0
55 COUNT_PROXY_USER_ERRORS 0
56 COUNT_PROXY_USER_ACL_ERRORS 0
57 COUNT_AUTHENTICATION_ERRORS 0
58 COUNT_SSL_ERRORS 0
59 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
60 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
61 COUNT_DEFAULT_DATABASE_ERRORS 0
62 COUNT_INIT_CONNECT_ERRORS 0
63 COUNT_LOCAL_ERRORS 0
64 COUNT_UNKNOWN_ERRORS 0
65 FIRST_ERROR_SEEN set
66 LAST_ERROR_SEEN set
67 ERROR HY000: Plugin 'test_plugin_server' is not loaded
68 "Dumping performance_schema.host_cache"
69 IP 2001:db8::6:6
70 HOST santa.claus.ipv6.example.com
71 HOST_VALIDATED YES
72 SUM_CONNECT_ERRORS 0
73 COUNT_HOST_BLOCKED_ERRORS 0
74 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
75 COUNT_NAMEINFO_PERMANENT_ERRORS 0
76 COUNT_FORMAT_ERRORS 0
77 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
78 COUNT_ADDRINFO_PERMANENT_ERRORS 0
79 COUNT_FCRDNS_ERRORS 0
80 COUNT_HOST_ACL_ERRORS 0
81 COUNT_NO_AUTH_PLUGIN_ERRORS 2
82 COUNT_AUTH_PLUGIN_ERRORS 2
83 COUNT_HANDSHAKE_ERRORS 0
84 COUNT_PROXY_USER_ERRORS 0
85 COUNT_PROXY_USER_ACL_ERRORS 0
86 COUNT_AUTHENTICATION_ERRORS 0
87 COUNT_SSL_ERRORS 0
88 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
89 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
90 COUNT_DEFAULT_DATABASE_ERRORS 0
91 COUNT_INIT_CONNECT_ERRORS 0
92 COUNT_LOCAL_ERRORS 0
93 COUNT_UNKNOWN_ERRORS 0
94 FIRST_ERROR_SEEN set
95 LAST_ERROR_SEEN set
96 install plugin test_plugin_server soname 'PLUGIN_AUTH';
97 ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
98 "Dumping performance_schema.host_cache"
99 IP 2001:db8::6:6
100 HOST santa.claus.ipv6.example.com
101 HOST_VALIDATED YES
102 SUM_CONNECT_ERRORS 0
103 COUNT_HOST_BLOCKED_ERRORS 0
104 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
105 COUNT_NAMEINFO_PERMANENT_ERRORS 0
106 COUNT_FORMAT_ERRORS 0
107 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
108 COUNT_ADDRINFO_PERMANENT_ERRORS 0
109 COUNT_FCRDNS_ERRORS 0
110 COUNT_HOST_ACL_ERRORS 0
111 COUNT_NO_AUTH_PLUGIN_ERRORS 2
112 COUNT_AUTH_PLUGIN_ERRORS 2
113 COUNT_HANDSHAKE_ERRORS 0
114 COUNT_PROXY_USER_ERRORS 1
115 COUNT_PROXY_USER_ACL_ERRORS 0
116 COUNT_AUTHENTICATION_ERRORS 0
117 COUNT_SSL_ERRORS 0
118 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
119 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
120 COUNT_DEFAULT_DATABASE_ERRORS 0
121 COUNT_INIT_CONNECT_ERRORS 0
122 COUNT_LOCAL_ERRORS 0
123 COUNT_UNKNOWN_ERRORS 0
124 FIRST_ERROR_SEEN set
125 LAST_ERROR_SEEN set
126 ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
127 "Dumping performance_schema.host_cache"
128 IP 2001:db8::6:6
129 HOST santa.claus.ipv6.example.com
130 HOST_VALIDATED YES
131 SUM_CONNECT_ERRORS 0
132 COUNT_HOST_BLOCKED_ERRORS 0
133 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
134 COUNT_NAMEINFO_PERMANENT_ERRORS 0
135 COUNT_FORMAT_ERRORS 0
136 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
137 COUNT_ADDRINFO_PERMANENT_ERRORS 0
138 COUNT_FCRDNS_ERRORS 0
139 COUNT_HOST_ACL_ERRORS 0
140 COUNT_NO_AUTH_PLUGIN_ERRORS 2
141 COUNT_AUTH_PLUGIN_ERRORS 2
142 COUNT_HANDSHAKE_ERRORS 0
143 COUNT_PROXY_USER_ERRORS 2
144 COUNT_PROXY_USER_ACL_ERRORS 0
145 COUNT_AUTHENTICATION_ERRORS 0
146 COUNT_SSL_ERRORS 0
147 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
148 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
149 COUNT_DEFAULT_DATABASE_ERRORS 0
150 COUNT_INIT_CONNECT_ERRORS 0
151 COUNT_LOCAL_ERRORS 0
152 COUNT_UNKNOWN_ERRORS 0
153 FIRST_ERROR_SEEN set
154 LAST_ERROR_SEEN set
155 GRANT PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
156 TO 'plug'@'santa.claus.ipv6.example.com';
157 select "Con4 is alive";
158 Con4 is alive
159 Con4 is alive
160 select user();
161 user()
162 [email protected]
163 select current_user();
164 current_user()
165 [email protected]
166 "Dumping performance_schema.host_cache"
167 IP 2001:db8::6:6
168 HOST santa.claus.ipv6.example.com
169 HOST_VALIDATED YES
170 SUM_CONNECT_ERRORS 0
171 COUNT_HOST_BLOCKED_ERRORS 0
172 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
173 COUNT_NAMEINFO_PERMANENT_ERRORS 0
174 COUNT_FORMAT_ERRORS 0
175 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
176 COUNT_ADDRINFO_PERMANENT_ERRORS 0
177 COUNT_FCRDNS_ERRORS 0
178 COUNT_HOST_ACL_ERRORS 0
179 COUNT_NO_AUTH_PLUGIN_ERRORS 2
180 COUNT_AUTH_PLUGIN_ERRORS 2
181 COUNT_HANDSHAKE_ERRORS 0
182 COUNT_PROXY_USER_ERRORS 2
183 COUNT_PROXY_USER_ACL_ERRORS 0
184 COUNT_AUTHENTICATION_ERRORS 0
185 COUNT_SSL_ERRORS 0
186 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
187 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
188 COUNT_DEFAULT_DATABASE_ERRORS 0
189 COUNT_INIT_CONNECT_ERRORS 0
190 COUNT_LOCAL_ERRORS 0
191 COUNT_UNKNOWN_ERRORS 0
192 FIRST_ERROR_SEEN set
193 LAST_ERROR_SEEN set
194 REVOKE ALL PRIVILEGES ON *.* FROM 'plug_dest'@'santa.claus.ipv6.example.com';
195 REVOKE PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
196 FROM 'plug'@'santa.claus.ipv6.example.com';
197 DROP USER 'plug'@'santa.claus.ipv6.example.com';
198 DROP USER 'plug_dest'@'santa.claus.ipv6.example.com';
199 set global debug= default;