Debian Codegraph @

mysql-test/suite/auth_sec/r/admin_channel_tls.result

raw
1 # Setup
2 # Create test user
3 CREATE USER admin_user IDENTIFIED BY 'abcd';
4 # Grant required privilege so that test user
5 # can connect to server using admin interface
6 GRANT SERVICE_CONNECTION_ADMIN ON *.* TO admin_user;
7 # Restarting server with admin interface
8 # 1. Admin channel should reuse main channel's TLS
9 # Verify that TLS is not configured for admin channel
10 SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled';
11 CHANNEL mysql_admin
12 PROPERTY Enabled
13 VALUE No
14 # Try to connect using TLS
15 1
16 1
17 # 2. If any of the parameter for admin channel is configured,
18 # server channel's TLS context should not be used. Even if
19 # configuration for admin channel is not correct and TLS
20 # is not enabled for admin channel
21 # Restarting server with admin interface without TLS support
22 # Verify that TLS is not configured for admin channel
23 SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled';
24 CHANNEL mysql_admin
25 PROPERTY Enabled
26 VALUE No
27 # Try to connect using TLS
28 # Restarting server with admin interface with TLS support
29 # Verify that TLS is configured for admin channel
30 SELECT * FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Enabled';
31 CHANNEL mysql_admin
32 PROPERTY Enabled
33 VALUE Yes
34 # Try to connect using TLS
35 1
36 1
37 # 3. Admin channel TLS parameters can be changed at runtime check if
38 # new sessions get the new vals Save the defaults in admin_conn
39 # Restarting server with admin interface with TLS support
40 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
41 # Check if ssl is still turned on after reload
42 SELECT LENGTH(VARIABLE_VALUE) > 0 FROM performance_schema.session_status
43 WHERE VARIABLE_NAME='Ssl_cipher';
44 LENGTH(VARIABLE_VALUE) > 0
45 0
46 # check if old sessions continue
47 SET @must_be_present= 'present';
48 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
49 # Success criteria: value must be present
50 SELECT @must_be_present;
51 @must_be_present
52 present
53 SET @orig_admin_ssl_cipher = @@global.admin_ssl_cipher;
54 # check if the session has the original values
55 SHOW STATUS LIKE 'Ssl_cipher';
56 Variable_name Value
57 Ssl_cipher orig_cipher
58 # in default connection
59 # setting new values for ssl_cipher
60 SET GLOBAL admin_ssl_cipher = "ECDHE-RSA-AES256-GCM-SHA384";
61 SET GLOBAL admin_tls_version = "TLSv1.2";
62 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
63 # in admin_conn2
64 # Save the new defaults
65 # Check if the old and the new not afters differ
66 # in admin_conn1
67 # the con session must have the original values
68 SHOW STATUS LIKE 'Ssl_cipher';
69 Variable_name Value
70 Ssl_cipher orig_cipher;
71 # in default connection
72 SET GLOBAL admin_ssl_cipher = @orig_ssl_cipher;
73 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
74 # new values effective only after RELOAD TLS
75 # Save the defaults
76 SET @orig_admin_ssl_cipher = @@global.admin_ssl_cipher;
77 # setting new values for ssl_cipher
78 SET GLOBAL admin_ssl_cipher = "ECDHE-RSA-AES256-GCM-SHA384";
79 # In admin_conn2
80 # Check if the old and the new not afters differ
81 SET GLOBAL admin_ssl_cipher = @orig_ssl_cipher;
82 # Disable TLS support on wrong values
83 # save the original value
84 SET @orig_admin_ssl_ca = @@global.admin_ssl_ca;
85 SET GLOBAL admin_ssl_ca = 'gizmo';
86 # Must fail and not change the SSL params
87 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
88 ERROR HY000: Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed
89 # Must not show 'gizmo'
90 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
91 COUNT(*)
92 1
93 # Must return gizmo
94 SELECT @@global.admin_ssl_ca;
95 @@global.admin_ssl_ca
96 gizmo
97 # Must connect successfully
98 1
99 1
100 # Must pass with a warning and disable TLS
101 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin NO ROLLBACK ON ERROR;
102 Warnings:
103 Warning 3888 Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed
104 # Must show 'gizmo'
105 SELECT VALUE FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = 'gizmo';
106 VALUE
107 gizmo
108 # Must fail
109 # Reset
110 SET GLOBAL admin_ssl_ca = @orig_admin_ssl_ca;
111 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
112 # Must pass
113 SET GLOBAL admin_ssl_ca = 'gizmo';
114 SET GLOBAL admin_ssl_cert = 'gizmo';
115 SET GLOBAL admin_ssl_key = 'gizmo';
116 SET GLOBAL admin_ssl_capath = 'gizmo';
117 SET GLOBAL admin_ssl_crl = 'gizmo';
118 SET GLOBAL admin_ssl_crlpath = 'gizmo';
119 SET GLOBAL admin_ssl_cipher = 'gizmo';
120 SET GLOBAL admin_tls_ciphersuites = 'gizmo';
121 SET GLOBAL admin_tls_version = 'gizmo';
122 ERROR 42000: Variable 'admin_tls_version' can't be set to the value of 'gizmo'
123 # Must fail
124 SET SESSION admin_ssl_ca = 'gizmo';
125 ERROR HY000: Variable 'admin_ssl_ca' is a GLOBAL variable and should be set with SET GLOBAL
126 SET SESSION admin_ssl_cert = 'gizmo';
127 ERROR HY000: Variable 'admin_ssl_cert' is a GLOBAL variable and should be set with SET GLOBAL
128 SET SESSION admin_ssl_key = 'gizmo';
129 ERROR HY000: Variable 'admin_ssl_key' is a GLOBAL variable and should be set with SET GLOBAL
130 SET SESSION admin_ssl_capath = 'gizmo';
131 ERROR HY000: Variable 'admin_ssl_capath' is a GLOBAL variable and should be set with SET GLOBAL
132 SET SESSION admin_ssl_crl = 'gizmo';
133 ERROR HY000: Variable 'admin_ssl_crl' is a GLOBAL variable and should be set with SET GLOBAL
134 SET SESSION admin_ssl_crlpath = 'gizmo';
135 ERROR HY000: Variable 'admin_ssl_crlpath' is a GLOBAL variable and should be set with SET GLOBAL
136 SET SESSION admin_ssl_cipher = 'gizmo';
137 ERROR HY000: Variable 'admin_ssl_cipher' is a GLOBAL variable and should be set with SET GLOBAL
138 SET SESSION admin_tls_ciphersuites = 'gizmo';
139 ERROR HY000: Variable 'admin_tls_ciphersuites' is a GLOBAL variable and should be set with SET GLOBAL
140 SET SESSION admin_tls_version = 'gizmo';
141 ERROR HY000: Variable 'admin_tls_version' is a GLOBAL variable and should be set with SET GLOBAL
142 # Must return more than 1
143 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin';
144 COUNT(*)
145 29
146 # 4. Main channel and Admin channel can be independent of
147 # each other wrt TLS context
148 # Restarting server with admin interface with TLS support
149 # save the original value
150 SET @orig_admin_ssl_ca = @@global.admin_ssl_ca;
151 SET @orig_admin_ssl_cert = @@global.admin_ssl_cert;
152 SET @orig_admin_ssl_key = @@global.admin_ssl_key;
153 SET @orig_ssl_ca = @@global.ssl_ca;
154 SET @orig_ssl_cert = @@global.ssl_cert;
155 SET @orig_ssl_key = @@global.ssl_key;
156 # Should be all 1
157 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
158 COUNT(*)
159 1
160 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_admin_ssl_cert;
161 COUNT(*)
162 1
163 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_admin_ssl_key;
164 COUNT(*)
165 1
166 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_ssl_ca;
167 COUNT(*)
168 1
169 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_ssl_cert;
170 COUNT(*)
171 1
172 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_ssl_key;
173 COUNT(*)
174 1
175 # Setting admin certs to different value
176 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
177 # Admin certs won't match but regular certs will
178 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_ca' AND VALUE = @orig_admin_ssl_ca;
179 COUNT(*)
180 0
181 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_cert' AND VALUE = @orig_admin_ssl_cert;
182 COUNT(*)
183 0
184 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_admin' AND PROPERTY = 'current_tls_key' AND VALUE = @orig_admin_ssl_key;
185 COUNT(*)
186 0
187 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_ca' AND VALUE = @orig_ssl_ca;
188 COUNT(*)
189 1
190 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_cert' AND VALUE = @orig_ssl_cert;
191 COUNT(*)
192 1
193 SELECT COUNT(*) FROM performance_schema.tls_channel_status WHERE CHANNEL = 'mysql_main' AND PROPERTY = 'Current_tls_key' AND VALUE = @orig_ssl_key;
194 COUNT(*)
195 1
196 SET GLOBAL admin_ssl_ca = @orig_admin_ssl_ca;
197 SET GLOBAL admin_ssl_cert = @orig_admin_ssl_cert;
198 SET GLOBAL admin_ssl_key = @orig_admin_ssl_key;
199 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_admin;
200 # Syntax check
201 ALTER INSTANCE RELOAD TLS FOR CHANNEL haha;
202 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
203 ALTER INSTANCE RELOAD TLS FOR CHANNEL haha NO ROLLBACK ON ERROR;
204 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
205 ALTER INSTANCE RELOAD TLS FOR CHANNEL MySqL_AdMin;
206 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_MAIN;
207 ALTER INSTANCE RELOAD TLS FOR CHANNEL MySqL_AdMin NO ROLLBACK ON ERROR;
208 ALTER INSTANCE RELOAD TLS FOR CHANNEL mysql_MAIN NO ROLLBACK ON ERROR;
209 # Cleanup
210 DROP USER admin_user;