Debian Codegraph @

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

raw
1 call mtr.add_suppression("2001:db8::6:6");
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_error_again";
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 NO
31 SUM_CONNECT_ERRORS 0
32 COUNT_HOST_BLOCKED_ERRORS 0
33 COUNT_NAMEINFO_TRANSIENT_ERRORS 1
34 COUNT_NAMEINFO_PERMANENT_ERRORS 0
35 COUNT_FORMAT_ERRORS 0
36 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
37 COUNT_ADDRINFO_PERMANENT_ERRORS 0
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 NO
61 SUM_CONNECT_ERRORS 0
62 COUNT_HOST_BLOCKED_ERRORS 0
63 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
64 COUNT_NAMEINFO_PERMANENT_ERRORS 0
65 COUNT_FORMAT_ERRORS 0
66 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
67 COUNT_ADDRINFO_PERMANENT_ERRORS 0
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= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
86 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MariaDB server
87 connection default;
88 # Dumping performance_schema.host_cache
89 IP 2001:db8::6:6
90 HOST santa.claus.ipv6.example.com
91 HOST_VALIDATED YES
92 SUM_CONNECT_ERRORS 0
93 COUNT_HOST_BLOCKED_ERRORS 0
94 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
95 COUNT_NAMEINFO_PERMANENT_ERRORS 0
96 COUNT_FORMAT_ERRORS 0
97 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
98 COUNT_ADDRINFO_PERMANENT_ERRORS 0
99 COUNT_FCRDNS_ERRORS 0
100 COUNT_HOST_ACL_ERRORS 3
101 COUNT_NO_AUTH_PLUGIN_ERRORS 0
102 COUNT_AUTH_PLUGIN_ERRORS 0
103 COUNT_HANDSHAKE_ERRORS 0
104 COUNT_PROXY_USER_ERRORS 0
105 COUNT_PROXY_USER_ACL_ERRORS 0
106 COUNT_AUTHENTICATION_ERRORS 0
107 COUNT_SSL_ERRORS 0
108 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
109 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
110 COUNT_DEFAULT_DATABASE_ERRORS 0
111 COUNT_INIT_CONNECT_ERRORS 0
112 COUNT_LOCAL_ERRORS 0
113 COUNT_UNKNOWN_ERRORS 0
114 FIRST_ERROR_SEEN set
115 LAST_ERROR_SEEN set
116 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MariaDB server
117 connection default;
118 # Dumping performance_schema.host_cache
119 IP 2001:db8::6:6
120 HOST santa.claus.ipv6.example.com
121 HOST_VALIDATED YES
122 SUM_CONNECT_ERRORS 0
123 COUNT_HOST_BLOCKED_ERRORS 0
124 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
125 COUNT_NAMEINFO_PERMANENT_ERRORS 0
126 COUNT_FORMAT_ERRORS 0
127 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
128 COUNT_ADDRINFO_PERMANENT_ERRORS 0
129 COUNT_FCRDNS_ERRORS 0
130 COUNT_HOST_ACL_ERRORS 4
131 COUNT_NO_AUTH_PLUGIN_ERRORS 0
132 COUNT_AUTH_PLUGIN_ERRORS 0
133 COUNT_HANDSHAKE_ERRORS 0
134 COUNT_PROXY_USER_ERRORS 0
135 COUNT_PROXY_USER_ACL_ERRORS 0
136 COUNT_AUTHENTICATION_ERRORS 0
137 COUNT_SSL_ERRORS 0
138 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
139 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
140 COUNT_DEFAULT_DATABASE_ERRORS 0
141 COUNT_INIT_CONNECT_ERRORS 0
142 COUNT_LOCAL_ERRORS 0
143 COUNT_UNKNOWN_ERRORS 0
144 FIRST_ERROR_SEEN set
145 LAST_ERROR_SEEN set
146 SET @@GLOBAL.debug_dbug = @saved_dbug;