Remove all MFA settings for locally hosted Zitadel
Hello, through some bad luck my phone was recently fatally damaged and with it poof gone is my TOTP app and thus all my access to my self-hosted zitadel instance. Is there any way to remove the 2fa settings for each individual user on my local installation? I suppose they are somewhere in the postgres database but where would I find and change these?
2 Replies
Hi @nortsable I'm investigating this topic and will share once I have more details. Thanks!
thank you very much! My initial thought was to peek at the postgres database but it seems empty?
root@zitadel:~# psql -U root zitadel
psql (15.13 (Debian 15.13-0+deb12u1))
Type "help" for help.
zitadel=# \dt
Did not find any relations.
My bad, \dt *.* does the trick but I have not yet found anything where I could change the mfa settings
Just for reference: I saw no way to somehow fix this using the database. As I had not created and enable an API user beforehand and no means to do so anymore there seemed to be no solution but completely setup a new zitadel instance from scratch and reconfigure every single app that used zitadel as oidc provider