Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_good_deny.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 connect con1,"::1",root,,test,$MASTER_MYPORT,;
14 select "Con1 is alive";
15 Con1 is alive
16 Con1 is alive
17 select current_user();
18 current_user()
19 root@localhost
20 disconnect con1;
21 connection default;
22 SET @saved_dbug = @@GLOBAL.debug_dbug;
23 set global debug_dbug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
24 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MariaDB server
25 connection default;
26 # Dumping performance_schema.host_cache
27 IP 2001:db8::6:6
28 HOST santa.claus.ipv6.example.com
29 HOST_VALIDATED YES
30 SUM_CONNECT_ERRORS 0
31 COUNT_HOST_BLOCKED_ERRORS 0
32 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
33 COUNT_NAMEINFO_PERMANENT_ERRORS 0
34 COUNT_FORMAT_ERRORS 0
35 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
36 COUNT_ADDRINFO_PERMANENT_ERRORS 0
37 COUNT_FCRDNS_ERRORS 0
38 COUNT_HOST_ACL_ERRORS 1
39 COUNT_NO_AUTH_PLUGIN_ERRORS 0
40 COUNT_AUTH_PLUGIN_ERRORS 0
41 COUNT_HANDSHAKE_ERRORS 0
42 COUNT_PROXY_USER_ERRORS 0
43 COUNT_PROXY_USER_ACL_ERRORS 0
44 COUNT_AUTHENTICATION_ERRORS 0
45 COUNT_SSL_ERRORS 0
46 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
47 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
48 COUNT_DEFAULT_DATABASE_ERRORS 0
49 COUNT_INIT_CONNECT_ERRORS 0
50 COUNT_LOCAL_ERRORS 0
51 COUNT_UNKNOWN_ERRORS 0
52 FIRST_ERROR_SEEN set
53 LAST_ERROR_SEEN set
54 ERROR HY000: Host 'santa.claus.ipv6.example.com' is not allowed to connect to this MariaDB server
55 connection default;
56 # Dumping performance_schema.host_cache
57 IP 2001:db8::6:6
58 HOST santa.claus.ipv6.example.com
59 HOST_VALIDATED YES
60 SUM_CONNECT_ERRORS 0
61 COUNT_HOST_BLOCKED_ERRORS 0
62 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
63 COUNT_NAMEINFO_PERMANENT_ERRORS 0
64 COUNT_FORMAT_ERRORS 0
65 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
66 COUNT_ADDRINFO_PERMANENT_ERRORS 0
67 COUNT_FCRDNS_ERRORS 0
68 COUNT_HOST_ACL_ERRORS 2
69 COUNT_NO_AUTH_PLUGIN_ERRORS 0
70 COUNT_AUTH_PLUGIN_ERRORS 0
71 COUNT_HANDSHAKE_ERRORS 0
72 COUNT_PROXY_USER_ERRORS 0
73 COUNT_PROXY_USER_ACL_ERRORS 0
74 COUNT_AUTHENTICATION_ERRORS 0
75 COUNT_SSL_ERRORS 0
76 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
77 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
78 COUNT_DEFAULT_DATABASE_ERRORS 0
79 COUNT_INIT_CONNECT_ERRORS 0
80 COUNT_LOCAL_ERRORS 0
81 COUNT_UNKNOWN_ERRORS 0
82 FIRST_ERROR_SEEN set
83 LAST_ERROR_SEEN set
84 SET @@GLOBAL.debug_dbug = @saved_dbug;