Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv6_ssl.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 'user_ssl'@'santa.claus.ipv6.example.com';
14 create user 'user_ssl_x509'@'santa.claus.ipv6.example.com'
15 identified by 'good_password';
16 grant select on test.* to 'user_ssl'@'santa.claus.ipv6.example.com'
17 REQUIRE SSL;
18 grant select on test.* to 'user_ssl_x509'@'santa.claus.ipv6.example.com'
19 REQUIRE SUBJECT '/C=??/ST=??/L=??/
20 O=No such thing/
21 CN=Santa Claus/[email protected]';
22 connect con1,"::1",root,,test,$MASTER_MYPORT,;
23 select "Con1 is alive";
24 Con1 is alive
25 Con1 is alive
26 select current_user();
27 current_user()
28 root@localhost
29 disconnect con1;
30 connection default;
31 SET @saved_dbug = @@GLOBAL.debug_dbug;
32 set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
33 ERROR 28000: Access denied for user 'user_ssl'@'santa.claus.ipv6.example.com' (using password: NO)
34 connection default;
35 # Dumping performance_schema.host_cache
36 IP 2001:db8::6:6
37 HOST santa.claus.ipv6.example.com
38 HOST_VALIDATED YES
39 SUM_CONNECT_ERRORS 0
40 COUNT_HOST_BLOCKED_ERRORS 0
41 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
42 COUNT_NAMEINFO_PERMANENT_ERRORS 0
43 COUNT_FORMAT_ERRORS 0
44 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
45 COUNT_ADDRINFO_PERMANENT_ERRORS 0
46 COUNT_FCRDNS_ERRORS 0
47 COUNT_HOST_ACL_ERRORS 0
48 COUNT_NO_AUTH_PLUGIN_ERRORS 0
49 COUNT_AUTH_PLUGIN_ERRORS 0
50 COUNT_HANDSHAKE_ERRORS 0
51 COUNT_PROXY_USER_ERRORS 0
52 COUNT_PROXY_USER_ACL_ERRORS 0
53 COUNT_AUTHENTICATION_ERRORS 0
54 COUNT_SSL_ERRORS 1
55 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
56 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
57 COUNT_DEFAULT_DATABASE_ERRORS 0
58 COUNT_INIT_CONNECT_ERRORS 0
59 COUNT_LOCAL_ERRORS 0
60 COUNT_UNKNOWN_ERRORS 0
61 FIRST_ERROR_SEEN set
62 LAST_ERROR_SEEN set
63 ERROR 28000: Access denied for user 'user_ssl'@'santa.claus.ipv6.example.com' (using password: NO)
64 connection default;
65 # Dumping performance_schema.host_cache
66 IP 2001:db8::6:6
67 HOST santa.claus.ipv6.example.com
68 HOST_VALIDATED YES
69 SUM_CONNECT_ERRORS 0
70 COUNT_HOST_BLOCKED_ERRORS 0
71 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
72 COUNT_NAMEINFO_PERMANENT_ERRORS 0
73 COUNT_FORMAT_ERRORS 0
74 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
75 COUNT_ADDRINFO_PERMANENT_ERRORS 0
76 COUNT_FCRDNS_ERRORS 0
77 COUNT_HOST_ACL_ERRORS 0
78 COUNT_NO_AUTH_PLUGIN_ERRORS 0
79 COUNT_AUTH_PLUGIN_ERRORS 0
80 COUNT_HANDSHAKE_ERRORS 0
81 COUNT_PROXY_USER_ERRORS 0
82 COUNT_PROXY_USER_ACL_ERRORS 0
83 COUNT_AUTHENTICATION_ERRORS 0
84 COUNT_SSL_ERRORS 2
85 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
86 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
87 COUNT_DEFAULT_DATABASE_ERRORS 0
88 COUNT_INIT_CONNECT_ERRORS 0
89 COUNT_LOCAL_ERRORS 0
90 COUNT_UNKNOWN_ERRORS 0
91 FIRST_ERROR_SEEN set
92 LAST_ERROR_SEEN set
93 ERROR 28000: Access denied for user 'user_ssl_x509'@'santa.claus.ipv6.example.com' (using password: YES)
94 connection default;
95 # Dumping performance_schema.host_cache
96 IP 2001:db8::6:6
97 HOST santa.claus.ipv6.example.com
98 HOST_VALIDATED YES
99 SUM_CONNECT_ERRORS 0
100 COUNT_HOST_BLOCKED_ERRORS 0
101 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
102 COUNT_NAMEINFO_PERMANENT_ERRORS 0
103 COUNT_FORMAT_ERRORS 0
104 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
105 COUNT_ADDRINFO_PERMANENT_ERRORS 0
106 COUNT_FCRDNS_ERRORS 0
107 COUNT_HOST_ACL_ERRORS 0
108 COUNT_NO_AUTH_PLUGIN_ERRORS 0
109 COUNT_AUTH_PLUGIN_ERRORS 0
110 COUNT_HANDSHAKE_ERRORS 0
111 COUNT_PROXY_USER_ERRORS 0
112 COUNT_PROXY_USER_ACL_ERRORS 0
113 COUNT_AUTHENTICATION_ERRORS 0
114 COUNT_SSL_ERRORS 3
115 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
116 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
117 COUNT_DEFAULT_DATABASE_ERRORS 0
118 COUNT_INIT_CONNECT_ERRORS 0
119 COUNT_LOCAL_ERRORS 0
120 COUNT_UNKNOWN_ERRORS 0
121 FIRST_ERROR_SEEN set
122 LAST_ERROR_SEEN set
123 ERROR 28000: Access denied for user 'user_ssl_x509'@'santa.claus.ipv6.example.com' (using password: YES)
124 connection default;
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 0
144 COUNT_SSL_ERRORS 4
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 drop user 'user_ssl'@'santa.claus.ipv6.example.com';
154 drop user 'user_ssl_x509'@'santa.claus.ipv6.example.com';
155 SET @@GLOBAL.debug_dbug = @saved_dbug;