Debian Codegraph @

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

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