Debian Codegraph @

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

raw
1 flush status;
2 TRUNCATE TABLE performance_schema.host_cache;
3 flush user_resources;
4 flush privileges;
5 select @@global.debug;
6 @@global.debug
7
8 select @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 select @@global.max_user_connections;
12 @@global.max_user_connections
13 0
14 select @@global.max_connections;
15 @@global.max_connections
16 151
17 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
18 User Host
19 select `User`, `Host` from mysql.`user` where `user` like '192.%';
20 User Host
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 User Host
23 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
24 User Host
25 create user 'user_ssl'@'santa.claus.ipv4.example.com' REQUIRE SSL;
26 create user 'user_ssl_x509'@'santa.claus.ipv4.example.com'
27 identified by 'good_password'
28 REQUIRE SUBJECT '/C=??/ST=??/L=??/
29 O=No such thing/
30 CN=Santa Claus/[email protected]';
31 grant select on test.* to 'user_ssl'@'santa.claus.ipv4.example.com',
32 'user_ssl_x509'@'santa.claus.ipv4.example.com';
33 select "Con1 is alive";
34 Con1 is alive
35 Con1 is alive
36 select current_user();
37 current_user()
38 root@localhost
39 set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
40 ERROR 28000: Access denied for user 'user_ssl'@'santa.claus.ipv4.example.com' (using password: NO)
41 "Dumping performance_schema.host_cache"
42 IP 192.0.2.4
43 HOST santa.claus.ipv4.example.com
44 HOST_VALIDATED YES
45 SUM_CONNECT_ERRORS 0
46 COUNT_HOST_BLOCKED_ERRORS 0
47 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
48 COUNT_NAMEINFO_PERMANENT_ERRORS 0
49 COUNT_FORMAT_ERRORS 0
50 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
51 COUNT_ADDRINFO_PERMANENT_ERRORS 0
52 COUNT_FCRDNS_ERRORS 0
53 COUNT_HOST_ACL_ERRORS 0
54 COUNT_NO_AUTH_PLUGIN_ERRORS 0
55 COUNT_AUTH_PLUGIN_ERRORS 0
56 COUNT_HANDSHAKE_ERRORS 0
57 COUNT_PROXY_USER_ERRORS 0
58 COUNT_PROXY_USER_ACL_ERRORS 0
59 COUNT_AUTHENTICATION_ERRORS 0
60 COUNT_SSL_ERRORS 1
61 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
62 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
63 COUNT_DEFAULT_DATABASE_ERRORS 0
64 COUNT_INIT_CONNECT_ERRORS 0
65 COUNT_LOCAL_ERRORS 0
66 COUNT_UNKNOWN_ERRORS 0
67 FIRST_ERROR_SEEN set
68 LAST_ERROR_SEEN set
69 ERROR 28000: Access denied for user 'user_ssl'@'santa.claus.ipv4.example.com' (using password: NO)
70 "Dumping performance_schema.host_cache"
71 IP 192.0.2.4
72 HOST santa.claus.ipv4.example.com
73 HOST_VALIDATED YES
74 SUM_CONNECT_ERRORS 0
75 COUNT_HOST_BLOCKED_ERRORS 0
76 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
77 COUNT_NAMEINFO_PERMANENT_ERRORS 0
78 COUNT_FORMAT_ERRORS 0
79 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
80 COUNT_ADDRINFO_PERMANENT_ERRORS 0
81 COUNT_FCRDNS_ERRORS 0
82 COUNT_HOST_ACL_ERRORS 0
83 COUNT_NO_AUTH_PLUGIN_ERRORS 0
84 COUNT_AUTH_PLUGIN_ERRORS 0
85 COUNT_HANDSHAKE_ERRORS 0
86 COUNT_PROXY_USER_ERRORS 0
87 COUNT_PROXY_USER_ACL_ERRORS 0
88 COUNT_AUTHENTICATION_ERRORS 0
89 COUNT_SSL_ERRORS 2
90 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
91 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
92 COUNT_DEFAULT_DATABASE_ERRORS 0
93 COUNT_INIT_CONNECT_ERRORS 0
94 COUNT_LOCAL_ERRORS 0
95 COUNT_UNKNOWN_ERRORS 0
96 FIRST_ERROR_SEEN set
97 LAST_ERROR_SEEN set
98 ERROR 28000: Access denied for user 'user_ssl_x509'@'santa.claus.ipv4.example.com' (using password: YES)
99 "Dumping performance_schema.host_cache"
100 IP 192.0.2.4
101 HOST santa.claus.ipv4.example.com
102 HOST_VALIDATED YES
103 SUM_CONNECT_ERRORS 0
104 COUNT_HOST_BLOCKED_ERRORS 0
105 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
106 COUNT_NAMEINFO_PERMANENT_ERRORS 0
107 COUNT_FORMAT_ERRORS 0
108 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
109 COUNT_ADDRINFO_PERMANENT_ERRORS 0
110 COUNT_FCRDNS_ERRORS 0
111 COUNT_HOST_ACL_ERRORS 0
112 COUNT_NO_AUTH_PLUGIN_ERRORS 0
113 COUNT_AUTH_PLUGIN_ERRORS 0
114 COUNT_HANDSHAKE_ERRORS 0
115 COUNT_PROXY_USER_ERRORS 0
116 COUNT_PROXY_USER_ACL_ERRORS 0
117 COUNT_AUTHENTICATION_ERRORS 0
118 COUNT_SSL_ERRORS 3
119 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
120 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
121 COUNT_DEFAULT_DATABASE_ERRORS 0
122 COUNT_INIT_CONNECT_ERRORS 0
123 COUNT_LOCAL_ERRORS 0
124 COUNT_UNKNOWN_ERRORS 0
125 FIRST_ERROR_SEEN set
126 LAST_ERROR_SEEN set
127 ERROR 28000: Access denied for user 'user_ssl_x509'@'santa.claus.ipv4.example.com' (using password: YES)
128 "Dumping performance_schema.host_cache"
129 IP 192.0.2.4
130 HOST santa.claus.ipv4.example.com
131 HOST_VALIDATED YES
132 SUM_CONNECT_ERRORS 0
133 COUNT_HOST_BLOCKED_ERRORS 0
134 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
135 COUNT_NAMEINFO_PERMANENT_ERRORS 0
136 COUNT_FORMAT_ERRORS 0
137 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
138 COUNT_ADDRINFO_PERMANENT_ERRORS 0
139 COUNT_FCRDNS_ERRORS 0
140 COUNT_HOST_ACL_ERRORS 0
141 COUNT_NO_AUTH_PLUGIN_ERRORS 0
142 COUNT_AUTH_PLUGIN_ERRORS 0
143 COUNT_HANDSHAKE_ERRORS 0
144 COUNT_PROXY_USER_ERRORS 0
145 COUNT_PROXY_USER_ACL_ERRORS 0
146 COUNT_AUTHENTICATION_ERRORS 0
147 COUNT_SSL_ERRORS 4
148 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
149 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
150 COUNT_DEFAULT_DATABASE_ERRORS 0
151 COUNT_INIT_CONNECT_ERRORS 0
152 COUNT_LOCAL_ERRORS 0
153 COUNT_UNKNOWN_ERRORS 0
154 FIRST_ERROR_SEEN set
155 LAST_ERROR_SEEN set
156 drop user 'user_ssl'@'santa.claus.ipv4.example.com';
157 drop user 'user_ssl_x509'@'santa.claus.ipv4.example.com';
158 set global debug= default;