Debian Codegraph @

mysql-test/suite/auth_sec/t/wl15751_validate_password_changed_characters.test

raw
1 --source include/have_validate_password_component.inc
2
3 --enable_connect_log
4 --connection default
5
6 # Warning is generated when default file (NULL) is used
7 CALL mtr.add_suppression("Dictionary file not specified");
8
9 # Warning is generated when dictionary file is not provided with
10 # PASSWORD_POLICY_STRONG
11 CALL mtr.add_suppression("Since the validate_password_policy is mentioned ");
12
13 # Warning is generated when validate_password.length is chaged
14 # as a result of changing value of system variables listed below:
15 # VALIDATE_PASSWORD.NUMBER_COUNT
16 # VALIDATE_PASSWORD.MIXED_CASE_COUNT
17 # VALIDATE_PASSWORD.SPECIAL_CHAR_COUNT
18 CALL mtr.add_suppression("Effective value of validate_password.length is changed.");
19
20 --echo # Setup
21 CREATE USER wl15751_user_c PASSWORD REQUIRE CURRENT;
22 CREATE USER wl15751_user_o PASSWORD REQUIRE CURRENT OPTIONAL;
23 CREATE USER wl15751_user_d;
24 CREATE USER wl15751_user_p PASSWORD REQUIRE CURRENT;
25 GRANT CREATE USER ON *.* TO wl15751_user_p;
26
27 INSTALL COMPONENT 'file://component_validate_password';
28
29 SET GLOBAL validate_password.changed_characters_percentage = 50;
30 SET GLOBAL password_require_current = ON;
31
32
33 --echo # ----------------------------------------------------------------------
34 --echo # 1. Empty current password
35
36 --echo # Must pass
37 --connect(conn_wl15751_user_c, localhost, wl15751_user_c,,,,,)
38 SET PASSWORD = 'Abcd1234@' REPLACE '';
39
40 --echo # Must pass
41 --connect(conn_wl15751_user_o, localhost, wl15751_user_o,,,,,)
42 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234@';
43
44 --echo # Must pass
45 --connect(conn_wl15751_user_d, localhost, wl15751_user_d,,,,,)
46 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234@' REPLACE '';
47
48 --echo # Must pass
49 --connect(conn_wl15751_user_p, localhost, wl15751_user_p,,,,,)
50 SET PASSWORD = 'Abcd1234@';
51
52 --echo # ----------------------------------------------------------------------
53 --echo # 2. New password same as current password
54
55 --echo # Must fail
56 --connection conn_wl15751_user_c
57 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
58 SET PASSWORD = 'Abcd1234@' REPLACE 'Abcd1234@';
59
60 --echo # Must fail
61 --connection conn_wl15751_user_o
62 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
63 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234@' REPLACE 'Abcd1234@';
64
65 --echo # Must pass: PASSWORD REQUIRE CURRENT OPTIONAL
66 --connection conn_wl15751_user_o
67 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234@';
68
69 --echo # Must fail
70 --connection conn_wl15751_user_d
71 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
72 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234@' REPLACE 'Abcd1234@';
73
74 --echo # Must fail
75 --connection conn_wl15751_user_p
76 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
77 SET PASSWORD = 'Abcd1234@' REPLACE 'Abcd1234@';
78
79 --echo # Must pass: privileged user
80 --connection conn_wl15751_user_p
81 SET PASSWORD = 'Abcd1234@';
82
83 --echo # ----------------------------------------------------------------------
84 --echo # 3. New password has less than required number of changed characters
85 --echo # Change count must be 1. Rationale:
86 --echo # - One new digit is added
87 --echo # - Changing letter case is not counted as a change
88 --echo # - Repeating same character is not counted as a change even
89 --echo # if the character is not present in existing password
90
91 --echo # Must fail
92 --connection conn_wl15751_user_c
93 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
94 SET PASSWORD = 'AbcD01234@@' REPLACE 'Abcd1234@';
95 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
96 SET PASSWORD = 'AbccD01234@@' REPLACE 'Abcd1234@';
97 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
98 SET PASSWORD = 'AbccDD001234@@' REPLACE 'Abcd1234@';
99
100 --echo # Must fail
101 --connection conn_wl15751_user_o
102 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
103 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbcD01234@@' REPLACE 'Abcd1234@';
104 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
105 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbccD01234@@' REPLACE 'Abcd1234@';
106 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
107 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbccDD001234@@' REPLACE 'Abcd1234@';
108
109 --echo # Must fail
110 --connection conn_wl15751_user_d
111 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
112 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbcD01234@@' REPLACE 'Abcd1234@';
113 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
114 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbccD01234@@' REPLACE 'Abcd1234@';
115 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
116 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbccDD001234@@' REPLACE 'Abcd1234@';
117
118 --echo # Must fail
119 --connection conn_wl15751_user_p
120 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
121 SET PASSWORD = 'AbcD01234@@' REPLACE 'Abcd1234@';
122 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
123 SET PASSWORD = 'AbccD01234@@' REPLACE 'Abcd1234@';
124 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
125 SET PASSWORD = 'AbccDD001234@@' REPLACE 'Abcd1234@';
126
127 --echo # ----------------------------------------------------------------------
128 --echo # 4. New password has required number of changed characters
129
130 --echo # Must pass
131 --connection conn_wl15751_user_c
132 SET PASSWORD = 'AbPq01234@%' REPLACE 'Abcd1234@';
133
134 --echo # Must pass
135 --connection conn_wl15751_user_o
136 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbPq01234@%' REPLACE 'Abcd1234@';
137
138 --echo # Must pass
139 --connection conn_wl15751_user_d
140 ALTER USER CURRENT_USER() IDENTIFIED BY 'AbPq01234@%' REPLACE 'Abcd1234@';
141
142 --echo # Must pass
143 --connection conn_wl15751_user_p
144 SET PASSWORD = 'AbPq01234@%' REPLACE 'Abcd1234@';
145
146 --echo # ----------------------------------------------------------------------
147 --echo # 4. New password has more than required number of changed characters
148
149 --echo # Must pass
150 --connection conn_wl15751_user_c
151 SET PASSWORD = 'FghIj56789#?' REPLACE 'AbPq01234@%';
152
153 --echo # Must pass
154 --connection conn_wl15751_user_o
155 ALTER USER CURRENT_USER() IDENTIFIED BY 'FghIj56789#?' REPLACE 'AbPq01234@%';
156
157 --echo # Must pass
158 --connection conn_wl15751_user_d
159 ALTER USER CURRENT_USER() IDENTIFIED BY 'FghIj56789#?' REPLACE 'AbPq01234@%';
160
161 --echo # Must pass
162 --connection conn_wl15751_user_p
163 SET PASSWORD = 'FghIj56789#?' REPLACE 'AbPq01234@%';
164
165 --echo # ----------------------------------------------------------------------
166 --echo # 5. Number of characters to be changed depend on password length
167
168 --connection conn_wl15751_user_c
169 --echo # Must pass: Minimum 6 characters must be different
170 SET PASSWORD = 'Abcd123!' REPLACE 'FghIj56789#?';
171
172 --echo # Must pass: Minimum 4 characters must be different
173 SET PASSWORD = 'Efgh123!' REPLACE 'Abcd123!';
174 SET PASSWORD = 'Klmnopq01234!@$%' REPLACE 'Efgh123!';
175
176 --echo # Must fail: Minimum of 8 characters must be different
177 --error ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS
178 SET PASSWORD = 'Abcd1234!@' REPLACE 'Klmnopq01234!@$%';
179
180 --echo Must pass: Minimum of 8 characters must be different
181 SET PASSWORD = 'FghIj56789#?' REPLACE 'Klmnopq01234!@$%';
182
183 --echo # ----------------------------------------------------------------------
184 --echo # 6. Other password policies must apply independent of
185 --echo # changed characters count
186
187 SHOW VARIABLES LIKE '%validate_password%';
188
189 --echo # Must fail
190 --connection conn_wl15751_user_c
191 --error ER_NOT_VALID_PASSWORD
192 SET PASSWORD = 'Ab12*&' REPLACE 'FghIj56789#?';
193 --error ER_NOT_VALID_PASSWORD
194 SET PASSWORD = 'abcd12*&' REPLACE 'FghIj56789#?';
195 --error ER_NOT_VALID_PASSWORD
196 SET PASSWORD = 'Abcdef*&' REPLACE 'FghIj56789#?';
197 --error ER_NOT_VALID_PASSWORD
198 SET PASSWORD = 'Abcd1234' REPLACE 'FghIj56789#?';
199
200 --echo # Must fail
201 --connection conn_wl15751_user_o
202 --error ER_NOT_VALID_PASSWORD
203 ALTER USER CURRENT_USER() IDENTIFIED BY 'Ab12*&' REPLACE 'FghIj56789#?';
204 --error ER_NOT_VALID_PASSWORD
205 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcdef*&' REPLACE 'FghIj56789#?';
206 --error ER_NOT_VALID_PASSWORD
207 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234' REPLACE 'FghIj56789#?';
208
209 --echo # Must fail
210 --connection conn_wl15751_user_d
211 --error ER_NOT_VALID_PASSWORD
212 ALTER USER CURRENT_USER() IDENTIFIED BY 'Ab12*&' REPLACE 'FghIj56789#?';
213 --error ER_NOT_VALID_PASSWORD
214 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcdef*&' REPLACE 'FghIj56789#?';
215 --error ER_NOT_VALID_PASSWORD
216 ALTER USER CURRENT_USER() IDENTIFIED BY 'Abcd1234' REPLACE 'FghIj56789#?';
217
218 --echo # Must fail
219 --connection conn_wl15751_user_p
220 --error ER_NOT_VALID_PASSWORD
221 SET PASSWORD = 'Ab12*&' REPLACE 'FghIj56789#?';
222 --error ER_NOT_VALID_PASSWORD
223 SET PASSWORD = 'Abcdef*&' REPLACE 'FghIj56789#?';
224 --error ER_NOT_VALID_PASSWORD
225 SET PASSWORD = 'Abcd1234' REPLACE 'FghIj56789#?';
226
227 --echo # ----------------------------------------------------------------------
228 --echo # 7. Setting global policy to off would allow users with
229 --echo # default setting to change password without supplying
230 --echo # the current one - effectively skipping the changed
231 --echo # character count check
232
233 --connection default
234 SET GLOBAL password_require_current=OFF;
235
236 --connection conn_wl15751_user_d
237 SET PASSWORD = 'FghIj56789#?';
238 ALTER USER CURRENT_USER() IDENTIFIED BY 'FghIj56789#?';
239
240 --echo # ----------------------------------------------------------------------
241 --echo # Teardown
242 --connection default
243 UNINSTALL COMPONENT 'file://component_validate_password';
244
245 DROP USER wl15751_user_c, wl15751_user_o, wl15751_user_d, wl15751_user_p;
246
247 --disable_connect_log