How to reset twoFactor authentication ?

[RicardoHS]

Following the instructions on #2228 does not work anymore.

I have done:
Log into my docker that contains the database (postgres in my case)

$ docker exect -it <container_id> bash

Log into the postgres shell (the database and user names can be found in the docker-compose file)

$ psql <database_name> <user_name>

Exect this line to remove the twoFactor configuration

$ delete from preferences where name like 'twoFactorAuth%'

Log into the app container and run to clear the cache

$ php artisan cache:clear

But the app continue to request the two Factor

[JC5]

Indeed. Those instructions are out of date. I just realised that Firefly III itself also gives bad instructions.

Open table users and set mfa_secret to NULL for the user for who you want to disable 2FA.

[RicardoHS]

so just to clarify for others, in the psql shell just run

update users set mfa_secret = NULL;

[JC5]

That will reset it for everybody though. If you're a single user, no worries.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.