How to identify and reset all users blocked by CAPTCHA.

お困りですか?

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

コミュニティに質問

The content on this page relates to platforms which are supported, however are out of scope of our Atlassian Support Offerings. Consequently, Atlassian cannot guarantee support. Please be aware that this material is provided for your information only and you may use it at your own risk.

目的

If you are troubleshooting problems with CAPTCHA in Bitbucket you may want to find all users who are being blocked and reset them.

ソリューション

To Identify the users who are blocked by the CAPTCHA requirement you can run a query like the following: 

SELECT us.user_name
FROM cwd_user_attribute as atr
JOIN cwd_user as us ON atr.user_id=us.id
WHERE atr.attribute_name = "failedAuthenticationAttemptCount" AND atr.attribute_value >= 5 ; 

 

If it's only a few users you can reset the CAPTCHA individually or script something with the list of users you got from the database query. Here's an example curl request to reset a user's CAPTCHA.

curl --user <user_name>:<password> -X DELETE http://baseurl:7990/rest/api/1.0/admin/users/captcha?name=<user_name>


Please note that you'll have to replace the authenticating username and password as well as the base URL and the target user who's CAPTCHA needs to be cleared.

 

To reset CAPTCHA for all users you would have to make manual modifications to the database: 

  • Backup Bitbucket
  • Stop Bitbucket
  • Run an UPDATE like the following:
UPDATE cwd_user_attribute
SET attribute_value = 0, attribute_lower_value = 0
WHERE attribute_name = 'failedAuthenticationAttemptCount';
  • Restart Bitbucket

 

Please make sure you backup Bitbucket before you make any modifications to the database.

 

   

 

 

最終更新日: 2017 年 9 月 23 日

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

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