Debian Codegraph @

mysql-test/suite/auth_sec/t/admin_channel_tls.test

raw
1 # Save the initial number of concurrent sessions
2 --source include/count_sessions.inc
3 # Allowed cipher regex
4 --source include/allowed_ciphers.inc
5
6 --echo # Setup
7
8 --disable_query_log
9 CALL mtr.add_suppression("Failed to initialize TLS for channel: mysql_admin");
10 CALL mtr.add_suppression("Failed to set up SSL because of the following SSL library error");
11 --enable_query_log
12
13 --echo # Create test user
14 CREATE USER admin_user IDENTIFIED BY 'abcd';
15 --echo # Grant required privilege so that test user
16 --echo # can connect to server using admin interface
17 GRANT SERVICE_CONNECTION_ADMIN ON *.* TO admin_user;
18
19 --echo # Restarting server with admin interface
20 --replace_result $MASTER_ADMINPORT MASTER_ADMINPORT
21 --let $restart_parameters="restart: --admin-address=127.0.0.1 --admin-port=$MASTER_ADMINPORT"
22 --source include/restart_mysqld_no_echo.inc
23
24 --echo # 1. Admin channel should reuse main channel's TLS
25 # context if TLS is not configured for admin channel
26
27 --echo # Verify that TLS is not configured for admin channel
28 --query_vertical SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled'
29
30 --echo # Try to connect using TLS
31 --replace_regex $ALLOWED_CIPHERS_REGEX
32 --exec $MYSQL --host=127.0.0.1 --port=$MASTER_ADMINPORT --user=admin_user -pabcd --ssl-mode=REQUIRED -e "SELECT 1"
33
34 --echo # 2. If any of the parameter for admin channel is configured,
35 --echo # server channel's TLS context should not be used. Even if
36 --echo # configuration for admin channel is not correct and TLS
37 --echo # is not enabled for admin channel
38
39 --echo # Restarting server with admin interface without TLS support
40 --replace_result $MASTER_ADMINPORT MASTER_ADMINPORT
41 --let $restart_parameters="restart: --admin-address=127.0.0.1 --admin-port=$MASTER_ADMINPORT --admin-ssl=OFF"
42 --source include/restart_mysqld_no_echo.inc
43
44 --echo # Verify that TLS is not configured for admin channel
45 --query_vertical SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled'
46
47 --echo # Try to connect using TLS
48 --error 1 # CR_SSL_CONNECTION_ERROR
49 --exec $MYSQL --host=127.0.0.1 --port=$MASTER_ADMINPORT --user=admin_user -pabcd --ssl-mode=REQUIRED -e "SELECT 1;"
50
51 --echo # Restarting server with admin interface with TLS support
52 --replace_result $MASTER_ADMINPORT MASTER_ADMINPORT
53 --let $restart_parameters="restart: --admin-address=127.0.0.1 --ssl=OFF --admin-port=$MASTER_ADMINPORT --admin-ssl-ca=$MYSQL_TEST_DIR/std_data/ca-cert-verify.pem --admin-ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert-verify-pass.pem --admin-ssl-key=$MYSQL_TEST_DIR/std_data/server-key-verify-pass.pem"
54 --source include/restart_mysqld_no_echo.inc
55
56 --echo # Verify that TLS is configured for admin channel
57 --query_vertical SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled'
58
59 --echo # Try to connect using TLS
60 --replace_regex $ALLOWED_CIPHERS_REGEX
61 --exec $MYSQL --host=127.0.0.1 --port=$MASTER_ADMINPORT --user=admin_user -pabcd --ssl-mode=REQUIRED -e "SELECT 1"
62
63 --echo # 3. Admin channel TLS parameters can be changed at runtime check if
64 --echo # new sessions get the new vals Save the defaults in admin_conn
65
66 --echo # Restarting server with admin interface with TLS support
67 --replace_result $MASTER_ADMINPORT MASTER_ADMINPORT
68 --let $restart_parameters="restart: --admin-address=127.0.0.1 --admin-port=$MASTER_ADMINPORT --admin-ssl-ca=$MYSQL_TEST_DIR/std_data/ca-cert-verify.pem --admin-ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert-verify-pass.pem --admin-ssl-key=$MYSQL_TEST_DIR/std_data/server-key-verify-pass.pem"
69
70 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
71
72 --echo # Check if ssl is still turned on after reload
73 SELECT LENGTH(VARIABLE_VALUE) > 0 FROM performance_schema.session_status
74 WHERE VARIABLE_NAME='Ssl_cipher';
75
76 --echo # check if old sessions continue
77 --connect(admin_conn1, 127.0.0.1, root,,,$MASTER_ADMINPORT,,SSL)
78
79 SET @must_be_present= 'present';
80
81 --connection default
82
83 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
84
85 --connection admin_conn1
86
87 --echo # Success criteria: value must be present
88 SELECT @must_be_present;
89
90 --connection default
91 --disconnect admin_conn1
92
93 # Wait until all sessions are disconnected
94 --source include/wait_until_count_sessions.inc
95
96 --connect(admin_conn1, 127.0.0.1, root,,,$MASTER_ADMINPORT,,SSL)
97
98 let $orig_cipher= query_get_value(SHOW STATUS LIKE 'Ssl_cipher', Value, 1);
99 SET @orig_admin_ssl_cipher = @@global.admin_ssl_cipher;
100
101 --echo # check if the session has the original values
102 --replace_result $orig_cipher orig_cipher
103 SHOW STATUS LIKE 'Ssl_cipher';
104
105 --echo # in default connection
106 --connection default
107
108 --echo # setting new values for ssl_cipher
109 SET GLOBAL admin_ssl_cipher = "ECDHE-RSA-AES256-GCM-SHA384";
110 SET GLOBAL admin_tls_version = "TLSv1.2";
111 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
112
113 --echo # in admin_conn2
114 --connect(admin_conn2, 127.0.0.1, root,,,$MASTER_ADMINPORT,,SSL)
115 --echo # Save the new defaults
116 let $new_cipher= query_get_value(SHOW STATUS LIKE 'Ssl_cipher', Value, 1);
117
118 --echo # Check if the old and the new not afters differ
119 let $the_same=`SELECT "$new_cipher" = "$orig_cipher"`;
120 if ($the_same == 1)
121 {
122 die the not-after values must be different;
123 }
124
125 --echo # in admin_conn1
126 --connection admin_conn1
127
128 --echo # the con session must have the original values
129 --replace_result $orig_cipher orig_cipher;
130 SHOW STATUS LIKE 'Ssl_cipher';
131
132 # cleanup
133 --echo # in default connection
134 --connection default
135 --disconnect admin_conn1
136 --disconnect admin_conn2
137
138 SET GLOBAL admin_ssl_cipher = @orig_ssl_cipher;
139 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
140
141 --echo # new values effective only after RELOAD TLS
142 --echo # Save the defaults
143 --connect(admin_conn1, 127.0.0.1, root,,,$MASTER_ADMINPORT,,SSL)
144 let $orig_cipher= query_get_value(SHOW STATUS LIKE 'Ssl_cipher', Value, 1);
145
146 --connection default
147 SET @orig_admin_ssl_cipher = @@global.admin_ssl_cipher;
148
149 --echo # setting new values for ssl_cipher
150 SET GLOBAL admin_ssl_cipher = "ECDHE-RSA-AES256-GCM-SHA384";
151
152 --echo # In admin_conn2
153 --connect(admin_conn2, 127.0.0.1, root,,,$MASTER_ADMINPORT,,SSL)
154 let $new_cipher= query_get_value(SHOW STATUS LIKE 'Ssl_cipher', Value, 1);
155
156 --echo # Check if the old and the new not afters differ
157 let $the_same=`SELECT "$new_cipher" = "$orig_cipher"`;
158 if ($the_same == 0)
159 {
160 die the old non-after must still be active;
161 }
162
163 --connection default
164 --disconnect admin_conn1
165 --disconnect admin_conn2
166
167 SET GLOBAL admin_ssl_cipher = @orig_ssl_cipher;
168
169 --echo # Disable TLS support on wrong values
170
171 --echo # save the original value
172 SET @orig_admin_ssl_ca = @@global.admin_ssl_ca;
173
174 SET GLOBAL admin_ssl_ca = 'gizmo';
175
176 --echo # Must fail and not change the SSL params
177 --error ER_DA_SSL_LIBRARY_ERROR
178 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
179
180 --echo # Must not show 'gizmo'
181 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
182
183 --echo # Must return gizmo
184 SELECT @@global.admin_ssl_ca;
185
186 --echo # Must connect successfully
187 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 --port=$MASTER_ADMINPORT -e "SELECT 1"
188
189 --echo # Must pass with a warning and disable TLS
190 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin NO ROLLBACK ON ERROR;
191
192 --echo # Must show 'gizmo'
193 SELECT VALUE FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = 'gizmo';
194
195 --echo # Must fail
196 --error 1
197 --exec $MYSQL --ssl-mode=REQUIRED --host=127.0.0.1 --port=$MASTER_ADMINPORT -e "SELECT 1"
198
199 --echo # Reset
200 SET GLOBAL admin_ssl_ca = @orig_admin_ssl_ca;
201 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
202
203 --echo # Must pass
204 SET GLOBAL admin_ssl_ca = 'gizmo';
205 SET GLOBAL admin_ssl_cert = 'gizmo';
206 SET GLOBAL admin_ssl_key = 'gizmo';
207 SET GLOBAL admin_ssl_capath = 'gizmo';
208 SET GLOBAL admin_ssl_crl = 'gizmo';
209 SET GLOBAL admin_ssl_crlpath = 'gizmo';
210 SET GLOBAL admin_ssl_cipher = 'gizmo';
211 SET GLOBAL admin_tls_ciphersuites = 'gizmo';
212 --error ER_WRONG_VALUE_FOR_VAR
213 SET GLOBAL admin_tls_version = 'gizmo';
214
215 --echo # Must fail
216 --error ER_GLOBAL_VARIABLE
217 SET SESSION admin_ssl_ca = 'gizmo';
218 --error ER_GLOBAL_VARIABLE
219 SET SESSION admin_ssl_cert = 'gizmo';
220 --error ER_GLOBAL_VARIABLE
221 SET SESSION admin_ssl_key = 'gizmo';
222 --error ER_GLOBAL_VARIABLE
223 SET SESSION admin_ssl_capath = 'gizmo';
224 --error ER_GLOBAL_VARIABLE
225 SET SESSION admin_ssl_crl = 'gizmo';
226 --error ER_GLOBAL_VARIABLE
227 SET SESSION admin_ssl_crlpath = 'gizmo';
228 --error ER_GLOBAL_VARIABLE
229 SET SESSION admin_ssl_cipher = 'gizmo';
230 --error ER_GLOBAL_VARIABLE
231 SET SESSION admin_tls_ciphersuites = 'gizmo';
232 --error ER_GLOBAL_VARIABLE
233 SET SESSION admin_tls_version = 'gizmo';
234
235 --echo # Must return more than 1
236 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin';
237
238 --echo # 4. Main channel and Admin channel can be independent of
239 --echo # each other wrt TLS context
240
241 --echo # Restarting server with admin interface with TLS support
242 --replace_result $MASTER_ADMINPORT MASTER_ADMINPORT
243 --let $restart_parameters="restart: --admin-address=127.0.0.1 --admin-port=$MASTER_ADMINPORT --admin-ssl-ca=$MYSQL_TEST_DIR/std_data/ca-cert-verify.pem --admin-ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert-verify-pass.pem --admin-ssl-key=$MYSQL_TEST_DIR/std_data/server-key-verify-pass.pem"
244 --source include/restart_mysqld_no_echo.inc
245
246 --echo # save the original value
247 SET @orig_admin_ssl_ca = @@global.admin_ssl_ca;
248 SET @orig_admin_ssl_cert = @@global.admin_ssl_cert;
249 SET @orig_admin_ssl_key = @@global.admin_ssl_key;
250
251 SET @orig_ssl_ca = @@global.ssl_ca;
252 SET @orig_ssl_cert = @@global.ssl_cert;
253 SET @orig_ssl_key = @@global.ssl_key;
254
255 --echo # Should be all 1
256 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
257 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_admin_ssl_cert;
258 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_admin_ssl_key;
259
260 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_ssl_ca;
261 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_ssl_cert;
262 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_ssl_key;
263
264 --echo # Setting admin certs to different value
265 --disable_query_log
266 --eval SET GLOBAL admin_ssl_ca = '$MYSQL_TEST_DIR/std_data/cacert.pem'
267 --eval SET GLOBAL admin_ssl_cert = '$MYSQL_TEST_DIR/std_data/server-cert.pem'
268 --eval SET GLOBAL admin_ssl_key = '$MYSQL_TEST_DIR/std_data/server-key.pem'
269 --enable_query_log
270 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
271
272 --echo # Admin certs won't match but regular certs will
273 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
274 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_cert' AND VALUE = @orig_admin_ssl_cert;
275 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_key' AND VALUE = @orig_admin_ssl_key;
276
277 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_ssl_ca;
278 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_ssl_cert;
279 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_ssl_key;
280
281 --connection default
282
283 SET GLOBAL admin_ssl_ca = @orig_admin_ssl_ca;
284 SET GLOBAL admin_ssl_cert = @orig_admin_ssl_cert;
285 SET GLOBAL admin_ssl_key = @orig_admin_ssl_key;
286 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
287
288 --echo # Syntax check
289
290 --error ER_SYNTAX_ERROR
291 ALTER INSTANCE RELOAD TLS FOR CHANNEL haha;
292
293 --error ER_SYNTAX_ERROR
294 ALTER INSTANCE RELOAD TLS FOR CHANNEL haha NO ROLLBACK ON ERROR;
295
296 ALTER INSTANCE RELOAD TLS FOR CHANNEL MySqL_AdMin;
297 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_MAIN;
298
299 ALTER INSTANCE RELOAD TLS FOR CHANNEL MySqL_AdMin NO ROLLBACK ON ERROR;
300 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_MAIN NO ROLLBACK ON ERROR;
301
302 --echo # Cleanup
303 DROP USER admin_user;
304 --source include/force_restart.inc
305 # Wait until all sessions are disconnected
306 --source include/wait_until_count_sessions.inc