Debian Codegraph @

mysql-test/suite/perfschema/t/hostcache_ipv6_ssl.test

raw
1
2 #
3 # Tests for the performance_schema host_cache.
4 #
5 # Simulate failures from SSL:
6 # - reported in COUNT_SSL_ERRORS
7
8 --source include/have_debug.inc
9 --source include/have_ipv6.inc
10
11 # Enforce a clean state
12 --source ../include/wait_for_pfs_thread_count.inc
13 --source ../include/hostcache_set_state.inc
14
15 create user 'user_ssl'@'santa.claus.ipv6.example.com' REQUIRE SSL;
16 create user 'user_ssl_x509'@'santa.claus.ipv6.example.com'
17 identified by 'good_password'
18 REQUIRE SUBJECT '/C=??/ST=??/L=??/
19 O=No such thing/
20 CN=Santa Claus/[email protected]';
21 grant select on test.* to 'user_ssl'@'santa.claus.ipv6.example.com',
22 'user_ssl_x509'@'santa.claus.ipv6.example.com';
23
24 connect (con1,"::1",root,,test,$MASTER_MYPORT,);
25 select "Con1 is alive";
26 select current_user();
27 disconnect con1;
28
29 --connection default
30 set global debug= "+d,vio_peer_addr_fake_ipv6,getnameinfo_fake_ipv6,getaddrinfo_fake_good_ipv6";
31
32 --disable_query_log
33 --error ER_ACCESS_DENIED_ERROR
34 connect (con2a,"::1",user_ssl,,test,$MASTER_MYPORT,);
35 --enable_query_log
36
37 --connection default
38 --source ../include/hostcache_dump.inc
39
40 --disable_query_log
41 --error ER_ACCESS_DENIED_ERROR
42 connect (con2b,"::1",user_ssl,,test,$MASTER_MYPORT,);
43 --enable_query_log
44
45 --connection default
46 --source ../include/hostcache_dump.inc
47
48 --disable_query_log
49 --error ER_ACCESS_DENIED_ERROR
50 connect (con2c,"::1",user_ssl_x509,good_password,test,$MASTER_MYPORT,,SSL);
51 --enable_query_log
52
53 --connection default
54 --source ../include/hostcache_dump.inc
55
56 --disable_query_log
57 --error ER_ACCESS_DENIED_ERROR
58 connect (con2d,"::1",user_ssl_x509,good_password,test,$MASTER_MYPORT,,SSL);
59 --enable_query_log
60
61 --connection default
62 --source ../include/hostcache_dump.inc
63
64 drop user 'user_ssl'@'santa.claus.ipv6.example.com';
65 drop user 'user_ssl_x509'@'santa.claus.ipv6.example.com';
66
67 set global debug= default;
68