Debian Codegraph @

mysql-test/suite/group_replication/r/gr_ssl_mode_tls_source_mysql_admin.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 ############################################################
8 # 1. Start one member with GCS SSL enabled.
9 [connection server1]
10 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
11 SET GLOBAL group_replication_ssl_mode= REQUIRED;
12 include/start_and_bootstrap_group_replication.inc
13 Occurrences of 'Group communication SSL configuration: group_replication_ssl_mode: "REQUIRED"' in the input file: 1
14
15 ############################################################
16 # 2. Start a second member with GCS SSL disabled, the member
17 # will fail to join the group.
18 [connection server2]
19 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
20 SET GLOBAL group_replication_ssl_mode= DISABLED;
21 START GROUP_REPLICATION;
22 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
23 Occurrences of 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"' in the input file: 1
24
25 ############################################################
26 # 3. Start the second member with GCS SSL enabled, the member
27 # will be able to join the group.
28 SET GLOBAL group_replication_ssl_mode= REQUIRED;
29 include/start_group_replication.inc
30 include/rpl_gr_wait_for_number_of_members.inc
31 Occurrences of 'Group communication SSL configuration: group_replication_ssl_mode: "REQUIRED"' in the input file: 1
32 include/stop_group_replication.inc
33
34 ############################################################
35 # 4. Start the second member with GCS SSL enabled and
36 # validating server certificate against the CA, the
37 # member will be able to join the group.
38 SET GLOBAL group_replication_ssl_mode= VERIFY_CA;
39 include/start_group_replication.inc
40 include/rpl_gr_wait_for_number_of_members.inc
41 Occurrences of 'Group communication SSL configuration: group_replication_ssl_mode: "VERIFY_CA"' in the input file: 1
42 include/stop_group_replication.inc
43
44 ############################################################
45 # 5. Start the second member with GCS SSL enabled and
46 # validating server certificate against the CA plus
47 # validating that server hostname matches server
48 # certificate hostname, the member will be able to join
49 # the group.
50 SET GLOBAL group_replication_ssl_mode= VERIFY_IDENTITY;
51 include/start_group_replication.inc
52 include/rpl_gr_wait_for_number_of_members.inc
53 Occurrences of 'Group communication SSL configuration: group_replication_ssl_mode: "VERIFY_IDENTITY"' in the input file: 1
54 include/stop_group_replication.inc
55
56 ############################################################
57 # 6. Clean up.
58 [connection server1]
59 SET GLOBAL group_replication_ssl_mode= @group_replication_ssl_mode_save;
60 [connection server2]
61 SET GLOBAL group_replication_ssl_mode= @group_replication_ssl_mode_save;
62 include/group_replication_end.inc