Debian Codegraph @

mysql-test/suite/group_replication/r/gr_ssl_tls13_xcom.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 # 0. Configure members to use encryption and save defaults.
9 [connection server1]
10 SET @tls_version_save= @@GLOBAL.tls_version;
11 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
12 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
13 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
14 [connection server2]
15 SET @tls_version_save= @@GLOBAL.tls_version;
16 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
17 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
18 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
19 SET SESSION sql_log_bin= 0;
20 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
21 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
22 call mtr.add_suppression("Timeout on wait for view after joining group");
23 SET SESSION sql_log_bin= 1;
24
25 ############################################################
26 # 1. 2 members group with OpenSSL 1.1.1
27 # No --tls-ciphersuites
28 # No --tls-version
29 # Outcome: group will work.
30 [connection server1]
31 include/start_and_bootstrap_group_replication.inc
32 [connection server2]
33 include/start_group_replication.inc
34 include/rpl_gr_wait_for_number_of_members.inc
35 [connection server1]
36 include/stop_group_replication.inc
37 [connection server2]
38 include/stop_group_replication.inc
39
40 ############################################################
41 # 2. 2 members group with OpenSSL 1.1.1
42 # No --tls-ciphersuites
43 # server1: --tls-version='TLSv1.2,TLSv1.3'
44 # server2: --tls-version='TLSv1.2'
45 # Outcome: group will work.
46 [connection server1]
47 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
48 ALTER INSTANCE RELOAD TLS;
49 include/start_and_bootstrap_group_replication.inc
50 [connection server2]
51 SET @@GLOBAL.tls_version= 'TLSv1.2';
52 ALTER INSTANCE RELOAD TLS;
53 include/start_group_replication.inc
54 include/rpl_gr_wait_for_number_of_members.inc
55 [connection server1]
56 include/stop_group_replication.inc
57 [connection server2]
58 include/stop_group_replication.inc
59
60 ############################################################
61 # 3. 2 members group with OpenSSL 1.1.1
62 # No --tls-ciphersuites
63 # server1: --tls-version='TLSv1.3'
64 # server2: --tls-version='TLSv1.2'
65 # Outcome: group will not work.
66 [connection server1]
67 SET @@GLOBAL.tls_version= 'TLSv1.3';
68 ALTER INSTANCE RELOAD TLS;
69 include/start_and_bootstrap_group_replication.inc
70 [connection server2]
71 SET @@GLOBAL.tls_version= 'TLSv1.2';
72 ALTER INSTANCE RELOAD TLS;
73 START GROUP_REPLICATION;
74 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
75 [connection server1]
76 include/stop_group_replication.inc
77
78 ############################################################
79 # 4. 2 members group with OpenSSL 1.1.1
80 # No --tls-ciphersuites
81 # server1: --tls-version='TLSv1.3'
82 # server2: --tls-version='TLSv1.3'
83 # Outcome: group will work.
84 [connection server1]
85 SET @@GLOBAL.tls_version= 'TLSv1.3';
86 ALTER INSTANCE RELOAD TLS;
87 include/start_and_bootstrap_group_replication.inc
88 [connection server2]
89 SET @@GLOBAL.tls_version= 'TLSv1.3';
90 ALTER INSTANCE RELOAD TLS;
91 include/start_group_replication.inc
92 include/rpl_gr_wait_for_number_of_members.inc
93 [connection server1]
94 include/stop_group_replication.inc
95 [connection server2]
96 include/stop_group_replication.inc
97
98 ############################################################
99 # 5. 2 members group with OpenSSL 1.1.1
100 # --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
101 # server1: --tls-version='TLSv1.2,TLSv1.3'
102 # server2: --tls-version='TLSv1.2,TLSv1.3'
103 # Outcome: group will work.
104 [connection server1]
105 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
106 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
107 ALTER INSTANCE RELOAD TLS;
108 include/start_and_bootstrap_group_replication.inc
109 [connection server2]
110 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
111 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
112 ALTER INSTANCE RELOAD TLS;
113 include/start_group_replication.inc
114 include/rpl_gr_wait_for_number_of_members.inc
115 [connection server1]
116 include/stop_group_replication.inc
117 [connection server2]
118 include/stop_group_replication.inc
119
120 ############################################################
121 # 6. 2 members group with OpenSSL 1.1.1
122 # --tls-ciphersuites= '', which will disable all ciphers.
123 # No --tls-version
124 # Outcome: group will not work.
125 [connection server1]
126 SET @@GLOBAL.tls_ciphersuites= '';
127 ALTER INSTANCE RELOAD TLS;
128 START GROUP_REPLICATION;
129 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
130 Pattern found.
131
132 ############################################################
133 # 7. Clean up.
134 [connection server1]
135 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
136 SET @@GLOBAL.tls_version= @tls_version_save;
137 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
138 ALTER INSTANCE RELOAD TLS;
139 [connection server2]
140 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
141 SET @@GLOBAL.tls_version= @tls_version_save;
142 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
143 ALTER INSTANCE RELOAD TLS;
144 include/group_replication_end.inc