Debian Codegraph @

mysql-test/suite/sys_vars/r/proxy_protocol_networks_grant.result

raw
1 SET @global=@@global.proxy_protocol_networks;
2 #
3 # MDEV-21961 Bind CONNECTION ADMIN to a number of global system variables
4 #
5 # Test that "SET proxy_protocol_networks" is not allowed without CONNECTION ADMIN
6 CREATE USER user1@localhost;
7 GRANT ALL PRIVILEGES ON *.* TO user1@localhost;
8 REVOKE CONNECTION ADMIN ON *.* FROM user1@localhost;
9 connect user1,localhost,user1,,;
10 SET GLOBAL proxy_protocol_networks="";
11 ERROR 42000: Access denied; you need (at least one of) the CONNECTION ADMIN privilege(s) for this operation
12 SET proxy_protocol_networks="";
13 ERROR HY000: Variable 'proxy_protocol_networks' is a GLOBAL variable and should be set with SET GLOBAL
14 SET SESSION proxy_protocol_networks="";
15 ERROR HY000: Variable 'proxy_protocol_networks' is a GLOBAL variable and should be set with SET GLOBAL
16 disconnect user1;
17 connection default;
18 DROP USER user1@localhost;
19 # Test that "SET proxy_protocol_networks" is allowed with CONNECTION ADMIN
20 CREATE USER user1@localhost;
21 GRANT CONNECTION ADMIN ON *.* TO user1@localhost;
22 connect user1,localhost,user1,,;
23 SET GLOBAL proxy_protocol_networks="";
24 SET proxy_protocol_networks="";
25 ERROR HY000: Variable 'proxy_protocol_networks' is a GLOBAL variable and should be set with SET GLOBAL
26 SET SESSION proxy_protocol_networks="";
27 ERROR HY000: Variable 'proxy_protocol_networks' is a GLOBAL variable and should be set with SET GLOBAL
28 disconnect user1;
29 connection default;
30 DROP USER user1@localhost;
31 #
32 # MDEV-39658 ASAN crash on invalid proxy_protocol_networks value
33 #
34 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';
35 ERROR 42000: Error parsing proxy_protocol_networks parameter, near '1'
36 # End of 10.6 tests
37 SET @@global.proxy_protocol_networks=@global;