Debian Codegraph @

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

raw
1 --disable_query_log
2 CALL mtr.add_suppression("Failed to initialize TLS for channel: mysql_admin");
3 CALL mtr.add_suppression("Failed to set up SSL because of the following SSL library error");
4 --enable_query_log
5
6 #
7 # only global
8 #
9 select @@global.admin_address;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.admin_address;
12 show global variables like 'admin_address';
13 show session variables like 'admin_address';
14 --disable_warnings
15 select * from performance_schema.global_variables where variable_name='admin_address';
16 select * from performance_schema.session_variables where variable_name='admin_address';
17 select * from performance_schema.variables_info where variable_name='admin_address';
18 --enable_warnings
19
20 #
21 # show that it's read-only
22 #
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set global admin_address='::1';
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 set session admin_port='::1';
27 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
28 set persist admin_port='::1';
29
30 #
31 # Set the option and verify that it is reflected
32 #
33 --let $PORT_OFFSET = 1
34 --expr $ADMIN_PORT = $MASTER_MYPORT + $PORT_OFFSET
35 --let $restart_parameters=restart: --skip-name-resolve --admin-address=127.0.0.1 --admin_port=$ADMIN_PORT
36 --replace_result $ADMIN_PORT ADMIN_PORT
37 --source include/restart_mysqld.inc
38
39 --disable_warnings
40 select * from performance_schema.global_variables where variable_name='admin_address';
41 select * from performance_schema.session_variables where variable_name='admin_address';
42 --enable_warnings
43
44 --echo #
45 --echo # Starting mysqld in the regular mode...
46 --echo #
47 --let $restart_parameters=
48 --source include/restart_mysqld.inc