Reset failed login count from Confluence database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
You're seeing CAPTCHA on every Confluence login attempt (due to the number of failed login attempts) and do not have access to the admin UI to reset the failed login attempts.
Solution
We strongly recommend you back up your database before you begin.
Shut down Confluence.
Clear all cookies from your browser and close all browsers.
Run the following query to see the current number of failed login attempts for the user name you need to reset (in this example the username is
admin):1 2 3 4 5 6 7SELECT TOTALFAILED, CURFAILED FROM LOGININFO WHERE username IN ( SELECT user_key FROM user_mapping WHERE lower_username = 'admin' );Once you've confirmed that the user name has failed login attempts, run the following update:
1 2 3 4 5 6 7UPDATE LOGININFO SET CURFAILED = 0 WHERE username IN ( SELECT user_key FROM user_mapping WHERE lower_username = 'admin' );If you have multiple users to update, you can use the following query by adding each user to it:
1 2 3 4 5 6UPDATE LOGININFO SET CURFAILED = 0 WHERE username IN ( SELECT user_key FROM user_mapping WHERE lower_username IN ('username1', 'username2'));
Start Confluence and attempt to log in again.
Was this helpful?