Debian Codegraph @

mysql-test/suite/x/r/connection_auth_sequence_timeout.result

raw
1 # restart
2 call mtr.add_suppression("Maximum number of authentication attempts reached");
3 CREATE USER xuser_native@'localhost'
4 IDENTIFIED WITH 'mysql_native_password' BY 'native';
5 CREATE USER xuser_sha256@'localhost'
6 IDENTIFIED WITH 'sha256_password' BY 'sha256';
7 CREATE USER xuser_cache2@'localhost'
8 IDENTIFIED WITH 'caching_sha2_password' BY 'cache2';
9 SET GLOBAL mysqlx_connect_timeout = 15;
10
11 #######################################################################
12 ## 3. Authentication fails, and client is idle
13 ##
14 ## * Establish a connection, try to login with invalid data, do nothing
15 ## (waiting for disconnection)
16 ## * Establish a connection, enable ssl, try to login with invalid data,
17 ## do nothing (waiting for disconnection)
18 ##
19 #
20
21 #######################################################################
22 ## New connection & SSL, user is waiting for disconnection after the auth
23 ## failure
24 connecting...
25 active session is now 'seq'
26 send Mysqlx.Connection.CapabilitiesSet {
27 capabilities {
28 capabilities {
29 name: "tls"
30 value {
31 type: SCALAR
32 scalar {
33 type: V_BOOL
34 v_bool: true
35 }
36 }
37 }
38 }
39 }
40
41 Mysqlx.Ok {
42 }
43
44 Got expected error: Access denied for user 'xuser_native'@'localhost' (using password: YES) (code 1045)
45 closing session seq
46 switched to session default
47
48 #######################################################################
49 ## New connection, user is waiting for disconnection after the auth
50 ## failure
51 connecting...
52 active session is now 'seq'
53 Got expected error: Access denied for user 'xuser_native'@'localhost' (using password: YES) (code 1045)
54 closing session seq
55 switched to session default
56 Mysqlx.Ok {
57 msg: "bye!"
58 }
59 ok
60 DROP USER xuser_native@'localhost';
61 DROP USER xuser_sha256@'localhost';
62 DROP USER xuser_cache2@'localhost';
63 SET GLOBAL mysqlx_connect_timeout = DEFAULT;