Disable user CAPTCHAs from the JIRA database

Still need help?

The Atlassian Community is here for you.

Ask the community

Steps

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

  1. Shutdown your JIRA application.
  2. Execute the following SQL to identify the record to update:

    SELECT s.* 
    FROM   propertyentry e 
           JOIN propertystring s 
             ON e.id = s.id 
    WHERE  property_key = 'jira.maximum.authentication.attempts.allowed'; 
  3. And run the following SQL to set that record to an empty string, which is the equivalent of unlimited authentication attempts, bypassing CAPTCHA validation:

    UPDATE propertystring 
    SET    propertyvalue = '' 
    WHERE  id = <id from step 2>;
  4. Start JIRA application.

(info) Additionally our How to reset failed login count from a JIRA application database KB may be of assistance.

(warning) Currently, CAPTCHA can not be disabled on Oracle databases. There is an open JAC ticket that can be voted on and watched for more information:

JRA-41240 - Getting issue details... STATUS

 

Last modified on Sep 25, 2019

Was this helpful?

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