Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv6_passwd.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 'user_without'@'santa.claus.ipv6.example.com';
26 create user 'user_with'@'santa.claus.ipv6.example.com'
27 identified by 'good_password';
28 grant select on test.* to 'user_without'@'santa.claus.ipv6.example.com';
29 grant select on test.* to 'user_with'@'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 ERROR 28000: Access denied for user 'user_without'@'santa.claus.ipv6.example.com' (using password: YES)
38 "Dumping performance_schema.host_cache"
39 IP 2001:db8::6:6
40 HOST santa.claus.ipv6.example.com
41 HOST_VALIDATED YES
42 SUM_CONNECT_ERRORS 0
43 COUNT_HOST_BLOCKED_ERRORS 0
44 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
45 COUNT_NAMEINFO_PERMANENT_ERRORS 0
46 COUNT_FORMAT_ERRORS 0
47 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
48 COUNT_ADDRINFO_PERMANENT_ERRORS 0
49 COUNT_FCRDNS_ERRORS 0
50 COUNT_HOST_ACL_ERRORS 0
51 COUNT_NO_AUTH_PLUGIN_ERRORS 0
52 COUNT_AUTH_PLUGIN_ERRORS 0
53 COUNT_HANDSHAKE_ERRORS 0
54 COUNT_PROXY_USER_ERRORS 0
55 COUNT_PROXY_USER_ACL_ERRORS 0
56 COUNT_AUTHENTICATION_ERRORS 1
57 COUNT_SSL_ERRORS 0
58 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
59 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
60 COUNT_DEFAULT_DATABASE_ERRORS 0
61 COUNT_INIT_CONNECT_ERRORS 0
62 COUNT_LOCAL_ERRORS 0
63 COUNT_UNKNOWN_ERRORS 0
64 FIRST_ERROR_SEEN set
65 LAST_ERROR_SEEN set
66 ERROR 28000: Access denied for user 'user_without'@'santa.claus.ipv6.example.com' (using password: YES)
67 "Dumping performance_schema.host_cache"
68 IP 2001:db8::6:6
69 HOST santa.claus.ipv6.example.com
70 HOST_VALIDATED YES
71 SUM_CONNECT_ERRORS 0
72 COUNT_HOST_BLOCKED_ERRORS 0
73 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
74 COUNT_NAMEINFO_PERMANENT_ERRORS 0
75 COUNT_FORMAT_ERRORS 0
76 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
77 COUNT_ADDRINFO_PERMANENT_ERRORS 0
78 COUNT_FCRDNS_ERRORS 0
79 COUNT_HOST_ACL_ERRORS 0
80 COUNT_NO_AUTH_PLUGIN_ERRORS 0
81 COUNT_AUTH_PLUGIN_ERRORS 0
82 COUNT_HANDSHAKE_ERRORS 0
83 COUNT_PROXY_USER_ERRORS 0
84 COUNT_PROXY_USER_ACL_ERRORS 0
85 COUNT_AUTHENTICATION_ERRORS 2
86 COUNT_SSL_ERRORS 0
87 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
88 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
89 COUNT_DEFAULT_DATABASE_ERRORS 0
90 COUNT_INIT_CONNECT_ERRORS 0
91 COUNT_LOCAL_ERRORS 0
92 COUNT_UNKNOWN_ERRORS 0
93 FIRST_ERROR_SEEN set
94 LAST_ERROR_SEEN set
95 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: NO)
96 "Dumping performance_schema.host_cache"
97 IP 2001:db8::6:6
98 HOST santa.claus.ipv6.example.com
99 HOST_VALIDATED YES
100 SUM_CONNECT_ERRORS 0
101 COUNT_HOST_BLOCKED_ERRORS 0
102 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
103 COUNT_NAMEINFO_PERMANENT_ERRORS 0
104 COUNT_FORMAT_ERRORS 0
105 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
106 COUNT_ADDRINFO_PERMANENT_ERRORS 0
107 COUNT_FCRDNS_ERRORS 0
108 COUNT_HOST_ACL_ERRORS 0
109 COUNT_NO_AUTH_PLUGIN_ERRORS 0
110 COUNT_AUTH_PLUGIN_ERRORS 0
111 COUNT_HANDSHAKE_ERRORS 0
112 COUNT_PROXY_USER_ERRORS 0
113 COUNT_PROXY_USER_ACL_ERRORS 0
114 COUNT_AUTHENTICATION_ERRORS 3
115 COUNT_SSL_ERRORS 0
116 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
117 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
118 COUNT_DEFAULT_DATABASE_ERRORS 0
119 COUNT_INIT_CONNECT_ERRORS 0
120 COUNT_LOCAL_ERRORS 0
121 COUNT_UNKNOWN_ERRORS 0
122 FIRST_ERROR_SEEN set
123 LAST_ERROR_SEEN set
124 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: NO)
125 "Dumping performance_schema.host_cache"
126 IP 2001:db8::6:6
127 HOST santa.claus.ipv6.example.com
128 HOST_VALIDATED YES
129 SUM_CONNECT_ERRORS 0
130 COUNT_HOST_BLOCKED_ERRORS 0
131 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
132 COUNT_NAMEINFO_PERMANENT_ERRORS 0
133 COUNT_FORMAT_ERRORS 0
134 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
135 COUNT_ADDRINFO_PERMANENT_ERRORS 0
136 COUNT_FCRDNS_ERRORS 0
137 COUNT_HOST_ACL_ERRORS 0
138 COUNT_NO_AUTH_PLUGIN_ERRORS 0
139 COUNT_AUTH_PLUGIN_ERRORS 0
140 COUNT_HANDSHAKE_ERRORS 0
141 COUNT_PROXY_USER_ERRORS 0
142 COUNT_PROXY_USER_ACL_ERRORS 0
143 COUNT_AUTHENTICATION_ERRORS 4
144 COUNT_SSL_ERRORS 0
145 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
146 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
147 COUNT_DEFAULT_DATABASE_ERRORS 0
148 COUNT_INIT_CONNECT_ERRORS 0
149 COUNT_LOCAL_ERRORS 0
150 COUNT_UNKNOWN_ERRORS 0
151 FIRST_ERROR_SEEN set
152 LAST_ERROR_SEEN set
153 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: YES)
154 "Dumping performance_schema.host_cache"
155 IP 2001:db8::6:6
156 HOST santa.claus.ipv6.example.com
157 HOST_VALIDATED YES
158 SUM_CONNECT_ERRORS 0
159 COUNT_HOST_BLOCKED_ERRORS 0
160 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
161 COUNT_NAMEINFO_PERMANENT_ERRORS 0
162 COUNT_FORMAT_ERRORS 0
163 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
164 COUNT_ADDRINFO_PERMANENT_ERRORS 0
165 COUNT_FCRDNS_ERRORS 0
166 COUNT_HOST_ACL_ERRORS 0
167 COUNT_NO_AUTH_PLUGIN_ERRORS 0
168 COUNT_AUTH_PLUGIN_ERRORS 0
169 COUNT_HANDSHAKE_ERRORS 0
170 COUNT_PROXY_USER_ERRORS 0
171 COUNT_PROXY_USER_ACL_ERRORS 0
172 COUNT_AUTHENTICATION_ERRORS 5
173 COUNT_SSL_ERRORS 0
174 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
175 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
176 COUNT_DEFAULT_DATABASE_ERRORS 0
177 COUNT_INIT_CONNECT_ERRORS 0
178 COUNT_LOCAL_ERRORS 0
179 COUNT_UNKNOWN_ERRORS 0
180 FIRST_ERROR_SEEN set
181 LAST_ERROR_SEEN set
182 ERROR 28000: Access denied for user 'user_with'@'santa.claus.ipv6.example.com' (using password: YES)
183 "Dumping performance_schema.host_cache"
184 IP 2001:db8::6:6
185 HOST santa.claus.ipv6.example.com
186 HOST_VALIDATED YES
187 SUM_CONNECT_ERRORS 0
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 0
199 COUNT_PROXY_USER_ERRORS 0
200 COUNT_PROXY_USER_ACL_ERRORS 0
201 COUNT_AUTHENTICATION_ERRORS 6
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 drop user 'user_with'@'santa.claus.ipv6.example.com';
212 drop user 'user_without'@'santa.claus.ipv6.example.com';
213 set global debug= default;