Debian Codegraph @

mysql-test/suite/group_replication/t/gr_ssl_on_admin_interface.test

raw
1 ################################################################################
2 # Base test to verify the basic SSL support on Group replication recovery when
3 # connecting to the admin interface.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Setup the first member with a recovery user that requires SSL.
8 # The memmber has the admin interface configured and is exporting
9 # the admin-port as the donor port.
10 # 2. Add some data and bootstrap start a group on M1.
11 # 3. Configure joining member (M2) to use SSL options on recovery. Start GR on
12 # M2. Check the data is there.
13 # 4. Clean up.
14 ################################################################################
15
16 --source include/have_group_replication_xcom_communication_stack.inc
17 --source include/have_group_replication_plugin.inc
18 --let $rpl_skip_group_replication_start= 1
19 --source include/group_replication.inc
20
21 --echo #
22 --echo # Setup the first member with a recovery user that requires SSL.
23 --echo # The memmber has the admin interface configured and is exporting
24 --echo # the admin-port as the donor port.
25 --echo #
26 --let $rpl_connection_name= server1
27 --source include/rpl_connection.inc
28
29 --let $_default_report_port= `SELECT @@GLOBAL.report_port`
30
31 --let $allow_rpl_inited= 1
32 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
33 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
34 --let $_admin_port= `SELECT @@GLOBAL.admin_port`
35 --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --report_port=$_admin_port
36 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $_admin_port ADMIN_PORT
37 --source include/restart_mysqld.inc
38
39 # Needed as we are not using rpl_restart_server.inc
40 --let $rpl_server_number= 1
41 --source include/rpl_reconnect.inc
42
43 # create a user for replication that requires ssl encryption
44 set session sql_log_bin=0;
45 CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL;
46 GRANT replication slave ON *.* TO 'rec_ssl_user'@'%';
47 GRANT SERVICE_CONNECTION_ADMIN ON *.* TO 'rec_ssl_user'@'%';
48 set session sql_log_bin=1;
49
50 --echo #
51 --echo # Add some data and start the member
52 --echo #
53
54 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
55 INSERT INTO t1 VALUES (1);
56
57 --source include/start_and_bootstrap_group_replication.inc
58
59 --let $assert_text= server1 is exporting admin-port for others members recovery
60 --let $assert_cond= "[SELECT MEMBER_PORT FROM performance_schema.replication_group_members]" = "$_admin_port"
61 --source include/assert.inc
62
63
64 --echo #
65 --echo # Configure a joining member to use SSL options on recovery and start it
66 --echo #
67 --let $rpl_connection_name= server2
68 --source include/rpl_connection.inc
69 --let $conf_rec_use_ssl= `SELECT @@GLOBAL.group_replication_recovery_use_ssl;`
70 --let $conf_rec_ssl_ca= `SELECT @@GLOBAL.group_replication_recovery_ssl_ca;`
71 --let $conf_rec_ssl_cert= `SELECT @@GLOBAL.group_replication_recovery_ssl_cert;`
72 --let $conf_rec_ssl_key= `SELECT @@GLOBAL.group_replication_recovery_ssl_key;`
73
74 --disable_warnings
75 CHANGE REPLICATION SOURCE TO SOURCE_USER="rec_ssl_user" FOR CHANNEL "group_replication_recovery";
76 --enable_warnings
77
78 --eval SET GLOBAL group_replication_recovery_use_ssl=1
79 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
80 --eval SET GLOBAL group_replication_recovery_ssl_ca= '$MYSQL_TEST_DIR/std_data/ca-cert-verify-san.pem'
81 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
82 --eval SET GLOBAL group_replication_recovery_ssl_cert= '$MYSQL_TEST_DIR/std_data/client-cert-verify-san.pem'
83 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
84 --eval SET GLOBAL group_replication_recovery_ssl_key= '$MYSQL_TEST_DIR/std_data/client-key-verify-san.pem'
85
86 --source include/start_group_replication.inc
87
88 --echo #
89 --echo # Check the data is there
90 --echo #
91
92 --let $assert_text= On the recovered member, the table should exist and have 1 elements;
93 --let $assert_cond= [select count(*) from t1] = 1;
94 --source include/assert.inc
95
96 --echo #
97 --echo # Clean up
98 --echo #
99
100 --disable_query_log
101 --eval SET @@GLOBAL.group_replication_recovery_use_ssl= $conf_rec_use_ssl
102 --eval SET @@GLOBAL.group_replication_recovery_ssl_ca= "$conf_rec_ssl_ca"
103 --eval SET @@GLOBAL.group_replication_recovery_ssl_cert= "$conf_rec_ssl_cert"
104 --eval SET @@GLOBAL.group_replication_recovery_ssl_key= "$conf_rec_ssl_key"
105 --enable_query_log
106
107 --let $rpl_connection_name= server1
108 --source include/rpl_connection.inc
109
110 set session sql_log_bin=0;
111 DROP USER 'rec_ssl_user';
112 set session sql_log_bin=1;
113
114 DROP TABLE t1;
115
116 --let $allow_rpl_inited= 1
117 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
118 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
119 --let $_admin_port= `SELECT @@GLOBAL.admin_port`
120 --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --report_port=$_default_report_port
121 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $_default_report_port ADMIN_PORT
122 --source include/restart_mysqld.inc
123
124 # Needed as we are not using rpl_restart_server.inc
125 --let $rpl_server_number= 1
126 --source include/rpl_reconnect.inc
127
128 --source include/group_replication_end.inc