Debian Codegraph @

mysql-test/suite/x/t/caching_sha2_password_digest_rounds.test

raw
1 ##
2 ## WL#14281 had introduced configurable digest rounds.
3 ##
4 ## This test covers the behavior introduced by WL#14281
5 ## on X plugin authentication.
6 ##
7
8
9 ## Please note that variable 'caching_sha2_password_digest_rounds'
10 ## should be "set" to change the default behavior for stmt like:
11 ##
12 ## * SET PASSWORD="XYZ"
13 ## * ALTER USER USER() IDENTIFIED BY 'XYZ';
14 #
15
16 ## Preamble
17 --source include/xplugin_preamble.inc
18 --source include/xplugin_create_user.inc
19
20 ## Test case description:
21
22 # note: 'password handling':
23 #
24 # * create account with password
25 # * change account password
26
27 --echo
28 --echo
29 --echo ## I. Verify that password hashes created with default digest-rounds
30 --echo ## can be used with X Plugin & X Client
31 --echo #
32 --echo # 1. Show that accounts original credentials are working,
33 --echo # change accounts credentials using (set password, alter user).
34 --echo # 2. Show that old credentials doesn't work.
35 --echo # 3. Show that new credentials are working.
36 --echo #
37 --echo ## II. Verify that password hashes created with default digest-rounds
38 --echo ## and changed with new digest-rounds can be used with X Plugin & X Client
39 --echo # 1. Change servers digest-rounds
40 --echo # 2. Show that accounts original credentials are working,
41 --echo # change accounts credentials to generate a password-hash using new
42 --echo # digest-rounds (set password, alter user).
43 --echo # 3. Show that old credentials doesn't work.
44 --echo # 4. Show that new credentials are working.
45 --echo #
46 --echo #
47
48 --let $test_group=I
49 --source ../include/test_caching_sha2_password_digest_rounds.inc
50
51 --let $test_group=II
52 --let $test_restart_with_different_digest=1
53 --source ../include/test_caching_sha2_password_digest_rounds.inc
54
55
56 ## Cleanup
57
58 --source ../include/xplugin_cleanup.inc