Reset a user's login count from the database in Jira server

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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 performing any modification to the database. If possible, try your modifications on a test server.

Option 1:

Run this SQL query and see the login attempt count for USERNAME:

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':

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';
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';

(info) This syntax was only tested on PostgreSQL


Option 2:

Last modified on Feb 22, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.