Debian Codegraph @

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

raw
1 call mtr.add_suppression("192.0.2.4");
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 create user 'root'@'192.0.2.4', 'root'@'santa.claus.ipv4.example.com';
27 grant select on test.* to 'root'@'192.0.2.4';
28 grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
29 select "Con1 is alive";
30 Con1 is alive
31 Con1 is alive
32 select current_user();
33 current_user()
34 root@localhost
35 set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_error_again";
36 select "Con2 is alive";
37 Con2 is alive
38 Con2 is alive
39 select current_user();
40 current_user()
41 [email protected]
42 "Dumping performance_schema.host_cache"
43 IP 192.0.2.4
44 HOST NULL
45 HOST_VALIDATED NO
46 SUM_CONNECT_ERRORS 0
47 COUNT_HOST_BLOCKED_ERRORS 0
48 COUNT_NAMEINFO_TRANSIENT_ERRORS 1
49 COUNT_NAMEINFO_PERMANENT_ERRORS 0
50 COUNT_FORMAT_ERRORS 0
51 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
52 COUNT_ADDRINFO_PERMANENT_ERRORS 0
53 COUNT_FCRDNS_ERRORS 0
54 COUNT_HOST_ACL_ERRORS 0
55 COUNT_NO_AUTH_PLUGIN_ERRORS 0
56 COUNT_AUTH_PLUGIN_ERRORS 0
57 COUNT_HANDSHAKE_ERRORS 0
58 COUNT_PROXY_USER_ERRORS 0
59 COUNT_PROXY_USER_ACL_ERRORS 0
60 COUNT_AUTHENTICATION_ERRORS 0
61 COUNT_SSL_ERRORS 0
62 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
63 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
64 COUNT_DEFAULT_DATABASE_ERRORS 0
65 COUNT_INIT_CONNECT_ERRORS 0
66 COUNT_LOCAL_ERRORS 0
67 COUNT_UNKNOWN_ERRORS 0
68 FIRST_ERROR_SEEN set
69 LAST_ERROR_SEEN set
70 select "Con3 is alive";
71 Con3 is alive
72 Con3 is alive
73 select current_user();
74 current_user()
75 [email protected]
76 "Dumping performance_schema.host_cache"
77 IP 192.0.2.4
78 HOST NULL
79 HOST_VALIDATED NO
80 SUM_CONNECT_ERRORS 0
81 COUNT_HOST_BLOCKED_ERRORS 0
82 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
83 COUNT_NAMEINFO_PERMANENT_ERRORS 0
84 COUNT_FORMAT_ERRORS 0
85 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
86 COUNT_ADDRINFO_PERMANENT_ERRORS 0
87 COUNT_FCRDNS_ERRORS 0
88 COUNT_HOST_ACL_ERRORS 0
89 COUNT_NO_AUTH_PLUGIN_ERRORS 0
90 COUNT_AUTH_PLUGIN_ERRORS 0
91 COUNT_HANDSHAKE_ERRORS 0
92 COUNT_PROXY_USER_ERRORS 0
93 COUNT_PROXY_USER_ACL_ERRORS 0
94 COUNT_AUTHENTICATION_ERRORS 0
95 COUNT_SSL_ERRORS 0
96 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
97 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
98 COUNT_DEFAULT_DATABASE_ERRORS 0
99 COUNT_INIT_CONNECT_ERRORS 0
100 COUNT_LOCAL_ERRORS 0
101 COUNT_UNKNOWN_ERRORS 0
102 FIRST_ERROR_SEEN set
103 LAST_ERROR_SEEN set
104 set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
105 select "Con4 is alive";
106 Con4 is alive
107 Con4 is alive
108 select current_user();
109 current_user()
110 [email protected]
111 "Dumping performance_schema.host_cache"
112 IP 192.0.2.4
113 HOST santa.claus.ipv4.example.com
114 HOST_VALIDATED YES
115 SUM_CONNECT_ERRORS 0
116 COUNT_HOST_BLOCKED_ERRORS 0
117 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
118 COUNT_NAMEINFO_PERMANENT_ERRORS 0
119 COUNT_FORMAT_ERRORS 0
120 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
121 COUNT_ADDRINFO_PERMANENT_ERRORS 0
122 COUNT_FCRDNS_ERRORS 0
123 COUNT_HOST_ACL_ERRORS 0
124 COUNT_NO_AUTH_PLUGIN_ERRORS 0
125 COUNT_AUTH_PLUGIN_ERRORS 0
126 COUNT_HANDSHAKE_ERRORS 0
127 COUNT_PROXY_USER_ERRORS 0
128 COUNT_PROXY_USER_ACL_ERRORS 0
129 COUNT_AUTHENTICATION_ERRORS 0
130 COUNT_SSL_ERRORS 0
131 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
132 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
133 COUNT_DEFAULT_DATABASE_ERRORS 0
134 COUNT_INIT_CONNECT_ERRORS 0
135 COUNT_LOCAL_ERRORS 0
136 COUNT_UNKNOWN_ERRORS 0
137 FIRST_ERROR_SEEN set
138 LAST_ERROR_SEEN set
139 select "Con5 is alive";
140 Con5 is alive
141 Con5 is alive
142 select current_user();
143 current_user()
144 [email protected]
145 "Dumping performance_schema.host_cache"
146 IP 192.0.2.4
147 HOST santa.claus.ipv4.example.com
148 HOST_VALIDATED YES
149 SUM_CONNECT_ERRORS 0
150 COUNT_HOST_BLOCKED_ERRORS 0
151 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
152 COUNT_NAMEINFO_PERMANENT_ERRORS 0
153 COUNT_FORMAT_ERRORS 0
154 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
155 COUNT_ADDRINFO_PERMANENT_ERRORS 0
156 COUNT_FCRDNS_ERRORS 0
157 COUNT_HOST_ACL_ERRORS 0
158 COUNT_NO_AUTH_PLUGIN_ERRORS 0
159 COUNT_AUTH_PLUGIN_ERRORS 0
160 COUNT_HANDSHAKE_ERRORS 0
161 COUNT_PROXY_USER_ERRORS 0
162 COUNT_PROXY_USER_ACL_ERRORS 0
163 COUNT_AUTHENTICATION_ERRORS 0
164 COUNT_SSL_ERRORS 0
165 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
166 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
167 COUNT_DEFAULT_DATABASE_ERRORS 0
168 COUNT_INIT_CONNECT_ERRORS 0
169 COUNT_LOCAL_ERRORS 0
170 COUNT_UNKNOWN_ERRORS 0
171 FIRST_ERROR_SEEN set
172 LAST_ERROR_SEEN set
173 revoke select on test.* from 'root'@'192.0.2.4';
174 revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
175 drop user 'root'@'192.0.2.4';
176 drop user 'root'@'santa.claus.ipv4.example.com';
177 set global debug= default;