Debian Codegraph @

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