For the archive: This MySQL configuration seems to work well.

user_query = \ 
   SELECT \
        email AS user, \
        '/var/lib/vmail/%d/%n' AS home, \
        'maildir:/var/lib/vmail/%d/%n/Maildir' AS mail, \
        5000 AS uid, \
        5000 AS gid \
    FROM \
        view_users \
    WHERE \
        email='%u' \
    AND \
        enable = '1' 

password_query = \ 
    SELECT \
        email AS user, \
        NULL AS password, \
        'Y' as nopassword \
    FROM \
        view_users \
    WHERE \
        email='%u' \
    AND \
        password=IF (crypt & 1, SHA2('%w',512), password) \
    AND \
        enable = '1'
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org

Reply via email to