Disable user CAPTCHAs from the JIRA database


アトラシアン コミュニティをご利用ください。



データベースの変更を行う場合は 必ず事前にバックアップを取得してください。可能な場合はテスト サーバーで変更を試すことをおすすめします。

  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.

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

This approach will disable CAPTCHA for all Jira users. To disable CAPTCHA for specific users, we have raised the following feature request ticket: JRASERVER-40362 - Getting issue details... STATUS

(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 - 課題詳細を取得中... ステータス

最終更新日 2022 年 9 月 29 日


Powered by Confluence and Scroll Viewport.