-
Notifications
You must be signed in to change notification settings - Fork 285
-
Notifications
You must be signed in to change notification settings - Fork 285
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
App Passwords not working with example query #802
Comments
Just to acknowledge you - yes, you're correct. The current query in the Dovecot docs doesn't work. I've not had time to investigate it or figure out what the query should be .... |
This is the best I've come up with so far (without IP exceptions). I wonder if it possible for say webmail apps to use the 2FA and other apps require an. app password? Maybe when the 2FA is created it's possible to store the source app? I wounder if it's possible to be consistent with
|
To follow |
I have been looking at this Postfix-DOvecot-Postgresql-Example
Specifically the last sql query for supporting app password.
It won't work but I'm not sure of the solution (cut/pasted below)
I see a number of issues
mailbox_app_password
the password field is calledpassword_hash
mailbox
andmailbox_app_password
is a hash how can this workpassword=%w
because according to dovecot docs%w
is the PLAIN TEXT password.WHERE usenamer="%u"
should beusername="%u"
The best I have come up with so far (which ignores
totp_exception_addresses
) it also assumes that MySQL know about the encryption type - so it can't handle BLF-CRYPTThe text was updated successfully, but these errors were encountered: