submitted 1 year ago by notdeadyet@lemmy.one to c/lemmy_support@lemmy.ml

6 comments fedilink hide all child comments

Hello,

I have tried to add 2FA to my admin account on my instance, and now I am locked out of my account because it keeps saying my token is wrong.

Is there a way for me to remove it somehow?

I have installed Lemmy through docker if that's any help.

top 5 comments

sorted by: hot top controversial new old

[-] nii236@lemmy.jtmn.dev 2 points 1 year ago

Are you skilled with SQL? Everything should be working off the DB state so you just need to sift through and edit your user record

[-] notdeadyet@lemmy.one 2 points 1 year ago

Unfortunately, I am not. But I'm a quick learner.

Do you have any idea where I can start looking for my user record in the postures database?

[-] notdeadyet@lemmy.notdead.net 1 points 1 year ago* (last edited 1 year ago)

I fixed it, added a comment with what worked. Thanks for pointing me in the right direction!

[-] notdeadyet@lemmy.notdead.net 1 points 1 year ago

Fixed this by setting totp_2fa_secret and totp_2fa_url to null in the postgres database for my local user!

[-] nii236@lemmy.jtmn.dev 1 points 1 year ago

Nice work! Yeah the database is king in these lands

this post was submitted on 24 Jun 2023

2 points (100.0% liked)

Lemmy Support

4661 readers

13 users here now

Support / questions about Lemmy.

founded 5 years ago

MODERATORS