Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 @ssl_cipher_save= @@GLOBAL.ssl_cipher;
13 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
14 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
15 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
16 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
17 [connection server2]
18 SET @tls_version_save= @@GLOBAL.tls_version;
19 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
20 SET @ssl_cipher_save= @@GLOBAL.ssl_cipher;
21 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
22 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
23 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
24 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
25 SET SESSION sql_log_bin= 0;
26 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
27 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
28 call mtr.add_suppression("Timeout on wait for view after joining group");
29 call mtr.add_suppression("Error connecting to the local group communication engine instance");
30 SET SESSION sql_log_bin= 1;
31 [connection server3]
32 SET @tls_version_save= @@GLOBAL.tls_version;
33 SET @tls_ciphersuites_save= @@GLOBAL.tls_ciphersuites;
34 SET @ssl_cipher_save= @@GLOBAL.ssl_cipher;
35 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
36 SET @group_replication_recovery_tls_version_save= @@GLOBAL.group_replication_recovery_tls_version;
37 SET @group_replication_recovery_tls_ciphersuites_save= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
38 SET @@GLOBAL.group_replication_ssl_mode= REQUIRED;
39 SET SESSION sql_log_bin= 0;
40 call mtr.add_suppression("\\[GCS\\] Error connecting to all peers. Member join failed. Local port:*");
41 call mtr.add_suppression("\\[GCS\\] The member was unable to join the group.*");
42 call mtr.add_suppression("Timeout on wait for view after joining group");
43 call mtr.add_suppression("Error connecting to the local group communication engine instance");
44 SET SESSION sql_log_bin= 1;
45
46 ############################################################
47 # 1. 3 members group with OpenSSL 1.1.1
48 # Verify that it is possible to join a node which has TLS version 1.3
49 # and lower versions to a group which doesn't have this version.
50 # No --tls-ciphersuites
51 # server1: --tls-version='TLSv1.2'
52 # server2: --tls-version='TLSv1.2'
53 # server3: --tls-version='TLSv1.2,TLSv1.3'
54 # Outcome: group will work.
55 [connection server1]
56 SET @@GLOBAL.tls_version= 'TLSv1.2';
57 ALTER INSTANCE RELOAD TLS;
58 include/start_and_bootstrap_group_replication.inc
59 [connection server2]
60 SET @@GLOBAL.tls_version= 'TLSv1.2';
61 ALTER INSTANCE RELOAD TLS;
62 include/start_group_replication.inc
63 [connection server3]
64 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
65 ALTER INSTANCE RELOAD TLS;
66 include/start_group_replication.inc
67 include/rpl_gr_wait_for_number_of_members.inc
68 [connection server1]
69 include/stop_group_replication.inc
70 [connection server2]
71 include/stop_group_replication.inc
72 [connection server3]
73 include/stop_group_replication.inc
74
75 ############################################################
76 # 2. 2 members group with OpenSSL 1.1.1
77 # Verify that it is possible to start group replication when :
78 # * TLS version is 1.3
79 # * A TLS ciphersuite compatible with this version is enabled
80 # --tls-version='TLSv1.3'
81 # --tls-ciphersuites='TLS_AES_128_CCM_SHA256' (disabled by default)
82 # Outcome: group will work.
83 [connection server1]
84 SET @@GLOBAL.tls_version= 'TLSv1.3';
85 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
86 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
87 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
88 ALTER INSTANCE RELOAD TLS;
89 include/start_and_bootstrap_group_replication.inc
90 [connection server2]
91 SET @@GLOBAL.tls_version= 'TLSv1.3';
92 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
93 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
94 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_SHA256';
95 ALTER INSTANCE RELOAD TLS;
96 include/start_group_replication.inc
97 include/rpl_gr_wait_for_number_of_members.inc
98 [connection server1]
99 include/stop_group_replication.inc
100 [connection server2]
101 include/stop_group_replication.inc
102
103 ############################################################
104 # 3. 3 members group with OpenSSL 1.1.1
105 # Verify that it is possible to start group replication when:
106 # * TLS version is 1.3
107 # * Intersection of the allowed TLS chipersuites is non empty and valid.
108 # --tls-version='TLSv1.3'
109 # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
110 # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
111 # server3: --tls-ciphersuites='TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384'
112 # Outcome: group will work.
113 [connection server1]
114 SET @@GLOBAL.tls_version= 'TLSv1.3';
115 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
116 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
117 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
118 ALTER INSTANCE RELOAD TLS;
119 include/start_and_bootstrap_group_replication.inc
120 [connection server2]
121 SET @@GLOBAL.tls_version= 'TLSv1.3';
122 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256';
123 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
124 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
125 ALTER INSTANCE RELOAD TLS;
126 include/start_group_replication.inc
127 [connection server3]
128 SET @@GLOBAL.tls_version= 'TLSv1.3';
129 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384';
130 SET @@GLOBAL.group_replication_recovery_tls_version= 'TLSv1.3';
131 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= 'TLS_AES_128_CCM_8_SHA256: TLS_AES_256_GCM_SHA384';
132 ALTER INSTANCE RELOAD TLS;
133 include/start_group_replication.inc
134 include/rpl_gr_wait_for_number_of_members.inc
135 [connection server1]
136 include/stop_group_replication.inc
137 [connection server2]
138 include/stop_group_replication.inc
139 [connection server3]
140 include/stop_group_replication.inc
141
142 ############################################################
143 # 4. 3 members group with OpenSSL 1.1.1
144 # Verify that is is possible to join a node to a group when:
145 # * List of TLS version of the group includes v1.3 and lower versions
146 # * TLS chipersuites of the node is compatible with the group,
147 # therefore TLS v1.3 is supported
148 # * SLL cipher of the node is incompatible with the group, therefore
149 # TLS versions lower than 1.3 are not supported
150 # --tls-version='TLSv1.2,TLSv1.3'
151 # server1: --tls-ciphersuites='TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384'
152 # server1: --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384'
153 # server2: --tls-ciphersuites='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256'
154 # server2: --ssl-cipher='DHE-RSA-AES256-GCM-SHA384'
155 # server3: --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
156 # server3: --ssl-cipher='DHE-RSA-AES128-GCM-SHA256'
157 # Outcome: group will work.
158 [connection server1]
159 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
160 SET @@GLOBAL.ssl_cipher= 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384';
161 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_128_GCM_SHA256:TLS_AES_256_GCM_SHA384';
162 ALTER INSTANCE RELOAD TLS;
163 include/start_and_bootstrap_group_replication.inc
164 [connection server2]
165 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
166 SET @@GLOBAL.ssl_cipher= 'DHE-RSA-AES256-GCM-SHA384';
167 SET @@GLOBAL.tls_ciphersuites ='TLS_AES_256_GCM_SHA384:TLS_AES_128_CCM_SHA256';
168 ALTER INSTANCE RELOAD TLS;
169 include/start_group_replication.inc
170 [connection server3]
171 SET @@GLOBAL.tls_version= 'TLSv1.2,TLSv1.3';
172 SET @@GLOBAL.ssl_cipher = 'DHE-RSA-AES128-GCM-SHA256';
173 SET @@GLOBAL.tls_ciphersuites = 'TLS_AES_256_GCM_SHA384';
174 ALTER INSTANCE RELOAD TLS;
175 include/start_group_replication.inc
176 include/rpl_gr_wait_for_number_of_members.inc
177 [connection server1]
178 include/stop_group_replication.inc
179 [connection server2]
180 include/stop_group_replication.inc
181 [connection server3]
182 include/stop_group_replication.inc
183
184 ############################################################
185 # 5. Clean up.
186 [connection server1]
187 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
188 SET @@GLOBAL.tls_version= @tls_version_save;
189 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
190 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
191 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
192 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
193 ALTER INSTANCE RELOAD TLS;
194 [connection server2]
195 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
196 SET @@GLOBAL.tls_version= @tls_version_save;
197 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
198 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
199 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
200 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
201 ALTER INSTANCE RELOAD TLS;
202 [connection server3]
203 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
204 SET @@GLOBAL.tls_version= @tls_version_save;
205 SET @@GLOBAL.tls_ciphersuites = @tls_ciphersuites_save;
206 SET @@GLOBAL.ssl_cipher = @ssl_cipher_save;
207 SET @@GLOBAL.group_replication_recovery_tls_version= @group_replication_recovery_tls_version_save;
208 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @group_replication_recovery_tls_ciphersuites_save;
209 ALTER INSTANCE RELOAD TLS;
210 include/group_replication_end.inc