Debian Codegraph @

mysql-test/suite/connection_control/t/system_variables.test

raw
1 # Make sure that connection_control plugin can be loaded
2 --source ../inc/have_connection_control_plugin.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 --echo #-----------------------------------------------------------------------
8 --echo # Setup
9 --echo # Install connection_control plugin
10 --source ../inc/install_connection_control_plugin.inc
11 CREATE USER no_privs@localhost IDENTIFIED BY 'abcd';
12 connect(conn_no_privs, localhost, no_privs, abcd,,,,);
13 connection default;
14 --echo #-----------------------------------------------------------------------
15
16 --echo # Case 1 : connection_control_failed_connections_threshold
17 SHOW GRANTS;
18 SET @saved_value = @@global.connection_control_failed_connections_threshold;
19 SELECT @saved_value;
20 SET @@global.connection_control_failed_connections_threshold = @saved_value;
21
22 --echo # 1.1 : Setting connection_control_failed_connections_threshold to valid
23 --echo # value
24
25 SET @@global.connection_control_failed_connections_threshold = 20;
26 SELECT @@global.connection_control_failed_connections_threshold;
27
28 SET @@global.connection_control_failed_connections_threshold = 2000;
29 SELECT @@global.connection_control_failed_connections_threshold;
30
31 SET @@global.connection_control_failed_connections_threshold = 2147483647;
32 SELECT @@global.connection_control_failed_connections_threshold;
33
34 SET @@global.connection_control_failed_connections_threshold = DEFAULT;
35 SELECT @@global.connection_control_failed_connections_threshold;
36
37 --echo # 1.2 : Setting connection_control_failed_connections_threshold to
38 --echo # invalid value
39
40 --error ER_WRONG_TYPE_FOR_VAR
41 SET @@global.connection_control_failed_connections_threshold = NULL;
42 SELECT @@global.connection_control_failed_connections_threshold;
43
44 --error ER_WRONG_TYPE_FOR_VAR
45 SET @@global.connection_control_failed_connections_threshold = `SELECT * FROM mysql.user`;
46 SELECT @@global.connection_control_failed_connections_threshold;
47
48 --error ER_WRONG_VALUE_FOR_VAR
49 SET @@global.connection_control_failed_connections_threshold = -20;
50 SELECT @@global.connection_control_failed_connections_threshold;
51
52 --error ER_WRONG_VALUE_FOR_VAR
53 SET @@global.connection_control_failed_connections_threshold = 9223372036854775808;
54 SELECT @@global.connection_control_failed_connections_threshold;
55
56 --error ER_WRONG_VALUE_FOR_VAR
57 SET @@global.connection_control_failed_connections_threshold = -9223372036854775808;
58 SELECT @@global.connection_control_failed_connections_threshold;
59
60 --echo # Switch to conn_no_privs
61 connection conn_no_privs;
62 --echo # 1.3 : Use no_privs@localhost to set
63 --echo # connection_control_failed_connections_threshold to valid value
64
65 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
66 SET @@global.connection_control_failed_connections_threshold = 2147483647;
67 SELECT @@global.connection_control_failed_connections_threshold;
68
69 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
70 SET @@global.connection_control_failed_connections_threshold = DEFAULT;
71 SELECT @@global.connection_control_failed_connections_threshold;
72
73 --echo # 1.4 : Use no_privs@localhost to set
74 --echo # connection_control_failed_connections_threshold to invalid value
75
76 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
77 SET @@global.connection_control_failed_connections_threshold = NULL;
78 SELECT @@global.connection_control_failed_connections_threshold;
79
80 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
81 SET @@global.connection_control_failed_connections_threshold = 9223372036854775808;
82 SELECT @@global.connection_control_failed_connections_threshold;
83
84 connection default;
85
86 SET @@global.connection_control_failed_connections_threshold = @saved_value;
87 SELECT @@global.connection_control_failed_connections_threshold;
88
89 --echo #-----------------------------------------------------------------------
90
91 --echo # Case 2 : connection_control_min_connection_delay
92
93 SET @saved_value= @@global.connection_control_min_connection_delay;
94 SELECT @saved_value;
95
96 --echo # 2.1 : Setting connection_control_min_connection_delay to valid
97 --echo # value
98
99 SET @@global.connection_control_min_connection_delay = 20000;
100 SELECT @@global.connection_control_min_connection_delay;
101
102 SET @@global.connection_control_min_connection_delay = 2000;
103 SELECT @@global.connection_control_min_connection_delay;
104
105 SET @@global.connection_control_min_connection_delay = 2147483647;
106 SELECT @@global.connection_control_min_connection_delay;
107
108 SET @@global.connection_control_min_connection_delay = DEFAULT;
109 SELECT @@global.connection_control_min_connection_delay;
110
111 --echo # 2.2 : Setting connection_control_min_connection_delay to
112 --echo # invalid value
113
114 --error ER_WRONG_TYPE_FOR_VAR
115 SET @@global.connection_control_min_connection_delay = NULL;
116 SELECT @@global.connection_control_min_connection_delay;
117
118 --error ER_WRONG_TYPE_FOR_VAR
119 SET @@global.connection_control_min_connection_delay = `SELECT * FROM mysql.user`;
120 SELECT @@global.connection_control_min_connection_delay;
121
122 --error ER_WRONG_VALUE_FOR_VAR
123 SET @@global.connection_control_min_connection_delay = -20;
124 SELECT @@global.connection_control_min_connection_delay;
125
126 --error ER_WRONG_VALUE_FOR_VAR
127 SET @@global.connection_control_min_connection_delay = 9223372036854775808;
128 SELECT @@global.connection_control_min_connection_delay;
129
130 --error ER_WRONG_VALUE_FOR_VAR
131 SET @@global.connection_control_min_connection_delay = -9223372036854775808;
132 SELECT @@global.connection_control_min_connection_delay;
133
134 --error ER_WRONG_VALUE_FOR_VAR
135 SET@@global.connection_control_min_connection_delay = 20;
136 SELECT @@global.connection_control_min_connection_delay;
137
138 --echo # Switch to conn_no_privs
139 connection conn_no_privs;
140 --echo # 2.3 : Use no_privs@localhost to set
141 --echo # connection_control_min_connection_delay to valid value
142
143 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
144 SET @@global.connection_control_min_connection_delay = 2147483647;
145 SELECT @@global.connection_control_min_connection_delay;
146
147 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
148 SET @@global.connection_control_min_connection_delay = DEFAULT;
149 SELECT @@global.connection_control_min_connection_delay;
150
151 --echo # 2.4 : Use no_privs@localhost to set
152 --echo # connection_control_min_connection_delay to invalid value
153
154 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
155 SET @@global.connection_control_min_connection_delay = NULL;
156 SELECT @@global.connection_control_min_connection_delay;
157
158 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
159 SET @@global.connection_control_min_connection_delay = 9223372036854775808;
160 SELECT @@global.connection_control_min_connection_delay;
161
162 --echo # Switch to default connection
163 connection default;
164 --echo # 2.5 : Setting connection_control_min_connection_delay to a value
165 --echo # greater than connection_control_max_connection_delay
166
167 SET @saved_max_delay= @@global.connection_control_max_connection_delay;
168 SET @@global.connection_control_max_connection_delay= 10000;
169
170 --error ER_WRONG_VALUE_FOR_VAR
171 SET @@global.connection_control_min_connection_delay= 11000;
172 SELECT @@global.connection_control_min_connection_delay;
173
174 SET @@global.connection_control_max_connection_delay= @saved_max_delay;
175
176 SET @@global.connection_control_min_connection_delay = @saved_value;
177 SELECT @@global.connection_control_min_connection_delay;
178
179 --echo #-----------------------------------------------------------------------
180
181 --echo # Case 3 : connection_control_max_connection_delay
182
183 SET @saved_value= @@global.connection_control_max_connection_delay;
184 SELECT @saved_value;
185
186 --echo # 3.1 : Setting connection_control_max_connection_delay to valid
187 --echo # value
188
189 SET @@global.connection_control_max_connection_delay = 20000;
190 SELECT @@global.connection_control_max_connection_delay;
191
192 SET @@global.connection_control_max_connection_delay = 2000;
193 SELECT @@global.connection_control_max_connection_delay;
194
195 SET @@global.connection_control_max_connection_delay = 2147483647;
196 SELECT @@global.connection_control_max_connection_delay;
197
198 SET @@global.connection_control_max_connection_delay = DEFAULT;
199 SELECT @@global.connection_control_max_connection_delay;
200
201 --echo # 3.2 : Setting connection_control_max_connection_delay to
202 --echo # invalid value
203
204 --error ER_WRONG_TYPE_FOR_VAR
205 SET @@global.connection_control_max_connection_delay = NULL;
206 SELECT @@global.connection_control_max_connection_delay;
207
208 --error ER_WRONG_TYPE_FOR_VAR
209 SET @@global.connection_control_max_connection_delay = `SELECT * FROM mysql.user`;
210 SELECT @@global.connection_control_max_connection_delay;
211
212 --error ER_WRONG_VALUE_FOR_VAR
213 SET @@global.connection_control_max_connection_delay = -20;
214 SELECT @@global.connection_control_max_connection_delay;
215
216 --error ER_WRONG_VALUE_FOR_VAR
217 SET @@global.connection_control_max_connection_delay = 9223372036854775808;
218 SELECT @@global.connection_control_max_connection_delay;
219
220 --error ER_WRONG_VALUE_FOR_VAR
221 SET @@global.connection_control_max_connection_delay = -9223372036854775808;
222 SELECT @@global.connection_control_max_connection_delay;
223
224 --error ER_WRONG_VALUE_FOR_VAR
225 SET @@global.connection_control_max_connection_delay = 20;
226 SELECT @@global.connection_control_max_connection_delay;
227
228 --echo # Switch to conn_no_privs
229 connection conn_no_privs;
230 --echo # 3.3 : Use no_privs@localhost to set
231 --echo # connection_control_max_connection_delay to valid value
232
233 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
234 SET @@global.connection_control_max_connection_delay = 2147483647;
235 SELECT @@global.connection_control_max_connection_delay;
236
237 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
238 SET @@global.connection_control_max_connection_delay = DEFAULT;
239 SELECT @@global.connection_control_max_connection_delay;
240
241 --echo # 3.4 : Use no_privs@localhost to set
242 --echo # connection_control_max_connection_delay to invalid value
243
244 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
245 SET @@global.connection_control_max_connection_delay = NULL;
246 SELECT @@global.connection_control_max_connection_delay;
247
248 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
249 SET @@global.connection_control_max_connection_delay = 9223372036854775808;
250 SELECT @@global.connection_control_max_connection_delay;
251
252 --echo # Switch to default connection
253 connection default;
254 --echo # 3.5 : Setting connection_control_min_connection_delay to a value
255 --echo # greater than connection_control_max_connection_delay
256
257 SET @saved_min_delay= @@global.connection_control_min_connection_delay;
258 SET @@global.connection_control_min_connection_delay= 11000;
259
260 --error ER_WRONG_VALUE_FOR_VAR
261 SET @@global.connection_control_max_connection_delay= 10000;
262 SELECT @@global.connection_control_max_connection_delay;
263
264 SET @@global.connection_control_min_connection_delay= @saved_min_delay;
265
266 SET @@global.connection_control_max_connection_delay = @saved_value;
267 SELECT @@global.connection_control_max_connection_delay;
268
269 --echo # Test setting connection_control_exempt_unknown_users to invalid values
270 SET @saved_exempt= @@global.connection_control_exempt_unknown_users;
271 SELECT @@global.connection_control_exempt_unknown_users;
272 --error ER_WRONG_VALUE_FOR_VAR
273 SET @@global.connection_control_exempt_unknown_users= -1;
274 SELECT @@global.connection_control_exempt_unknown_users;
275 --error ER_WRONG_VALUE_FOR_VAR
276 SET @@global.connection_control_exempt_unknown_users= 7;
277 SELECT @@global.connection_control_exempt_unknown_users;
278 --error ER_WRONG_VALUE_FOR_VAR
279 SET @@global.connection_control_exempt_unknown_users= "YESS";
280 SELECT @@global.connection_control_exempt_unknown_users;
281 --error ER_WRONG_VALUE_FOR_VAR
282 SET @@global.connection_control_exempt_unknown_users= "ye";
283 SELECT @@global.connection_control_exempt_unknown_users;
284 --error ER_WRONG_VALUE_FOR_VAR
285 SET @@global.connection_control_exempt_unknown_users= "NOOOOO";
286 SELECT @@global.connection_control_exempt_unknown_users;
287 --error ER_WRONG_VALUE_FOR_VAR
288 SET @@global.connection_control_exempt_unknown_users= "n";
289 SELECT @@global.connection_control_exempt_unknown_users;
290 --error ER_WRONG_VALUE_FOR_VAR
291 SET @@global.connection_control_exempt_unknown_users= "ONN";
292 SELECT @@global.connection_control_exempt_unknown_users;
293 --error ER_WRONG_VALUE_FOR_VAR
294 SET @@global.connection_control_exempt_unknown_users= "offf";
295 SELECT @@global.connection_control_exempt_unknown_users;
296 --error ER_WRONG_VALUE_FOR_VAR
297 SET @@global.connection_control_exempt_unknown_users= "NO";
298 SELECT @@global.connection_control_exempt_unknown_users;
299 --error ER_WRONG_VALUE_FOR_VAR
300 SET @@global.connection_control_exempt_unknown_users= NO;
301 SELECT @@global.connection_control_exempt_unknown_users;
302 --error ER_WRONG_VALUE_FOR_VAR
303 SET @@global.connection_control_exempt_unknown_users= "YES";
304 SELECT @@global.connection_control_exempt_unknown_users;
305 --error ER_WRONG_VALUE_FOR_VAR
306 SET @@global.connection_control_exempt_unknown_users= YES;
307 SELECT @@global.connection_control_exempt_unknown_users;
308 --error ER_WRONG_VALUE_FOR_VAR
309 SET @@global.connection_control_exempt_unknown_users= "no";
310 SELECT @@global.connection_control_exempt_unknown_users;
311 --error ER_WRONG_VALUE_FOR_VAR
312 SET @@global.connection_control_exempt_unknown_users= "yes";
313 SELECT @@global.connection_control_exempt_unknown_users;
314 --error ER_WRONG_VALUE_FOR_VAR
315 SET @@global.connection_control_exempt_unknown_users= "FALSE";
316 SELECT @@global.connection_control_exempt_unknown_users;
317 --error ER_WRONG_VALUE_FOR_VAR
318 SET @@global.connection_control_exempt_unknown_users= "TRUE";
319 SELECT @@global.connection_control_exempt_unknown_users;
320 --error ER_WRONG_VALUE_FOR_VAR
321 SET @@global.connection_control_exempt_unknown_users= "false";
322 SELECT @@global.connection_control_exempt_unknown_users;
323 --error ER_WRONG_VALUE_FOR_VAR
324 SET @@global.connection_control_exempt_unknown_users= "true";
325 SELECT @@global.connection_control_exempt_unknown_users;
326 --echo # Test setting connection_control_exempt_unknown_users to valid values
327 SET @@global.connection_control_exempt_unknown_users= 0;
328 SELECT @@global.connection_control_exempt_unknown_users;
329 SET @@global.connection_control_exempt_unknown_users= 1;
330 SELECT @@global.connection_control_exempt_unknown_users;
331 SET @@global.connection_control_exempt_unknown_users= "OFF";
332 SELECT @@global.connection_control_exempt_unknown_users;
333 SET @@global.connection_control_exempt_unknown_users= "ON";
334 SELECT @@global.connection_control_exempt_unknown_users;
335 SET @@global.connection_control_exempt_unknown_users= FALSE;
336 SELECT @@global.connection_control_exempt_unknown_users;
337 SET @@global.connection_control_exempt_unknown_users= TRUE;
338 SELECT @@global.connection_control_exempt_unknown_users;
339 SET @@global.connection_control_exempt_unknown_users= "off";
340 SELECT @@global.connection_control_exempt_unknown_users;
341 SET @@global.connection_control_exempt_unknown_users= "on";
342 SELECT @@global.connection_control_exempt_unknown_users;
343 SET @@global.connection_control_exempt_unknown_users= false;
344 SELECT @@global.connection_control_exempt_unknown_users;
345 SET @@global.connection_control_exempt_unknown_users= true;
346 SELECT @@global.connection_control_exempt_unknown_users;
347 SET @@global.connection_control_exempt_unknown_users= @saved_exempt;
348
349 --echo #-----------------------------------------------------------------------
350 --echo # Cleanup
351 disconnect conn_no_privs;
352 DROP USER no_privs@localhost;
353 --echo # Uninstall connection_control plugin
354 --source ../inc/uninstall_connection_control_plugin.inc
355
356 # Wait till all disconnects are completed.
357 --source include/wait_until_count_sessions.inc
358 --echo #-----------------------------------------------------------------------