Debian Codegraph @

mysql-test/suite/connection_control/t/status_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 # 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@localhost IDENTIFIED BY 'abcd';
19 CREATE USER u2@localhost IDENTIFIED BY 'abcd';
20 CREATE USER u3@localhost 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
26 -- echo # Set small threshold
27 SET @@global.connection_control_failed_connections_threshold = 1;
28 -- echo # Set small max delay
29 SET @@global.connection_control_max_connection_delay = 1000;
30
31 # We don't need to use client side authentication plugin for this test.
32 let $USE_AUTH_PLUGIN= 0;
33
34 --echo
35 --echo # ----------------------------------------------------------------------
36 --echo
37
38 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
39 --error ER_ACCESS_DENIED_ERROR
40 connect(fail_con_u1, localhost, u1,,,,,);
41 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
42 --error ER_ACCESS_DENIED_ERROR
43 connect(fail_con_u3, localhost, u3,haha,,,,);
44 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
45 --error ER_ACCESS_DENIED_ERROR
46 connect(fail_con_u2, localhost, u2,efgh,,,,);
47
48 --echo # Check Connection_control_delay_generated - Should be 0
49 SHOW STATUS LIKE 'Connection_control_delay_generated';
50
51 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
52 --error ER_ACCESS_DENIED_ERROR
53 connect(fail_con_u1, localhost, u1,,,,,);
54 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
55 --error ER_ACCESS_DENIED_ERROR
56 connect(fail_con_u2, localhost, u2,haha,,,,);
57 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
58 --error ER_ACCESS_DENIED_ERROR
59 connect(fail_con_u3, localhost, u3,efgh,,,,);
60
61 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
62 --error ER_ACCESS_DENIED_ERROR
63 connect(fail_con_u2, localhost, u2,,,,,);
64 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
65 --error ER_ACCESS_DENIED_ERROR
66 connect(fail_con_u1, localhost, u1,haha,,,,);
67 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
68 --error ER_ACCESS_DENIED_ERROR
69 connect(fail_con_u3, localhost, u3,efgh,,,,);
70
71 --echo # Check Connection_control_delay_generated - Should be 6
72 SHOW STATUS LIKE 'Connection_control_delay_generated';
73
74 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
75 --error ER_ACCESS_DENIED_ERROR
76 connect(fail_con_u2, localhost, u2,,,,,);
77 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
78 --error ER_ACCESS_DENIED_ERROR
79 connect(fail_con_u1, localhost, u1,haha,,,,);
80 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
81 --error ER_ACCESS_DENIED_ERROR
82 connect(fail_con_u3, localhost, u3,efgh,,,,);
83
84 --echo # Check Connection_control_delay_generated - Should be 9
85 SHOW STATUS LIKE 'Connection_control_delay_generated';
86
87 connect(con_u1, localhost, u1,abcd,,,,);
88 connect(con_u2, localhost, u2,abcd,,,,);
89 connect(con_u3, localhost, u3,abcd,,,,);
90 connection default;
91 --disconnect con_u1
92 --disconnect con_u2
93 --disconnect con_u3
94
95 --echo # Successful connection but delays would still be generated
96 --echo # Should be 12
97 SHOW STATUS LIKE 'Connection_control_delay_generated';
98
99 --echo # Setting failed connection threshold should reset delay statistics
100 SET @@global.connection_control_failed_connections_threshold = 1;
101
102 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
103 --error ER_ACCESS_DENIED_ERROR
104 connect(fail_con_u1, localhost, u1,,,,,);
105 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
106 --error ER_ACCESS_DENIED_ERROR
107 connect(fail_con_u3, localhost, u3,haha,,,,);
108 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
109 --error ER_ACCESS_DENIED_ERROR
110 connect(fail_con_u2, localhost, u2,efgh,,,,);
111
112 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
113 --error ER_ACCESS_DENIED_ERROR
114 connect(fail_con_u1, localhost, u1,,,,,);
115 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
116 --error ER_ACCESS_DENIED_ERROR
117 connect(fail_con_u3, localhost, u3,haha,,,,);
118 --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
119 --error ER_ACCESS_DENIED_ERROR
120 connect(fail_con_u2, localhost, u2,efgh,,,,);
121
122 --echo # Check Connection_control_delay_generated - Should be 3
123 SHOW STATUS LIKE 'Connection_control_delay_generated';
124
125 --echo
126 --echo # ----------------------------------------------------------------------
127 --echo
128
129 --echo # Cleanup
130
131 connection default;
132
133 --echo # Restore original values of conenction_control variables
134 SET @@global.connection_control_max_connection_delay= @saved_max_delay;
135 SET @@global.connection_control_failed_connections_threshold = @saved_connections_threshold;
136
137 --echo # Remove user accounts created for the test
138 DROP USER u1@localhost;
139 DROP USER u2@localhost;
140 DROP USER u3@localhost;
141
142 --echo # Uninstall connection_control plugin
143 --source ../inc/uninstall_connection_control_plugin.inc
144
145 # Wait till all disconnects are completed.
146 --source include/wait_until_count_sessions.inc
147
148 --echo
149 --echo # ----------------------------------------------------------------------