Debian Codegraph @

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

raw
1 flush global status;
2 flush hosts;
3 flush user_resources;
4 flush privileges;
5 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
6 User Host
7 select `User`, `Host` from mysql.`user` where `user` like '192.%';
8 User Host
9 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
10 User Host
11 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
12 User Host
13 CREATE USER 'plug'@'santa.claus.ipv6.example.com'
14 IDENTIFIED WITH 'test_plugin_server' AS 'plug_dest';
15 CREATE USER 'plug_dest'@'santa.claus.ipv6.example.com'
16 IDENTIFIED BY 'plug_test_passwd';
17 GRANT SELECT ON test.* TO 'plug_dest'@'santa.claus.ipv6.example.com';
18 connect con1,"::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_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
29 uninstall plugin test_plugin_server;
30 ERROR HY000: Plugin 'test_plugin_server' is not loaded
31 connection default;
32 # Dumping performance_schema.host_cache
33 IP 2001:db8::6:6
34 HOST santa.claus.ipv6.example.com
35 HOST_VALIDATED YES
36 SUM_CONNECT_ERRORS 0
37 COUNT_HOST_BLOCKED_ERRORS 0
38 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
39 COUNT_NAMEINFO_PERMANENT_ERRORS 0
40 COUNT_FORMAT_ERRORS 0
41 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
42 COUNT_ADDRINFO_PERMANENT_ERRORS 0
43 COUNT_FCRDNS_ERRORS 0
44 COUNT_HOST_ACL_ERRORS 0
45 COUNT_NO_AUTH_PLUGIN_ERRORS 1
46 COUNT_AUTH_PLUGIN_ERRORS 1
47 COUNT_HANDSHAKE_ERRORS 0
48 COUNT_PROXY_USER_ERRORS 0
49 COUNT_PROXY_USER_ACL_ERRORS 0
50 COUNT_AUTHENTICATION_ERRORS 0
51 COUNT_SSL_ERRORS 0
52 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
53 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
54 COUNT_DEFAULT_DATABASE_ERRORS 0
55 COUNT_INIT_CONNECT_ERRORS 0
56 COUNT_LOCAL_ERRORS 0
57 COUNT_UNKNOWN_ERRORS 0
58 FIRST_ERROR_SEEN set
59 LAST_ERROR_SEEN set
60 ERROR HY000: Plugin 'test_plugin_server' is not loaded
61 connection default;
62 # Dumping performance_schema.host_cache
63 IP 2001:db8::6:6
64 HOST santa.claus.ipv6.example.com
65 HOST_VALIDATED YES
66 SUM_CONNECT_ERRORS 0
67 COUNT_HOST_BLOCKED_ERRORS 0
68 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
69 COUNT_NAMEINFO_PERMANENT_ERRORS 0
70 COUNT_FORMAT_ERRORS 0
71 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
72 COUNT_ADDRINFO_PERMANENT_ERRORS 0
73 COUNT_FCRDNS_ERRORS 0
74 COUNT_HOST_ACL_ERRORS 0
75 COUNT_NO_AUTH_PLUGIN_ERRORS 2
76 COUNT_AUTH_PLUGIN_ERRORS 2
77 COUNT_HANDSHAKE_ERRORS 0
78 COUNT_PROXY_USER_ERRORS 0
79 COUNT_PROXY_USER_ACL_ERRORS 0
80 COUNT_AUTHENTICATION_ERRORS 0
81 COUNT_SSL_ERRORS 0
82 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
83 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
84 COUNT_DEFAULT_DATABASE_ERRORS 0
85 COUNT_INIT_CONNECT_ERRORS 0
86 COUNT_LOCAL_ERRORS 0
87 COUNT_UNKNOWN_ERRORS 0
88 FIRST_ERROR_SEEN set
89 LAST_ERROR_SEEN set
90 install plugin test_plugin_server soname 'PLUGIN_AUTH';
91 ERROR 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
92 connection default;
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 0
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 0
106 COUNT_NO_AUTH_PLUGIN_ERRORS 2
107 COUNT_AUTH_PLUGIN_ERRORS 2
108 COUNT_HANDSHAKE_ERRORS 0
109 COUNT_PROXY_USER_ERRORS 1
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 28000: Access denied for user 'plug'@'santa.claus.ipv6.example.com' (using password: YES)
122 connection default;
123 # Dumping performance_schema.host_cache
124 IP 2001:db8::6:6
125 HOST santa.claus.ipv6.example.com
126 HOST_VALIDATED YES
127 SUM_CONNECT_ERRORS 0
128 COUNT_HOST_BLOCKED_ERRORS 0
129 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
130 COUNT_NAMEINFO_PERMANENT_ERRORS 0
131 COUNT_FORMAT_ERRORS 0
132 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
133 COUNT_ADDRINFO_PERMANENT_ERRORS 0
134 COUNT_FCRDNS_ERRORS 0
135 COUNT_HOST_ACL_ERRORS 0
136 COUNT_NO_AUTH_PLUGIN_ERRORS 2
137 COUNT_AUTH_PLUGIN_ERRORS 2
138 COUNT_HANDSHAKE_ERRORS 0
139 COUNT_PROXY_USER_ERRORS 2
140 COUNT_PROXY_USER_ACL_ERRORS 0
141 COUNT_AUTHENTICATION_ERRORS 0
142 COUNT_SSL_ERRORS 0
143 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
144 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
145 COUNT_DEFAULT_DATABASE_ERRORS 0
146 COUNT_INIT_CONNECT_ERRORS 0
147 COUNT_LOCAL_ERRORS 0
148 COUNT_UNKNOWN_ERRORS 0
149 FIRST_ERROR_SEEN set
150 LAST_ERROR_SEEN set
151 GRANT PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
152 TO 'plug'@'santa.claus.ipv6.example.com';
153 connect con4,"::1",plug,plug_dest,test,$MASTER_MYPORT,,,auth_test_plugin;
154 select "Con4 is alive";
155 Con4 is alive
156 Con4 is alive
157 select user();
158 user()
159 [email protected]
160 select current_user();
161 current_user()
162 [email protected]
163 disconnect con4;
164 connection default;
165 # Dumping performance_schema.host_cache
166 IP 2001:db8::6:6
167 HOST santa.claus.ipv6.example.com
168 HOST_VALIDATED YES
169 SUM_CONNECT_ERRORS 0
170 COUNT_HOST_BLOCKED_ERRORS 0
171 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
172 COUNT_NAMEINFO_PERMANENT_ERRORS 0
173 COUNT_FORMAT_ERRORS 0
174 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
175 COUNT_ADDRINFO_PERMANENT_ERRORS 0
176 COUNT_FCRDNS_ERRORS 0
177 COUNT_HOST_ACL_ERRORS 0
178 COUNT_NO_AUTH_PLUGIN_ERRORS 2
179 COUNT_AUTH_PLUGIN_ERRORS 2
180 COUNT_HANDSHAKE_ERRORS 0
181 COUNT_PROXY_USER_ERRORS 2
182 COUNT_PROXY_USER_ACL_ERRORS 0
183 COUNT_AUTHENTICATION_ERRORS 0
184 COUNT_SSL_ERRORS 0
185 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
186 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
187 COUNT_DEFAULT_DATABASE_ERRORS 0
188 COUNT_INIT_CONNECT_ERRORS 0
189 COUNT_LOCAL_ERRORS 0
190 COUNT_UNKNOWN_ERRORS 0
191 FIRST_ERROR_SEEN set
192 LAST_ERROR_SEEN set
193 REVOKE ALL PRIVILEGES ON *.* FROM 'plug_dest'@'santa.claus.ipv6.example.com';
194 REVOKE PROXY ON 'plug_dest'@'santa.claus.ipv6.example.com'
195 FROM 'plug'@'santa.claus.ipv6.example.com';
196 DROP USER 'plug'@'santa.claus.ipv6.example.com';
197 DROP USER 'plug_dest'@'santa.claus.ipv6.example.com';
198 SET @@GLOBAL.debug_dbug = @saved_dbug;
199 delete from mysql.plugin where name='test_plugin_server';