HowTo: Reset failed login count from Confluence database

お困りですか?

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

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

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.

*Fisheye および Crucible は除く

要約

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. 

環境

Confluence Server および Data Center

ソリューション

We strongly recommend you back up your database before you begin.

  1. Confluence をシャットダウンします。
  2. Clear all cookies from your browser and close all browsers.
  3. 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):

    SELECT TOTALFAILED, CURFAILED
    FROM LOGININFO
    WHERE username IN (
      SELECT user_key
      FROM user_mapping
      WHERE lower_username = 'admin'
    );
  4. Once you've confirmed that the user name has failed login attempts, run the following update:

    UPDATE LOGININFO
    SET CURFAILED = 0
    WHERE username IN (
      SELECT user_key
      FROM user_mapping
      WHERE lower_username = 'admin'
    );
    1. If you have multiple users to update, you can use the following query by adding each user to it:

      UPDATE LOGININFO
      SET CURFAILED = 0
      WHERE username IN (
        SELECT user_key
        FROM user_mapping
        WHERE lower_username IN ('username1', 'username2'));
  5. Start Confluence and attempt to log in again.
      

Last modified on Mar 9, 2021

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.