Debian Codegraph @

mysql-test/suite/plugins/t/two_password_validations.test

raw
1 --source include/not_embedded.inc
2
3 if (!$CRACKLIB_PASSWORD_CHECK_SO) {
4 skip No CRACKLIB_PASSWORD_CHECK plugin;
5 }
6
7 if (!$SIMPLE_PASSWORD_CHECK_SO) {
8 skip No SIMPLE_PASSWORD_CHECK plugin;
9 }
10
11 let $only_simple=grant select on *.* to Fff_fff1 identified by '1fff_ffF';
12 let $only_crack=grant select on *.* to foobar identified by 'q-%^&*rty';
13
14 install soname "simple_password_check";
15
16 eval $only_simple;
17 drop user Fff_fff1;
18
19 install soname "cracklib_password_check";
20
21 grant select on *.* to foobar identified by 'q$%^&*R1234ty';
22 drop user foobar;
23
24 --error ER_NOT_VALID_PASSWORD
25 eval $only_simple;
26 show warnings;
27
28 --error ER_NOT_VALID_PASSWORD
29 eval $only_crack;
30 show warnings;
31
32 uninstall plugin simple_password_check;
33
34 eval $only_crack;
35 drop user foobar;
36
37 uninstall plugin cracklib_password_check;
38