Skip to content

Commit d76b38d

Browse files
marcalffmarcalff
committed
Testing, in progress
1 parent 5f1fa52 commit d76b38d

29 files changed

+1387
-43
lines changed

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_again_allow.result‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
11+
select "Con1 is alive";
12+
Con1 is alive
13+
Con1 is alive
14+
select current_user();
15+
current_user()
16+
root@localhost
17+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_error_again";
18+
ERROR HY000: Can't get hostname for your address
19+
show global status like "%peer%";
20+
Variable_name Value
21+
Peer_address_errors 0
22+
select * from performance_schema.host_cache;
23+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
24+
ERROR HY000: Can't get hostname for your address
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
31+
drop user 'root'@'santa.claus.ipv4.example.com';
32+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_again_deny.result‎

Lines changed: 29 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,29 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_error_again";
17+
ERROR HY000: Can't get hostname for your address
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
ERROR HY000: Can't get hostname for your address
24+
show global status like "%peer%";
25+
Variable_name Value
26+
Peer_address_errors 0
27+
select * from performance_schema.host_cache;
28+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
29+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_bad_deny.result‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_bad_ipv4";
17+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
192.0.2.4 NULL 0 0 0 0 1 12 12
24+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
192.0.2.4 NULL 0 0 0 0 1 12 12
31+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_good_allow.result‎

Lines changed: 44 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,44 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
11+
select "Con1 is alive";
12+
Con1 is alive
13+
Con1 is alive
14+
select current_user();
15+
current_user()
16+
root@localhost
17+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
18+
select "Con2 is alive";
19+
Con2 is alive
20+
Con2 is alive
21+
select current_user();
22+
current_user()
23+
[email protected]
24+
show global status like "%peer%";
25+
Variable_name Value
26+
Peer_address_errors 0
27+
select * from performance_schema.host_cache;
28+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
29+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
30+
select "Con3 is alive";
31+
Con3 is alive
32+
Con3 is alive
33+
select current_user();
34+
current_user()
35+
[email protected]
36+
show global status like "%peer%";
37+
Variable_name Value
38+
Peer_address_errors 0
39+
select * from performance_schema.host_cache;
40+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
41+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
42+
revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
43+
drop user 'root'@'santa.claus.ipv4.example.com';
44+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_good_deny.result‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
17+
ERROR HY000: Host 'santa.claus.ipv4.example.com' is not allowed to connect to this MySQL server
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
24+
ERROR HY000: Host 'santa.claus.ipv4.example.com' is not allowed to connect to this MySQL server
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
31+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_noname_allow.result‎

Lines changed: 47 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,47 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
grant select on test.* to 'root'@'santa.claus.ipv4.example.com';
11+
grant select on test.* to 'root'@'192.0.2.4';
12+
select "Con1 is alive";
13+
Con1 is alive
14+
Con1 is alive
15+
select current_user();
16+
current_user()
17+
root@localhost
18+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_error_noname";
19+
select "Con2 is alive";
20+
Con2 is alive
21+
Con2 is alive
22+
select current_user();
23+
current_user()
24+
[email protected]
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
192.0.2.4 NULL 0 0 0 1 0 12 12
31+
select "Con3 is alive";
32+
Con3 is alive
33+
Con3 is alive
34+
select current_user();
35+
current_user()
36+
[email protected]
37+
show global status like "%peer%";
38+
Variable_name Value
39+
Peer_address_errors 0
40+
select * from performance_schema.host_cache;
41+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
42+
192.0.2.4 NULL 0 0 0 1 0 12 12
43+
revoke select on test.* from 'root'@'santa.claus.ipv4.example.com';
44+
revoke select on test.* from 'root'@'192.0.2.4';
45+
drop user 'root'@'santa.claus.ipv4.example.com';
46+
drop user 'root'@'192.0.2.4';
47+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_addrinfo_noname_deny.result‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_error_noname";
17+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
192.0.2.4 NULL 0 0 0 1 0 12 12
24+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
192.0.2.4 NULL 0 0 0 1 0 12 12
31+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_format.result‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_format_ipv4";
17+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
192.0.2.4 NULL 0 0 1 0 0 12 12
24+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
25+
show global status like "%peer%";
26+
Variable_name Value
27+
Peer_address_errors 0
28+
select * from performance_schema.host_cache;
29+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
30+
192.0.2.4 NULL 0 0 1 0 0 12 12
31+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_again_allow.result‎

Lines changed: 42 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,42 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
grant select on test.* to 'root'@'192.0.2.4';
11+
select "Con1 is alive";
12+
Con1 is alive
13+
Con1 is alive
14+
select current_user();
15+
current_user()
16+
root@localhost
17+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_error_again";
18+
select "Con2 is alive";
19+
Con2 is alive
20+
Con2 is alive
21+
select current_user();
22+
current_user()
23+
[email protected]
24+
show global status like "%peer%";
25+
Variable_name Value
26+
Peer_address_errors 0
27+
select * from performance_schema.host_cache;
28+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
29+
select "Con3 is alive";
30+
Con3 is alive
31+
Con3 is alive
32+
select current_user();
33+
current_user()
34+
[email protected]
35+
show global status like "%peer%";
36+
Variable_name Value
37+
Peer_address_errors 0
38+
select * from performance_schema.host_cache;
39+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
40+
revoke select on test.* from 'root'@'192.0.2.4';
41+
drop user 'root'@'192.0.2.4';
42+
set global debug= default;

‎mysql-test/suite/perfschema/r/hostcache_ipv4_nameinfo_again_deny.result‎

Lines changed: 44 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,44 @@
1+
call mtr.add_suppression("192.0.2.4");
2+
flush status;
3+
flush hosts;
4+
select @@global.debug;
5+
@@global.debug
6+
7+
show global status like "%peer%";
8+
Variable_name Value
9+
Peer_address_errors 0
10+
select "Con1 is alive";
11+
Con1 is alive
12+
Con1 is alive
13+
select current_user();
14+
current_user()
15+
root@localhost
16+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_error_again";
17+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
18+
show global status like "%peer%";
19+
Variable_name Value
20+
Peer_address_errors 0
21+
select * from performance_schema.host_cache;
22+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
23+
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MySQL server
24+
show global status like "%peer%";
25+
Variable_name Value
26+
Peer_address_errors 0
27+
select * from performance_schema.host_cache;
28+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
29+
set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
30+
ERROR HY000: Host 'santa.claus.ipv4.example.com' is not allowed to connect to this MySQL server
31+
show global status like "%peer%";
32+
Variable_name Value
33+
Peer_address_errors 0
34+
select * from performance_schema.host_cache;
35+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
36+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
37+
ERROR HY000: Host 'santa.claus.ipv4.example.com' is not allowed to connect to this MySQL server
38+
show global status like "%peer%";
39+
Variable_name Value
40+
Peer_address_errors 0
41+
select * from performance_schema.host_cache;
42+
IP HOST SUM_BLOCKING_ERRORS COUNT_NAMEINFO_ERRORS COUNT_FORMAT_ERRORS COUNT_ADDRINFO_ERRORS COUNT_FCRDNS_ERRORS COUNT_HOST_ACL_ERRORS COUNT_USER_ACL_ERRORS
43+
192.0.2.4 santa.claus.ipv4.example.com 0 0 0 0 0 12 12
44+
set global debug= default;

0 commit comments

Comments
 (0)