Displaying 1 result from an estimated 1 matches for "hosting_db".
2009 May 17
2
Problem with domain part in user_query in dovecot 1.1.14
...ocal/etc/dovecot-sql.conf
userdb:
driver: sql
args: /usr/local/etc/dovecot-sql.conf
socket:
type: listen
client:
path: /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...