Debian Codegraph @

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

raw
1 call mtr.add_suppression("santa.claus.ipv6.example.com");
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 connect con1,"::1",root,,test,$MASTER_MYPORT,;
15 select "Con1 is alive";
16 Con1 is alive
17 Con1 is alive
18 select current_user();
19 current_user()
20 root@localhost
21 disconnect con1;
22 connection default;
23 SET @saved_dbug = @@GLOBAL.debug_dbug;
24 set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_error_noname";
25 ERROR HY000: Host '2001:db8::6:6' is not allowed to connect to this MariaDB server
26 connection default;
27 # Dumping performance_schema.host_cache
28 IP 2001:db8::6:6
29 HOST NULL
30 HOST_VALIDATED YES
31 SUM_CONNECT_ERRORS 0
32 COUNT_HOST_BLOCKED_ERRORS 0
33 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
34 COUNT_NAMEINFO_PERMANENT_ERRORS 0
35 COUNT_FORMAT_ERRORS 0
36 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
37 COUNT_ADDRINFO_PERMANENT_ERRORS 1
38 COUNT_FCRDNS_ERRORS 0
39 COUNT_HOST_ACL_ERRORS 1
40 COUNT_NO_AUTH_PLUGIN_ERRORS 0
41 COUNT_AUTH_PLUGIN_ERRORS 0
42 COUNT_HANDSHAKE_ERRORS 0
43 COUNT_PROXY_USER_ERRORS 0
44 COUNT_PROXY_USER_ACL_ERRORS 0
45 COUNT_AUTHENTICATION_ERRORS 0
46 COUNT_SSL_ERRORS 0
47 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
48 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
49 COUNT_DEFAULT_DATABASE_ERRORS 0
50 COUNT_INIT_CONNECT_ERRORS 0
51 COUNT_LOCAL_ERRORS 0
52 COUNT_UNKNOWN_ERRORS 0
53 FIRST_ERROR_SEEN set
54 LAST_ERROR_SEEN set
55 ERROR HY000: Host '2001:db8::6:6' is not allowed to connect to this MariaDB server
56 connection default;
57 # Dumping performance_schema.host_cache
58 IP 2001:db8::6:6
59 HOST NULL
60 HOST_VALIDATED YES
61 SUM_CONNECT_ERRORS 0
62 COUNT_HOST_BLOCKED_ERRORS 0
63 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
64 COUNT_NAMEINFO_PERMANENT_ERRORS 0
65 COUNT_FORMAT_ERRORS 0
66 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
67 COUNT_ADDRINFO_PERMANENT_ERRORS 1
68 COUNT_FCRDNS_ERRORS 0
69 COUNT_HOST_ACL_ERRORS 2
70 COUNT_NO_AUTH_PLUGIN_ERRORS 0
71 COUNT_AUTH_PLUGIN_ERRORS 0
72 COUNT_HANDSHAKE_ERRORS 0
73 COUNT_PROXY_USER_ERRORS 0
74 COUNT_PROXY_USER_ACL_ERRORS 0
75 COUNT_AUTHENTICATION_ERRORS 0
76 COUNT_SSL_ERRORS 0
77 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
78 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
79 COUNT_DEFAULT_DATABASE_ERRORS 0
80 COUNT_INIT_CONNECT_ERRORS 0
81 COUNT_LOCAL_ERRORS 0
82 COUNT_UNKNOWN_ERRORS 0
83 FIRST_ERROR_SEEN set
84 LAST_ERROR_SEEN set
85 SET @@GLOBAL.debug_dbug = @saved_dbug;