Debian Codegraph @

mysql-test/suite/group_replication/r/gr_ssl_tls13.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,TLSv1.1,TLSv1.2,TLSv1.3'
44 # server2: --tls-version='TLSv1,TLSv1.1,TLSv1.2'
45 # Outcome: group will work.
46 [connection server1]
47 SET @@GLOBAL.tls_version= 'TLSv1,TLSv1.1,TLSv1.2,TLSv1.3';
48 ALTER INSTANCE RELOAD TLS;
49 Warnings:
50 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
51 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
52 include/start_and_bootstrap_group_replication.inc
53 [connection server2]
54 SET @@GLOBAL.tls_version= 'TLSv1,TLSv1.1,TLSv1.2';
55 ALTER INSTANCE RELOAD TLS;
56 Warnings:
57 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
58 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
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,TLSv1.1,TLSv1.2'
71 # Outcome: group will not work.
72 [connection server1]
73 SET @@GLOBAL.tls_version= 'TLSv1.3';
74 ALTER INSTANCE RELOAD TLS;
75 include/start_and_bootstrap_group_replication.inc
76 [connection server2]
77 SET @@GLOBAL.tls_version= 'TLSv1,TLSv1.1,TLSv1.2';
78 ALTER INSTANCE RELOAD TLS;
79 Warnings:
80 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
81 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
82 START GROUP_REPLICATION;
83 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
84 [connection server1]
85 include/stop_group_replication.inc
86
87 ############################################################
88 # 4. 2 members group with OpenSSL 1.1.1
89 # No --tls-ciphersuites
90 # server1: --tls-version='TLSv1.3'
91 # server2: --tls-version='TLSv1.3'
92 # Outcome: group will work.
93 [connection server1]
94 SET @@GLOBAL.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 ALTER INSTANCE RELOAD TLS;
100 include/start_group_replication.inc
101 include/rpl_gr_wait_for_number_of_members.inc
102 [connection server1]
103 include/stop_group_replication.inc
104 [connection server2]
105 include/stop_group_replication.inc
106
107 ############################################################
108 # 5. 2 members group with OpenSSL 1.1.1
109 # --tls-ciphersuites='TLS_AES_256_GCM_SHA384'
110 # server1: --tls-version='TLSv1,TLSv1.1,TLSv1.2,TLSv1.3'
111 # server2: --tls-version='TLSv1,TLSv1.1,TLSv1.2,TLSv1.3'
112 # Outcome: group will work.
113 [connection server1]
114 SET @@GLOBAL.tls_version= 'TLSv1,TLSv1.1,TLSv1.2,TLSv1.3';
115 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
116 ALTER INSTANCE RELOAD TLS;
117 Warnings:
118 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
119 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
120 include/start_and_bootstrap_group_replication.inc
121 [connection server2]
122 SET @@GLOBAL.tls_version= 'TLSv1,TLSv1.1,TLSv1.2,TLSv1.3';
123 SET @@GLOBAL.tls_ciphersuites= 'TLS_AES_256_GCM_SHA384';
124 ALTER INSTANCE RELOAD TLS;
125 Warnings:
126 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
127 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
128 include/start_group_replication.inc
129 include/rpl_gr_wait_for_number_of_members.inc
130 [connection server1]
131 include/stop_group_replication.inc
132 [connection server2]
133 include/stop_group_replication.inc
134
135 ############################################################
136 # 6. 2 members group with OpenSSL 1.1.1
137 # --tls-ciphersuites= '', which will disable all ciphers.
138 # No --tls-version
139 # Outcome: group will not work.
140 [connection server1]
141 SET @@GLOBAL.tls_ciphersuites= '';
142 ALTER INSTANCE RELOAD TLS;
143 Warnings:
144 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
145 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
146 START GROUP_REPLICATION;
147 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
148 Pattern found.
149
150 ############################################################
151 # 7. Clean up.
152 [connection server1]
153 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
154 SET @@GLOBAL.tls_version= @tls_version_save;
155 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
156 ALTER INSTANCE RELOAD TLS;
157 Warnings:
158 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
159 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
160 [connection server2]
161 SET @@GLOBAL.group_replication_ssl_mode= @group_replication_ssl_mode_save;
162 SET @@GLOBAL.tls_version= @tls_version_save;
163 SET @@GLOBAL.tls_ciphersuites= @tls_ciphersuites_save;
164 ALTER INSTANCE RELOAD TLS;
165 Warnings:
166 Warning 4038 A deprecated TLS version TLSv1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
167 Warning 4038 A deprecated TLS version TLSv1.1 is enabled for channel mysql_main. Please use TLSv1.2 or higher.
168 include/group_replication_end.inc