alexandregz / twofactor_gauthenticator

This RoundCube plugin adds the 2-step verification(OTP) to the login proccess
MIT License
214 stars 74 forks source link

Need to clear 2FA for user #145

Closed johan-NL closed 3 years ago

johan-NL commented 3 years ago

Hi, I've just installed and activated the plugin, went to Settings-Two-factor authentication and clicked Enable. The QR code and secret both didn't appear so I assumed I had to click Save. Then I got logged out and 2FA was on but naturally I couldn't login anymore. I am now trying to reset it using:

To only one user: restore the user prefs from DB to null (rouncubeDB.users.preferences) -the user plugin options stored there. Screenshot 2021-04-30 112036

I can get to the preferences table (using Webmin) but then I see what you see in the screenshot. No idea what to change there to disable 2FA for myself.

Thanks,

Johan

johan-NL commented 3 years ago

Anyone?

johan-NL commented 3 years ago

Help??

WanWizard commented 3 years ago

Look in the database, lookup the user, and check the preferences field. It will contain

"activate";b:1

somewhere in the contents. Change the 1 to a 0, save it, and you can login with username and password again.

johan-NL commented 3 years ago

Thanks, that worked!