Debian Codegraph @

mysql-test/suite/plugins/t/cracklib_password_check.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 install soname "cracklib_password_check";
8
9 --vertical_results
10 --replace_result .dll .so
11 select * from information_schema.plugins where plugin_name='cracklib_password_check';
12 --horizontal_results
13
14 --error ER_NOT_VALID_PASSWORD
15 grant select on *.* to foocar identified by 'foocar';
16 show warnings;
17
18 --error ER_NOT_VALID_PASSWORD
19 grant select on *.* to foocar identified by 'racoof';
20 show warnings;
21
22 --error ER_NOT_VALID_PASSWORD
23 grant select on *.* to foo@barbar identified by 'barbar';
24 show warnings;
25
26 --error ER_NOT_VALID_PASSWORD
27 grant select on *.* to foobar identified by 'qwerty';
28 show warnings;
29
30 --error ER_NOT_VALID_PASSWORD
31 grant select on *.* to foocar@localhost identified by 'localhost';
32 show warnings;
33
34 --error ER_NOT_VALID_PASSWORD
35 grant select on *.* to foocar@localhost identified by 'foocar@localhost';
36 show warnings;
37
38 grant select on *.* to foobar identified by 'q$%^&*rty';
39 drop user foobar;
40
41 --echo #
42 --echo # MDEV-9851: CREATE USER w/o IDENTIFIED BY clause causes crash
43 --echo # when using cracklib plugin
44 --echo #
45
46 --error ER_NOT_VALID_PASSWORD
47 create user 'newuser'@'localhost';
48
49 uninstall plugin cracklib_password_check;
50
51 create user foo1 identified by 'pwd';
52 drop user foo1;
53