################################################################################ # Base test to verify the basic SSL support on Group replication recovery when # connecting to the admin interface. # # Test: # 0. The test requires two servers: M1 and M2. # 1. Setup the first member with a recovery user that requires SSL. # The memmber has the admin interface configured and is exporting # the admin-port as the donor port. # 2. Add some data and bootstrap start a group on M1. # 3. Configure joining member (M2) to use SSL options on recovery. Start GR on # M2. Check the data is there. # 4. Clean up. ################################################################################ --source include/have_group_replication_xcom_communication_stack.inc --source include/have_group_replication_plugin.inc --let $rpl_skip_group_replication_start= 1 --source include/group_replication.inc --echo # --echo # Setup the first member with a recovery user that requires SSL. --echo # The memmber has the admin interface configured and is exporting --echo # the admin-port as the donor port. --echo # --let $rpl_connection_name= server1 --source include/rpl_connection.inc --let $_default_report_port= `SELECT @@GLOBAL.report_port` --let $allow_rpl_inited= 1 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address` --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds` --let $_admin_port= `SELECT @@GLOBAL.admin_port` --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --report_port=$_admin_port --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $_admin_port ADMIN_PORT --source include/restart_mysqld.inc # Needed as we are not using rpl_restart_server.inc --let $rpl_server_number= 1 --source include/rpl_reconnect.inc # create a user for replication that requires ssl encryption set session sql_log_bin=0; CREATE USER 'rec_ssl_user'@'%' REQUIRE SSL; GRANT replication slave ON *.* TO 'rec_ssl_user'@'%'; GRANT SERVICE_CONNECTION_ADMIN ON *.* TO 'rec_ssl_user'@'%'; set session sql_log_bin=1; --echo # --echo # Add some data and start the member --echo # CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES (1); --source include/start_and_bootstrap_group_replication.inc --let $assert_text= server1 is exporting admin-port for others members recovery --let $assert_cond= "[SELECT MEMBER_PORT FROM performance_schema.replication_group_members]" = "$_admin_port" --source include/assert.inc --echo # --echo # Configure a joining member to use SSL options on recovery and start it --echo # --let $rpl_connection_name= server2 --source include/rpl_connection.inc --let $conf_rec_use_ssl= `SELECT @@GLOBAL.group_replication_recovery_use_ssl;` --let $conf_rec_ssl_ca= `SELECT @@GLOBAL.group_replication_recovery_ssl_ca;` --let $conf_rec_ssl_cert= `SELECT @@GLOBAL.group_replication_recovery_ssl_cert;` --let $conf_rec_ssl_key= `SELECT @@GLOBAL.group_replication_recovery_ssl_key;` --disable_warnings CHANGE REPLICATION SOURCE TO SOURCE_USER="rec_ssl_user" FOR CHANNEL "group_replication_recovery"; --enable_warnings --eval SET GLOBAL group_replication_recovery_use_ssl=1 --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET GLOBAL group_replication_recovery_ssl_ca= '$MYSQL_TEST_DIR/std_data/ca-cert-verify-san.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET GLOBAL group_replication_recovery_ssl_cert= '$MYSQL_TEST_DIR/std_data/client-cert-verify-san.pem' --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --eval SET GLOBAL group_replication_recovery_ssl_key= '$MYSQL_TEST_DIR/std_data/client-key-verify-san.pem' --source include/start_group_replication.inc --echo # --echo # Check the data is there --echo # --let $assert_text= On the recovered member, the table should exist and have 1 elements; --let $assert_cond= [select count(*) from t1] = 1; --source include/assert.inc --echo # --echo # Clean up --echo # --disable_query_log --eval SET @@GLOBAL.group_replication_recovery_use_ssl= $conf_rec_use_ssl --eval SET @@GLOBAL.group_replication_recovery_ssl_ca= "$conf_rec_ssl_ca" --eval SET @@GLOBAL.group_replication_recovery_ssl_cert= "$conf_rec_ssl_cert" --eval SET @@GLOBAL.group_replication_recovery_ssl_key= "$conf_rec_ssl_key" --enable_query_log --let $rpl_connection_name= server1 --source include/rpl_connection.inc set session sql_log_bin=0; DROP USER 'rec_ssl_user'; set session sql_log_bin=1; DROP TABLE t1; --let $allow_rpl_inited= 1 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address` --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds` --let $_admin_port= `SELECT @@GLOBAL.admin_port` --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 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $_default_report_port ADMIN_PORT --source include/restart_mysqld.inc # Needed as we are not using rpl_restart_server.inc --let $rpl_server_number= 1 --source include/rpl_reconnect.inc --source include/group_replication_end.inc