2fa code issues

[privsec]

I now have multiple users experiencing an issue with their 2FA codes that was set up with SOGo.

How do I have them bypass/reset their accounts?

I just tried myself, and now my two (personal and business) account is not letting me sign in at sogo.domain.com, I can login in just fine st snappy.domain.com

[BrutalBirdie]

@privsec
In the Database it's:

To see your profile

SELECT *
FROM sogo_user_profile
WHERE c_uid = "your@email.com";

Disable 2FA:

UPDATE sogo_user_profile
SET c_defaults = REPLACE(
c_defaults,
"\\"SOGoTOTPEnabled\\": 1",
"\\"SOGoTOTPEnabled\\": 0")
WHERE c_uid = "your@email.com";

[girish]

@privsec usually 2fa errors come from time not being in sync. Can you check the server time?

[privsec]

@girish Sure, but weird thing is all my other 2fa for services work without a problem