Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.3, 3.4, 3.5
-
None
Description
A user will fail to login if the total number of failed login attempt is too large. Resetting the current failed login count in Confluence Admin >> Manage Users will not resolve the issue either. This affects all pre-4.0 Confluence versions.
Workaround
Reset the total failed login count by running this query in the database:
UPDATE os_propertyentry SET INT_VAL = 0 WHERE entity_key = 'user.login.total_number_failed_login_attempts' AND entity_name = 'CWD_<username>';
Replace <username> with the affected user's username.
Note that this is resolved in Confluence 4.0 and above, which uses the logininfo table, instead of os_propertyentry to record failed login attempts.