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 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 create user 'root'@'192.0.2.4';
15 grant select on test.* to 'root'@'192.0.2.4';
16 create user 'root'@'santa.claus.ipv4.example.com';
17 grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
18 connect con1,"127.0.0.1",root,,test,$MASTER_MYPORT,;
19 select "Con1 is alive";
20 Con1 is alive
21 Con1 is alive
22 select current_user();
23 current_user()
24 root@localhost
25 disconnect con1;
26 connection default;
27 SET @saved_dbug = @@GLOBAL.debug_dbug;
28 set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_error_again";
29 connect con2,"127.0.0.1",root,,test,$MASTER_MYPORT,;
30 select "Con2 is alive";
31 Con2 is alive
32 Con2 is alive
33 select current_user();
34 current_user()
35 [email protected]
36 disconnect con2;
37 connection default;
38 # Dumping performance_schema.host_cache
39 IP 192.0.2.4
40 HOST NULL
41 HOST_VALIDATED NO
42 SUM_CONNECT_ERRORS 0
43 COUNT_HOST_BLOCKED_ERRORS 0
44 COUNT_NAMEINFO_TRANSIENT_ERRORS 1
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 0
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 connect con3,"127.0.0.1",root,,test,$MASTER_MYPORT,;
67 select "Con3 is alive";
68 Con3 is alive
69 Con3 is alive
70 select current_user();
71 current_user()
72 [email protected]
73 disconnect con3;
74 connection default;
75 # Dumping performance_schema.host_cache
76 IP 192.0.2.4
77 HOST NULL
78 HOST_VALIDATED NO
79 SUM_CONNECT_ERRORS 0
80 COUNT_HOST_BLOCKED_ERRORS 0
81 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
82 COUNT_NAMEINFO_PERMANENT_ERRORS 0
83 COUNT_FORMAT_ERRORS 0
84 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
85 COUNT_ADDRINFO_PERMANENT_ERRORS 0
86 COUNT_FCRDNS_ERRORS 0
87 COUNT_HOST_ACL_ERRORS 0
88 COUNT_NO_AUTH_PLUGIN_ERRORS 0
89 COUNT_AUTH_PLUGIN_ERRORS 0
90 COUNT_HANDSHAKE_ERRORS 0
91 COUNT_PROXY_USER_ERRORS 0
92 COUNT_PROXY_USER_ACL_ERRORS 0
93 COUNT_AUTHENTICATION_ERRORS 0
94 COUNT_SSL_ERRORS 0
95 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
96 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
97 COUNT_DEFAULT_DATABASE_ERRORS 0
98 COUNT_INIT_CONNECT_ERRORS 0
99 COUNT_LOCAL_ERRORS 0
100 COUNT_UNKNOWN_ERRORS 0
101 FIRST_ERROR_SEEN set
102 LAST_ERROR_SEEN set
103 set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
104 connect con4,"127.0.0.1",root,,test,$MASTER_MYPORT,;
105 select "Con4 is alive";
106 Con4 is alive
107 Con4 is alive
108 select current_user();
109 current_user()
110 [email protected]
111 disconnect con4;
112 connection default;
113 # Dumping performance_schema.host_cache
114 IP 192.0.2.4
115 HOST santa.claus.ipv4.example.com
116 HOST_VALIDATED YES
117 SUM_CONNECT_ERRORS 0
118 COUNT_HOST_BLOCKED_ERRORS 0
119 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
120 COUNT_NAMEINFO_PERMANENT_ERRORS 0
121 COUNT_FORMAT_ERRORS 0
122 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
123 COUNT_ADDRINFO_PERMANENT_ERRORS 0
124 COUNT_FCRDNS_ERRORS 0
125 COUNT_HOST_ACL_ERRORS 0
126 COUNT_NO_AUTH_PLUGIN_ERRORS 0
127 COUNT_AUTH_PLUGIN_ERRORS 0
128 COUNT_HANDSHAKE_ERRORS 0
129 COUNT_PROXY_USER_ERRORS 0
130 COUNT_PROXY_USER_ACL_ERRORS 0
131 COUNT_AUTHENTICATION_ERRORS 0
132 COUNT_SSL_ERRORS 0
133 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
134 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
135 COUNT_DEFAULT_DATABASE_ERRORS 0
136 COUNT_INIT_CONNECT_ERRORS 0
137 COUNT_LOCAL_ERRORS 0
138 COUNT_UNKNOWN_ERRORS 0
139 FIRST_ERROR_SEEN set
140 LAST_ERROR_SEEN set
141 connect con5,"127.0.0.1",root,,test,$MASTER_MYPORT,;
142 select "Con5 is alive";
143 Con5 is alive
144 Con5 is alive
145 select current_user();
146 current_user()
147 [email protected]
148 disconnect con5;
149 connection default;
150 # Dumping performance_schema.host_cache
151 IP 192.0.2.4
152 HOST santa.claus.ipv4.example.com
153 HOST_VALIDATED YES
154 SUM_CONNECT_ERRORS 0
155 COUNT_HOST_BLOCKED_ERRORS 0
156 COUNT_NAMEINFO_TRANSIENT_ERRORS 2
157 COUNT_NAMEINFO_PERMANENT_ERRORS 0
158 COUNT_FORMAT_ERRORS 0
159 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
160 COUNT_ADDRINFO_PERMANENT_ERRORS 0
161 COUNT_FCRDNS_ERRORS 0
162 COUNT_HOST_ACL_ERRORS 0
163 COUNT_NO_AUTH_PLUGIN_ERRORS 0
164 COUNT_AUTH_PLUGIN_ERRORS 0
165 COUNT_HANDSHAKE_ERRORS 0
166 COUNT_PROXY_USER_ERRORS 0
167 COUNT_PROXY_USER_ACL_ERRORS 0
168 COUNT_AUTHENTICATION_ERRORS 0
169 COUNT_SSL_ERRORS 0
170 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
171 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
172 COUNT_DEFAULT_DATABASE_ERRORS 0
173 COUNT_INIT_CONNECT_ERRORS 0
174 COUNT_LOCAL_ERRORS 0
175 COUNT_UNKNOWN_ERRORS 0
176 FIRST_ERROR_SEEN set
177 LAST_ERROR_SEEN set
178 revoke select on test.* from 'root'@'192.0.2.4';
179 revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
180 drop user 'root'@'192.0.2.4';
181 drop user 'root'@'santa.claus.ipv4.example.com';
182 SET @@GLOBAL.debug_dbug = @saved_dbug;