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
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,203 views 4 6
Read article

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