Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv4_blocked.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 select @@global.max_connect_errors into @saved_max_connect_errors;
26 set global max_connect_errors = 3;
27 create user 'root'@'santa.claus.ipv4.example.com';
28 grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
29 create user 'quota'@'santa.claus.ipv4.example.com' identified with 'mysql_native_password';
30 grant select on test.* to 'quota'@'santa.claus.ipv4.example.com';
31 select "Con1 is alive";
32 Con1 is alive
33 Con1 is alive
34 select current_user();
35 current_user()
36 root@localhost
37 set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4,native_password_bad_reply";
38 ERROR 08S01: Bad handshake
39 "Dumping performance_schema.host_cache"
40 IP 192.0.2.4
41 HOST santa.claus.ipv4.example.com
42 HOST_VALIDATED YES
43 SUM_CONNECT_ERRORS 1
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 0
53 COUNT_AUTH_PLUGIN_ERRORS 0
54 COUNT_HANDSHAKE_ERRORS 1
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 08S01: Bad handshake
68 "Dumping performance_schema.host_cache"
69 IP 192.0.2.4
70 HOST santa.claus.ipv4.example.com
71 HOST_VALIDATED YES
72 SUM_CONNECT_ERRORS 2
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 0
82 COUNT_AUTH_PLUGIN_ERRORS 0
83 COUNT_HANDSHAKE_ERRORS 2
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 ERROR 08S01: Bad handshake
97 "Dumping performance_schema.host_cache"
98 IP 192.0.2.4
99 HOST santa.claus.ipv4.example.com
100 HOST_VALIDATED YES
101 SUM_CONNECT_ERRORS 3
102 COUNT_HOST_BLOCKED_ERRORS 0
103 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
104 COUNT_NAMEINFO_PERMANENT_ERRORS 0
105 COUNT_FORMAT_ERRORS 0
106 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
107 COUNT_ADDRINFO_PERMANENT_ERRORS 0
108 COUNT_FCRDNS_ERRORS 0
109 COUNT_HOST_ACL_ERRORS 0
110 COUNT_NO_AUTH_PLUGIN_ERRORS 0
111 COUNT_AUTH_PLUGIN_ERRORS 0
112 COUNT_HANDSHAKE_ERRORS 3
113 COUNT_PROXY_USER_ERRORS 0
114 COUNT_PROXY_USER_ACL_ERRORS 0
115 COUNT_AUTHENTICATION_ERRORS 0
116 COUNT_SSL_ERRORS 0
117 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
118 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
119 COUNT_DEFAULT_DATABASE_ERRORS 0
120 COUNT_INIT_CONNECT_ERRORS 0
121 COUNT_LOCAL_ERRORS 0
122 COUNT_UNKNOWN_ERRORS 0
123 FIRST_ERROR_SEEN set
124 LAST_ERROR_SEEN set
125 ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
126 "Dumping performance_schema.host_cache"
127 IP 192.0.2.4
128 HOST santa.claus.ipv4.example.com
129 HOST_VALIDATED YES
130 SUM_CONNECT_ERRORS 3
131 COUNT_HOST_BLOCKED_ERRORS 1
132 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
133 COUNT_NAMEINFO_PERMANENT_ERRORS 0
134 COUNT_FORMAT_ERRORS 0
135 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
136 COUNT_ADDRINFO_PERMANENT_ERRORS 0
137 COUNT_FCRDNS_ERRORS 0
138 COUNT_HOST_ACL_ERRORS 0
139 COUNT_NO_AUTH_PLUGIN_ERRORS 0
140 COUNT_AUTH_PLUGIN_ERRORS 0
141 COUNT_HANDSHAKE_ERRORS 3
142 COUNT_PROXY_USER_ERRORS 0
143 COUNT_PROXY_USER_ACL_ERRORS 0
144 COUNT_AUTHENTICATION_ERRORS 0
145 COUNT_SSL_ERRORS 0
146 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
147 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
148 COUNT_DEFAULT_DATABASE_ERRORS 0
149 COUNT_INIT_CONNECT_ERRORS 0
150 COUNT_LOCAL_ERRORS 0
151 COUNT_UNKNOWN_ERRORS 0
152 FIRST_ERROR_SEEN set
153 LAST_ERROR_SEEN set
154 ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
155 "Dumping performance_schema.host_cache"
156 IP 192.0.2.4
157 HOST santa.claus.ipv4.example.com
158 HOST_VALIDATED YES
159 SUM_CONNECT_ERRORS 3
160 COUNT_HOST_BLOCKED_ERRORS 2
161 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
162 COUNT_NAMEINFO_PERMANENT_ERRORS 0
163 COUNT_FORMAT_ERRORS 0
164 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
165 COUNT_ADDRINFO_PERMANENT_ERRORS 0
166 COUNT_FCRDNS_ERRORS 0
167 COUNT_HOST_ACL_ERRORS 0
168 COUNT_NO_AUTH_PLUGIN_ERRORS 0
169 COUNT_AUTH_PLUGIN_ERRORS 0
170 COUNT_HANDSHAKE_ERRORS 3
171 COUNT_PROXY_USER_ERRORS 0
172 COUNT_PROXY_USER_ACL_ERRORS 0
173 COUNT_AUTHENTICATION_ERRORS 0
174 COUNT_SSL_ERRORS 0
175 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
176 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
177 COUNT_DEFAULT_DATABASE_ERRORS 0
178 COUNT_INIT_CONNECT_ERRORS 0
179 COUNT_LOCAL_ERRORS 0
180 COUNT_UNKNOWN_ERRORS 0
181 FIRST_ERROR_SEEN set
182 LAST_ERROR_SEEN set
183 TRUNCATE TABLE performance_schema.host_cache;
184 ERROR 08S01: Bad handshake
185 "Dumping performance_schema.host_cache"
186 IP 192.0.2.4
187 HOST santa.claus.ipv4.example.com
188 HOST_VALIDATED YES
189 SUM_CONNECT_ERRORS 1
190 COUNT_HOST_BLOCKED_ERRORS 0
191 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
192 COUNT_NAMEINFO_PERMANENT_ERRORS 0
193 COUNT_FORMAT_ERRORS 0
194 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
195 COUNT_ADDRINFO_PERMANENT_ERRORS 0
196 COUNT_FCRDNS_ERRORS 0
197 COUNT_HOST_ACL_ERRORS 0
198 COUNT_NO_AUTH_PLUGIN_ERRORS 0
199 COUNT_AUTH_PLUGIN_ERRORS 0
200 COUNT_HANDSHAKE_ERRORS 1
201 COUNT_PROXY_USER_ERRORS 0
202 COUNT_PROXY_USER_ACL_ERRORS 0
203 COUNT_AUTHENTICATION_ERRORS 0
204 COUNT_SSL_ERRORS 0
205 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
206 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
207 COUNT_DEFAULT_DATABASE_ERRORS 0
208 COUNT_INIT_CONNECT_ERRORS 0
209 COUNT_LOCAL_ERRORS 0
210 COUNT_UNKNOWN_ERRORS 0
211 FIRST_ERROR_SEEN set
212 LAST_ERROR_SEEN set
213 ERROR 08S01: Bad handshake
214 "Dumping performance_schema.host_cache"
215 IP 192.0.2.4
216 HOST santa.claus.ipv4.example.com
217 HOST_VALIDATED YES
218 SUM_CONNECT_ERRORS 2
219 COUNT_HOST_BLOCKED_ERRORS 0
220 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
221 COUNT_NAMEINFO_PERMANENT_ERRORS 0
222 COUNT_FORMAT_ERRORS 0
223 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
224 COUNT_ADDRINFO_PERMANENT_ERRORS 0
225 COUNT_FCRDNS_ERRORS 0
226 COUNT_HOST_ACL_ERRORS 0
227 COUNT_NO_AUTH_PLUGIN_ERRORS 0
228 COUNT_AUTH_PLUGIN_ERRORS 0
229 COUNT_HANDSHAKE_ERRORS 2
230 COUNT_PROXY_USER_ERRORS 0
231 COUNT_PROXY_USER_ACL_ERRORS 0
232 COUNT_AUTHENTICATION_ERRORS 0
233 COUNT_SSL_ERRORS 0
234 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
235 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
236 COUNT_DEFAULT_DATABASE_ERRORS 0
237 COUNT_INIT_CONNECT_ERRORS 0
238 COUNT_LOCAL_ERRORS 0
239 COUNT_UNKNOWN_ERRORS 0
240 FIRST_ERROR_SEEN set
241 LAST_ERROR_SEEN set
242 set global debug= "-d,native_password_bad_reply";
243 message
244 Valid connection should reset SUM_CONNECT_ERROR counter
245 set global debug= "+d,native_password_bad_reply";
246 "Dumping performance_schema.host_cache"
247 IP 192.0.2.4
248 HOST santa.claus.ipv4.example.com
249 HOST_VALIDATED YES
250 SUM_CONNECT_ERRORS 0
251 COUNT_HOST_BLOCKED_ERRORS 0
252 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
253 COUNT_NAMEINFO_PERMANENT_ERRORS 0
254 COUNT_FORMAT_ERRORS 0
255 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
256 COUNT_ADDRINFO_PERMANENT_ERRORS 0
257 COUNT_FCRDNS_ERRORS 0
258 COUNT_HOST_ACL_ERRORS 0
259 COUNT_NO_AUTH_PLUGIN_ERRORS 0
260 COUNT_AUTH_PLUGIN_ERRORS 0
261 COUNT_HANDSHAKE_ERRORS 2
262 COUNT_PROXY_USER_ERRORS 0
263 COUNT_PROXY_USER_ACL_ERRORS 0
264 COUNT_AUTHENTICATION_ERRORS 0
265 COUNT_SSL_ERRORS 0
266 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
267 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
268 COUNT_DEFAULT_DATABASE_ERRORS 0
269 COUNT_INIT_CONNECT_ERRORS 0
270 COUNT_LOCAL_ERRORS 0
271 COUNT_UNKNOWN_ERRORS 0
272 FIRST_ERROR_SEEN set
273 LAST_ERROR_SEEN set
274 ERROR 08S01: Bad handshake
275 "Dumping performance_schema.host_cache"
276 IP 192.0.2.4
277 HOST santa.claus.ipv4.example.com
278 HOST_VALIDATED YES
279 SUM_CONNECT_ERRORS 1
280 COUNT_HOST_BLOCKED_ERRORS 0
281 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
282 COUNT_NAMEINFO_PERMANENT_ERRORS 0
283 COUNT_FORMAT_ERRORS 0
284 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
285 COUNT_ADDRINFO_PERMANENT_ERRORS 0
286 COUNT_FCRDNS_ERRORS 0
287 COUNT_HOST_ACL_ERRORS 0
288 COUNT_NO_AUTH_PLUGIN_ERRORS 0
289 COUNT_AUTH_PLUGIN_ERRORS 0
290 COUNT_HANDSHAKE_ERRORS 3
291 COUNT_PROXY_USER_ERRORS 0
292 COUNT_PROXY_USER_ACL_ERRORS 0
293 COUNT_AUTHENTICATION_ERRORS 0
294 COUNT_SSL_ERRORS 0
295 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
296 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
297 COUNT_DEFAULT_DATABASE_ERRORS 0
298 COUNT_INIT_CONNECT_ERRORS 0
299 COUNT_LOCAL_ERRORS 0
300 COUNT_UNKNOWN_ERRORS 0
301 FIRST_ERROR_SEEN set
302 LAST_ERROR_SEEN set
303 ERROR 08S01: Bad handshake
304 "Dumping performance_schema.host_cache"
305 IP 192.0.2.4
306 HOST santa.claus.ipv4.example.com
307 HOST_VALIDATED YES
308 SUM_CONNECT_ERRORS 2
309 COUNT_HOST_BLOCKED_ERRORS 0
310 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
311 COUNT_NAMEINFO_PERMANENT_ERRORS 0
312 COUNT_FORMAT_ERRORS 0
313 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
314 COUNT_ADDRINFO_PERMANENT_ERRORS 0
315 COUNT_FCRDNS_ERRORS 0
316 COUNT_HOST_ACL_ERRORS 0
317 COUNT_NO_AUTH_PLUGIN_ERRORS 0
318 COUNT_AUTH_PLUGIN_ERRORS 0
319 COUNT_HANDSHAKE_ERRORS 4
320 COUNT_PROXY_USER_ERRORS 0
321 COUNT_PROXY_USER_ACL_ERRORS 0
322 COUNT_AUTHENTICATION_ERRORS 0
323 COUNT_SSL_ERRORS 0
324 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
325 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
326 COUNT_DEFAULT_DATABASE_ERRORS 0
327 COUNT_INIT_CONNECT_ERRORS 0
328 COUNT_LOCAL_ERRORS 0
329 COUNT_UNKNOWN_ERRORS 0
330 FIRST_ERROR_SEEN set
331 LAST_ERROR_SEEN set
332 ERROR 08S01: Bad handshake
333 "Dumping performance_schema.host_cache"
334 IP 192.0.2.4
335 HOST santa.claus.ipv4.example.com
336 HOST_VALIDATED YES
337 SUM_CONNECT_ERRORS 3
338 COUNT_HOST_BLOCKED_ERRORS 0
339 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
340 COUNT_NAMEINFO_PERMANENT_ERRORS 0
341 COUNT_FORMAT_ERRORS 0
342 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
343 COUNT_ADDRINFO_PERMANENT_ERRORS 0
344 COUNT_FCRDNS_ERRORS 0
345 COUNT_HOST_ACL_ERRORS 0
346 COUNT_NO_AUTH_PLUGIN_ERRORS 0
347 COUNT_AUTH_PLUGIN_ERRORS 0
348 COUNT_HANDSHAKE_ERRORS 5
349 COUNT_PROXY_USER_ERRORS 0
350 COUNT_PROXY_USER_ACL_ERRORS 0
351 COUNT_AUTHENTICATION_ERRORS 0
352 COUNT_SSL_ERRORS 0
353 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
354 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
355 COUNT_DEFAULT_DATABASE_ERRORS 0
356 COUNT_INIT_CONNECT_ERRORS 0
357 COUNT_LOCAL_ERRORS 0
358 COUNT_UNKNOWN_ERRORS 0
359 FIRST_ERROR_SEEN set
360 LAST_ERROR_SEEN set
361 ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
362 "Dumping performance_schema.host_cache"
363 IP 192.0.2.4
364 HOST santa.claus.ipv4.example.com
365 HOST_VALIDATED YES
366 SUM_CONNECT_ERRORS 3
367 COUNT_HOST_BLOCKED_ERRORS 1
368 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
369 COUNT_NAMEINFO_PERMANENT_ERRORS 0
370 COUNT_FORMAT_ERRORS 0
371 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
372 COUNT_ADDRINFO_PERMANENT_ERRORS 0
373 COUNT_FCRDNS_ERRORS 0
374 COUNT_HOST_ACL_ERRORS 0
375 COUNT_NO_AUTH_PLUGIN_ERRORS 0
376 COUNT_AUTH_PLUGIN_ERRORS 0
377 COUNT_HANDSHAKE_ERRORS 5
378 COUNT_PROXY_USER_ERRORS 0
379 COUNT_PROXY_USER_ACL_ERRORS 0
380 COUNT_AUTHENTICATION_ERRORS 0
381 COUNT_SSL_ERRORS 0
382 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
383 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
384 COUNT_DEFAULT_DATABASE_ERRORS 0
385 COUNT_INIT_CONNECT_ERRORS 0
386 COUNT_LOCAL_ERRORS 0
387 COUNT_UNKNOWN_ERRORS 0
388 FIRST_ERROR_SEEN set
389 LAST_ERROR_SEEN set
390 ERROR HY000: Host '192.0.2.4' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
391 "Dumping performance_schema.host_cache"
392 IP 192.0.2.4
393 HOST santa.claus.ipv4.example.com
394 HOST_VALIDATED YES
395 SUM_CONNECT_ERRORS 3
396 COUNT_HOST_BLOCKED_ERRORS 2
397 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
398 COUNT_NAMEINFO_PERMANENT_ERRORS 0
399 COUNT_FORMAT_ERRORS 0
400 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
401 COUNT_ADDRINFO_PERMANENT_ERRORS 0
402 COUNT_FCRDNS_ERRORS 0
403 COUNT_HOST_ACL_ERRORS 0
404 COUNT_NO_AUTH_PLUGIN_ERRORS 0
405 COUNT_AUTH_PLUGIN_ERRORS 0
406 COUNT_HANDSHAKE_ERRORS 5
407 COUNT_PROXY_USER_ERRORS 0
408 COUNT_PROXY_USER_ACL_ERRORS 0
409 COUNT_AUTHENTICATION_ERRORS 0
410 COUNT_SSL_ERRORS 0
411 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
412 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
413 COUNT_DEFAULT_DATABASE_ERRORS 0
414 COUNT_INIT_CONNECT_ERRORS 0
415 COUNT_LOCAL_ERRORS 0
416 COUNT_UNKNOWN_ERRORS 0
417 FIRST_ERROR_SEEN set
418 LAST_ERROR_SEEN set
419 revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
420 drop user 'root'@'santa.claus.ipv4.example.com';
421 revoke select on test.* from 'quota'@'santa.claus.ipv4.example.com';
422 drop user 'quota'@'santa.claus.ipv4.example.com';
423 set global max_connect_errors = @saved_max_connect_errors;
424 set global debug= default;