Debian Codegraph @

mysql-test/suite/sys_vars/t/proxy_protocol_networks_grant.test

raw
1 --source include/not_embedded.inc
2
3 SET @global=@@global.proxy_protocol_networks;
4
5 --echo #
6 --echo # MDEV-21961 Bind CONNECTION ADMIN to a number of global system variables
7 --echo #
8
9 --echo # Test that "SET proxy_protocol_networks" is not allowed without CONNECTION ADMIN
10
11 CREATE USER user1@localhost;
12 GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
13 REVOKE CONNECTION ADMIN ON *.* FROM user1@localhost;
14 --connect(user1,localhost,user1,,)
15 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
16 SET GLOBAL proxy_protocol_networks="";
17 --error ER_GLOBAL_VARIABLE
18 SET proxy_protocol_networks="";
19 --error ER_GLOBAL_VARIABLE
20 SET SESSION proxy_protocol_networks="";
21 --disconnect user1
22 --connection default
23 DROP USER user1@localhost;
24
25 --echo # Test that "SET proxy_protocol_networks" is allowed with CONNECTION ADMIN
26
27 CREATE USER user1@localhost;
28 GRANT CONNECTION ADMIN ON *.* TO user1@localhost;
29 --connect(user1,localhost,user1,,)
30 SET GLOBAL proxy_protocol_networks="";
31 --error ER_GLOBAL_VARIABLE
32 SET proxy_protocol_networks="";
33 --error ER_GLOBAL_VARIABLE
34 SET SESSION proxy_protocol_networks="";
35 --disconnect user1
36 --connection default
37 DROP USER user1@localhost;
38
39 --echo #
40 --echo # MDEV-39658 ASAN crash on invalid proxy_protocol_networks value
41 --echo #
42 --error ER_PARSE_ERROR
43 SET GLOBAL proxy_protocol_networks='1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0';
44
45 --echo # End of 10.6 tests
46
47 SET @@global.proxy_protocol_networks=@global;