Hello, I use dovecot + postfix with postfix sasl authentication by dovecot auth service. I have one question. Is it possible to have separate password_query only for auth service. I have two fields in database, one permits login to imap pop, second I want to use to permit login to smtp. Please explain how to set this (if it is possible) or give me some direction and sorry my English. -- View this message in context: http://dovecot.2317879.n4.nabble.com/more-than-one-password-query-tp39282.html Sent from the Dovecot mailing list archive at Nabble.com.
I found solution with one password_query password_query = SELECT password FROM mail_users WHERE email = '%u' AND (('%Ls' = 'smtp' AND postfix = 'Y') OR ('%Ls' = 'pop3' AND access = 'Y') OR ('%Ls' = 'imap' AND access = 'Y')) Others interesting dovecot variables: http://wiki2.dovecot.org/Variables -- View this message in context: http://dovecot.2317879.n4.nabble.com/more-than-one-password-query-tp39282p39286.html Sent from the Dovecot mailing list archive at Nabble.com.
Maybe Matching Threads
- help with AES_DECRYPT and password lookup - mysql password_query
- Authenticating Virtual Users without domain
- password_query, user_query and unrelated userid and emails
- Dovecot Migration: Retrieving/Logging POP/IMAP Passwords in Plaintext
- Plugins/Mailcrypt: mail_crypt_private_password not assigned by password_query