Debian Codegraph @

mysql-test/suite/connection_control/t/connection_delay_valid_users.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 # Connection delay tests for valid user accounts
8
9 --echo
10 --echo # ----------------------------------------------------------------------
11 --echo
12
13 --echo # Setup
14 --echo # Install connection_control plugin
15 --source ../inc/install_connection_control_plugin.inc
16
17 --echo # Create user accounts for testing
18 CREATE USER u1 IDENTIFIED BY 'abcd';
19 CREATE USER u2 IDENTIFIED BY 'abcd';
20 CREATE USER u3 IDENTIFIED BY 'abcd';
21
22 --echo # Save original values of connection_control variables
23 SET @saved_connections_threshold = @@global.connection_control_failed_connections_threshold;
24 SET @saved_max_delay = @@global.connection_control_max_connection_delay;
25 SET @saved_min_delay= @@global.connection_control_min_connection_delay;
26
27 -- echo # Set small values for connection_control variables
28 SET @@global.connection_control_failed_connections_threshold = 3;
29 SET @@global.connection_control_max_connection_delay = 4000;
30 SET @@global.connection_control_min_connection_delay = 2000;
31
32 # We don't need to use client side authentication plugin for this test.
33 let $USE_AUTH_PLUGIN= 0;
34
35 --echo
36 --echo # ----------------------------------------------------------------------
37 --echo
38
39 --echo # Make enough failed attempts to trigger delays
40
41 disable_result_log;
42
43 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
44 --error ER_ACCESS_DENIED_ERROR
45 connect(fail_con_u1, localhost, u1,,,,,);
46 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
47 --error ER_ACCESS_DENIED_ERROR
48 connect(fail_con_u1, localhost, u1,haha,,,,);
49 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
50 --error ER_ACCESS_DENIED_ERROR
51 connect(fail_con_u2, localhost, u2,efgh,,,,);
52
53 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
54 --error ER_ACCESS_DENIED_ERROR
55 connect(fail_con_u3, localhost, u3,,,,,);
56 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
57 --error ER_ACCESS_DENIED_ERROR
58 connect(fail_con_u2, localhost, u2,haha,,,,);
59 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
60 --error ER_ACCESS_DENIED_ERROR
61 connect(fail_con_u3, localhost, u3,efgh,,,,);
62
63 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
64 --error ER_ACCESS_DENIED_ERROR
65 connect(fail_con_u2, localhost, u2,,,,,);
66 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
67 --error ER_ACCESS_DENIED_ERROR
68 connect(fail_con_u1, localhost, u1,haha,,,,);
69 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
70 --error ER_ACCESS_DENIED_ERROR
71 connect(fail_con_u3, localhost, u3,efgh,,,,);
72
73 enable_result_log;
74
75 --echo
76 --echo # Following attempts will experience delay in server respose
77
78 # Trying with invalid passwords
79
80 --source ../inc/set_before_marker.inc
81 let $USER=u1;
82 let $PASSWORD=hoho;
83 let $SUCCESS=0;
84 let $DELAY_STATS=1;
85 --source ../inc/check_connection_delay.inc
86
87 let $SERVER_RESPONSE_TIME= 2;
88 --source ../inc/set_after_marker.inc
89
90 --source ../inc/set_before_marker.inc
91 let $USER=u2;
92 let $PASSWORD=hoho;
93 let $SUCCESS=0;
94 let $DELAY_STATS=2;
95 --source ../inc/check_connection_delay.inc
96
97 let $SERVER_RESPONSE_TIME= 2;
98 --source ../inc/set_after_marker.inc
99
100 --source ../inc/set_before_marker.inc
101 let $USER=u3;
102 let $PASSWORD=hoho;
103 let $SUCCESS=0;
104 let $DELAY_STATS=3;
105 --source ../inc/check_connection_delay.inc
106
107 let $SERVER_RESPONSE_TIME= 2;
108 --source ../inc/set_after_marker.inc
109
110 # Trying with valid passwords
111
112 --source ../inc/set_before_marker.inc
113 let $USER=u3;
114 let $PASSWORD=abcd;
115 let $SUCCESS=1;
116 let $DELAY_STATS=4;
117 --source ../inc/check_connection_delay.inc
118
119 let $SERVER_RESPONSE_TIME= 2;
120 --source ../inc/set_after_marker.inc
121
122 --source ../inc/set_before_marker.inc
123 let $USER=u2;
124 let $PASSWORD=abcd;
125 let $SUCCESS=1;
126 let $DELAY_STATS=5;
127 --source ../inc/check_connection_delay.inc
128
129 let $SERVER_RESPONSE_TIME= 2;
130 --source ../inc/set_after_marker.inc
131
132 --source ../inc/set_before_marker.inc
133 let $USER=u1;
134 let $PASSWORD=abcd;
135 let $SUCCESS=1;
136 let $DELAY_STATS=6;
137 --source ../inc/check_connection_delay.inc
138
139 let $SERVER_RESPONSE_TIME= 2;
140 --source ../inc/set_after_marker.inc
141
142 --echo
143 --echo # Following attempts will not experience any delay in server respose
144
145 let $USER=u1;
146 let $PASSWORD=hoho;
147 let $SUCCESS=0;
148 let $DELAY_STATS=6;
149 --source ../inc/check_connection_delay.inc
150
151 let $USER=u2;
152 let $PASSWORD=hoho;
153 let $SUCCESS=0;
154 let $DELAY_STATS=6;
155 --source ../inc/check_connection_delay.inc
156
157 let $USER=u3;
158 let $PASSWORD=hoho;
159 let $SUCCESS=0;
160 let $DELAY_STATS=6;
161 --source ../inc/check_connection_delay.inc
162
163 let $USER=u1;
164 let $PASSWORD=abcd;
165 let $SUCCESS=1;
166 let $DELAY_STATS=6;
167 --source ../inc/check_connection_delay.inc
168
169 let $USER=u2;
170 let $PASSWORD=abcd;
171 let $SUCCESS=1;
172 let $DELAY_STATS=6;
173 --source ../inc/check_connection_delay.inc
174
175 let $USER=u3;
176 let $PASSWORD=abcd;
177 let $SUCCESS=1;
178 let $DELAY_STATS=6;
179 --source ../inc/check_connection_delay.inc
180
181 --echo
182 --echo # ----------------------------------------------------------------------
183 --echo
184
185 --echo # Cleanup
186
187 connection default;
188
189 --echo # Restore original values of conenction_control variables
190 SET @@global.connection_control_failed_connections_threshold = @saved_connections_threshold;
191 SET @@global.connection_control_max_connection_delay = @saved_max_delay;
192 SET @@global.connection_control_min_connection_delay = @saved_min_delay;
193
194 --echo # Remove user accounts created for the test
195 DROP USER u1;
196 DROP USER u2;
197 DROP USER u3;
198
199 --echo # Uninstall connection_control plugin
200 --source ../inc/uninstall_connection_control_plugin.inc
201
202 # Wait till all disconnects are completed.
203 --source include/wait_until_count_sessions.inc
204
205 --echo
206 --echo # ----------------------------------------------------------------------