2-Factor Auth Secure Login doesn't shows QR-code for some users

The problem is that plugin doesn't show initial QR-code or doesn't check if users install it in Google Authenticator or not. And if not, there is no way to view this QR-code again.

How can I reset the QR-code for the user?

Or is there some ways to show this code again if the user has never entered the 2-Factor Auth PIN?

 

Screen Shot 2016-05-11 at 17.18.01.jpg

 

 

1 answer

Hi Gregory,

currently we are implementing this and some other features for the next version which should be available in the second quarter of the year if everything goes well. Nethertheless the workaround to reset an user token in confluence is through the database. With the following SQL script you can check if the correct token will be deleted:

SELECT * FROM %TABLENAME% WHERE USER_IDENTIFIER = (SELECT USER_KEY FROM USER_MAPPING WHERE USERNAME LIKE '%USERNAME%');

And with the next script you can delete the token:

SELECT * FROM %TABLENAME% WHERE USER_IDENTIFIER = (SELECT USER_KEY FROM USER_MAPPING WHERE USERNAME LIKE '%USERNAME%');

To execute the scripts you will have to replace the string %USERNAME% with the confluence username of the user you want to delete the token.

Also you have to replace the string %TABLENAME% with the correct table. Therefore you have to identify the USER_CONFIG table in your database. This table is named AO_<hash>_USER_CONFIG while <hash> is a 6 digit hash value. (e.g. AO_1D83D9_USER_CONFIG)

I hope I could help you with this workaround.

Regards,
Matthias

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

1,020 views 23 13
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you