| 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; |