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 status;
3 TRUNCATE TABLE performance_schema.host_cache;
4 flush user_resources;
5 flush privileges;
6 select @@global.debug;
7 @@global.debug
8
9 select @@global.max_connect_errors;
10 @@global.max_connect_errors
11 100
12 select @@global.max_user_connections;
13 @@global.max_user_connections
14 0
15 select @@global.max_connections;
16 @@global.max_connections
17 151
18 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
19 User Host
20 select `User`, `Host` from mysql.`user` where `user` like '192.%';
21 User Host
22 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
23 User Host
24 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
25 User Host
26 select "Con1 is alive";
27 Con1 is alive
28 Con1 is alive
29 select current_user();
30 current_user()
31 root@localhost
32 set global debug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_error_again";
33 ERROR HY000: Host '2001:db8::6:6' is not allowed to connect to this MySQL server
34 "Dumping performance_schema.host_cache"
35 IP 2001:db8::6:6
36 HOST NULL
37 HOST_VALIDATED NO
38 SUM_CONNECT_ERRORS 0
39 COUNT_HOST_BLOCKED_ERRORS 0
40 COUNT_NAMEINFO_TRANSIENT_ERRORS 1
41 COUNT_NAMEINFO_PERMANENT_ERRORS 0
42 COUNT_FORMAT_ERRORS 0
43 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
44 COUNT_ADDRINFO_PERMANENT_ERRORS 0
45 COUNT_FCRDNS_ERRORS 0
46 COUNT_HOST_ACL_ERRORS 1
47 COUNT_NO_AUTH_PLUGIN_ERRORS 0
48 COUNT_AUTH_PLUGIN_ERRORS 0
49 COUNT_HANDSHAKE_ERRORS 0
50 COUNT_PROXY_USER_ERRORS 0
51 COUNT_PROXY_USER_ACL_ERRORS 0
52 COUNT_AUTHENTICATION_ERRORS 0
53 COUNT_SSL_ERRORS 0
54 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
55 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
56 COUNT_DEFAULT_DATABASE_ERRORS 0
57 COUNT_INIT_CONNECT_ERRORS 0
58 COUNT_LOCAL_ERRORS 0
59 COUNT_UNKNOWN_ERRORS 0
60 FIRST_ERROR_SEEN set
61 LAST_ERROR_SEEN set
62 ERROR HY000: Host '2001:db8::6:6' is not allowed to connect to this MySQL server
63 "Dumping performance_schema.host_cache"
64 IP 2001:db8::6:6
65 HOST NULL
66 HOST_VALIDATED NO
67 SUM_CONNECT_ERRORS 0
68 COUNT_HOST_BLOCKED_ERRORS 0
69 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
70 COUNT_NAMEINFO_PERMANENT_ERRORS 0
71 COUNT_FORMAT_ERRORS 0
72 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
73 COUNT_ADDRINFO_PERMANENT_ERRORS 0
74 COUNT_FCRDNS_ERRORS 0
75 COUNT_HOST_ACL_ERRORS 2
76 COUNT_NO_AUTH_PLUGIN_ERRORS 0
77 COUNT_AUTH_PLUGIN_ERRORS 0
78 COUNT_HANDSHAKE_ERRORS 0
79 COUNT_PROXY_USER_ERRORS 0
80 COUNT_PROXY_USER_ACL_ERRORS 0
81 COUNT_AUTHENTICATION_ERRORS 0
82 COUNT_SSL_ERRORS 0
83 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
84 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
85 COUNT_DEFAULT_DATABASE_ERRORS 0
86 COUNT_INIT_CONNECT_ERRORS 0
87 COUNT_LOCAL_ERRORS 0
88 COUNT_UNKNOWN_ERRORS 0
89 FIRST_ERROR_SEEN set
90 LAST_ERROR_SEEN set
91 set global debug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
92 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MySQL server
93 "Dumping performance_schema.host_cache"
94 IP 2001:db8::6:6
95 HOST santa.claus.ipv6.example.com
96 HOST_VALIDATED YES
97 SUM_CONNECT_ERRORS 0
98 COUNT_HOST_BLOCKED_ERRORS 0
99 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
100 COUNT_NAMEINFO_PERMANENT_ERRORS 0
101 COUNT_FORMAT_ERRORS 0
102 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
103 COUNT_ADDRINFO_PERMANENT_ERRORS 0
104 COUNT_FCRDNS_ERRORS 0
105 COUNT_HOST_ACL_ERRORS 3
106 COUNT_NO_AUTH_PLUGIN_ERRORS 0
107 COUNT_AUTH_PLUGIN_ERRORS 0
108 COUNT_HANDSHAKE_ERRORS 0
109 COUNT_PROXY_USER_ERRORS 0
110 COUNT_PROXY_USER_ACL_ERRORS 0
111 COUNT_AUTHENTICATION_ERRORS 0
112 COUNT_SSL_ERRORS 0
113 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
114 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
115 COUNT_DEFAULT_DATABASE_ERRORS 0
116 COUNT_INIT_CONNECT_ERRORS 0
117 COUNT_LOCAL_ERRORS 0
118 COUNT_UNKNOWN_ERRORS 0
119 FIRST_ERROR_SEEN set
120 LAST_ERROR_SEEN set
121 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MySQL server
122 "Dumping performance_schema.host_cache"
123 IP 2001:db8::6:6
124 HOST santa.claus.ipv6.example.com
125 HOST_VALIDATED YES
126 SUM_CONNECT_ERRORS 0
127 COUNT_HOST_BLOCKED_ERRORS 0
128 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
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 4
135 COUNT_NO_AUTH_PLUGIN_ERRORS 0
136 COUNT_AUTH_PLUGIN_ERRORS 0
137 COUNT_HANDSHAKE_ERRORS 0
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 set global debug= default;