Displaying 1 result from an estimated 1 matches for "mail_base".
2009 May 17
2
Problem with domain part in user_query in dovecot 1.1.14
...ath: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: postfix
dovecot-sql.conf:
driver = pgsql
connect = host=localhost dbname=hosting_db user=hosting_db password=adsfweae
password_query = SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM
main.mail_base WHERE userid = '%n' AND password = '%w' and domain='%d'
#password_query = SELECT password, userid AS user FROM main.mail_base WHERE user
id = '%n' and domain='%d'
#user_query = SELECT '/var/mail/vhosts/' || domain || '/' || userid as mail, ...