| 1 |
CREATE USER xuser_ssl@localhost |
| 2 |
IDENTIFIED WITH 'mysql_native_password' BY 'pass' |
| 3 |
REQUIRE SSL; |
| 4 |
|
| 5 |
####################################################################### |
| 6 |
## 1. Memory authentication fails on non SSL connection when account |
| 7 |
## is marked that it required SSL |
| 8 |
## |
| 9 |
## when: |
| 10 |
## * Fill the cache with the account |
| 11 |
## * Use memory auth on SSL connection, expect success |
| 12 |
## * Use memory auth on non SSL connection, expect failure |
| 13 |
## |
| 14 |
## Requirements: F6 |
| 15 |
# |
| 16 |
-- Expecting success with parameters: REQUIRED plain xuser_ssl pass |
| 17 |
-- |
| 18 |
connecting... |
| 19 |
active session is now 'sess0' |
| 20 |
closing session sess0 |
| 21 |
Mysqlx.Ok { |
| 22 |
msg: "bye!" |
| 23 |
} |
| 24 |
switched to session default |
| 25 |
-- Expecting success with parameters: REQUIRED memory xuser_ssl pass |
| 26 |
-- |
| 27 |
connecting... |
| 28 |
active session is now 'sess0' |
| 29 |
closing session sess0 |
| 30 |
Mysqlx.Ok { |
| 31 |
msg: "bye!" |
| 32 |
} |
| 33 |
switched to session default |
| 34 |
-- Expecting failure with parameters: DISABLED memory xuser_ssl pass |
| 35 |
-- |
| 36 |
connecting... |
| 37 |
Got expected error (one of: 1045 2510 ) |
| 38 |
Mysqlx.Ok { |
| 39 |
msg: "bye!" |
| 40 |
} |
| 41 |
ok |
| 42 |
DROP USER xuser_ssl@localhost; |