Debian Codegraph @

mysql-test/suite/connection_control/r/connection_exempt_proxy_users.result

raw
1 #-----------------------------------------------------------------------
2 # Setup
3 # Install connection_control plugin
4 INSTALL PLUGIN connection_control SONAME 'CONNECTION_CONTROL_LIB';
5 INSTALL PLUGIN connection_control_failed_login_attempts SONAME 'CONNECTION_CONTROL_LIB';
6 # Do proxy setup
7 CALL mtr.add_suppression("Plugin test_plugin_server reported: 'Wrong password supplied for proxied'");
8 SET @saved_connections_threshold = @@global.connection_control_failed_connections_threshold;
9 SET @saved_max_delay = @@global.connection_control_max_connection_delay;
10 SET @saved_min_delay= @@global.connection_control_min_connection_delay;
11 SET @saved_exempt= @@global.connection_control_exempt_unknown_users;
12 SET @@global.connection_control_failed_connections_threshold = 3;
13 SET @@global.connection_control_max_connection_delay = 4000;
14 SET @@global.connection_control_min_connection_delay = 2000;
15 SET @@global.connection_control_exempt_unknown_users= 1;
16 #-----------------------------------------------------------------------
17 # Case 1 : Tests for valid user accounts
18 # Make enough failed attempts to trigger delays
19 connect(localhost,u1,,test,SOURCE_PORT,SOURCE_SOCKET);
20 connect(localhost,u1,haha,test,SOURCE_PORT,SOURCE_SOCKET);
21 connect(localhost,u2,efgh,test,SOURCE_PORT,SOURCE_SOCKET);
22 connect(localhost,u3,,test,SOURCE_PORT,SOURCE_SOCKET);
23 connect(localhost,u2,haha,test,SOURCE_PORT,SOURCE_SOCKET);
24 connect(localhost,u3,efgh,test,SOURCE_PORT,SOURCE_SOCKET);
25 connect(localhost,u2,,test,SOURCE_PORT,SOURCE_SOCKET);
26 connect(localhost,u1,haha,test,SOURCE_PORT,SOURCE_SOCKET);
27 connect(localhost,u3,efgh,test,SOURCE_PORT,SOURCE_SOCKET);
28 # Following attempts will experience delay in server respose
29 # Connection attempt should fail.
30 Connection_control_delay_generated should be 1
31 Variable_name Value
32 Connection_control_delay_generated 1
33 @server_response_time >= 2
34 1
35 # Connection attempt should fail.
36 Connection_control_delay_generated should be 2
37 Variable_name Value
38 Connection_control_delay_generated 2
39 @server_response_time >= 2
40 1
41 # Connection attempt should fail.
42 Connection_control_delay_generated should be 3
43 Variable_name Value
44 Connection_control_delay_generated 3
45 @server_response_time >= 2
46 1
47 # Connection attempt should succeed.
48 Connection_control_delay_generated should be 4
49 Variable_name Value
50 Connection_control_delay_generated 4
51 @server_response_time >= 2
52 1
53 # Connection attempt should succeed.
54 Connection_control_delay_generated should be 5
55 Variable_name Value
56 Connection_control_delay_generated 5
57 @server_response_time >= 2
58 1
59 # Connection attempt should succeed.
60 Connection_control_delay_generated should be 6
61 Variable_name Value
62 Connection_control_delay_generated 6
63 @server_response_time >= 2
64 1
65 # Following attempts will not experience any delay in server respose
66 # Connection attempt should fail.
67 Connection_control_delay_generated should be 6
68 Variable_name Value
69 Connection_control_delay_generated 6
70 # Connection attempt should fail.
71 Connection_control_delay_generated should be 6
72 Variable_name Value
73 Connection_control_delay_generated 6
74 # Connection attempt should fail.
75 Connection_control_delay_generated should be 6
76 Variable_name Value
77 Connection_control_delay_generated 6
78 # Connection attempt should succeed.
79 Connection_control_delay_generated should be 6
80 Variable_name Value
81 Connection_control_delay_generated 6
82 # Connection attempt should succeed.
83 Connection_control_delay_generated should be 6
84 Variable_name Value
85 Connection_control_delay_generated 6
86 # Connection attempt should succeed.
87 Connection_control_delay_generated should be 6
88 Variable_name Value
89 Connection_control_delay_generated 6
90 #-----------------------------------------------------------------------
91 # Cleanup
92 SET @@global.connection_control_failed_connections_threshold = @saved_connections_threshold;
93 SET @@global.connection_control_max_connection_delay = @saved_max_delay;
94 SET @@global.connection_control_min_connection_delay = @saved_min_delay;
95 SET @@global.connection_control_exempt_unknown_users= @saved_exempt;
96 # Remove user accounts
97 # Uninstall connection_control plugin
98 UNINSTALL PLUGIN connection_control;
99 UNINSTALL PLUGIN connection_control_failed_login_attempts;
100 #-----------------------------------------------------------------------