Reset a user's login count from the database in Jira server
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
Symptoms
When trying to gain access to a system, it is possible that you are getting hit with a CAPTCHA, but do not have access to the admin UI to reset this.
Resolution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Option 1:
Run this SQL query and see the login attempt count for USERNAME:
1
select * from cwd_user_attributes where user_id = (select id from cwd_user where user_name = 'USERNAME');And Run the following UPDATE queries to effectively alter the count to '0':
1
update cwd_user_attributes set attribute_value = '0' where user_id = (select id from cwd_user where user_name = 'USERNAME') and attribute_name = 'login.totalFailedCount';
1
update cwd_user_attributes set attribute_value = '0' where user_id = (select id from cwd_user where user_name = 'USERNAME') and attribute_name = 'login.currentFailedCount';ℹ️ This syntax was only tested on PostgreSQL
Option 2:
Was this helpful?