this post was submitted on 11 Jul 2023
10 points (100.0% liked)
Meta
3 readers
1 users here now
Discussion about the aussie.zone instance itself
founded 1 year ago
MODERATORS
Aww no gifs in jerboa
If you wanted to do it in one query I think you could do something like
UPDATE local_user AS u
SET u.totp_2fa_url = null,
u.totp_2fa_secret = null
FROM person AS p
WHERE p.id = u.person_id
AND p.local
AND p.name = 'guineapig';
I assume the p.local
is optional, too, because the id match against the local_user
table will presumably limit it to only local users. ๐คท
Thanks, good to know.
Thanks so much for this! It saved me, as I got locked out by accidentally disabling 2fa and then re-enabling it from account settings, which seemed to nuke the original settings.
Speaking of which, it no longer offers me a setup link as once before. So, I cannot set up 2fa again. Unless you might know a way? Thanks