Displaying 1 result from an estimated 1 matches for "vmailpassword".
2007 Mar 02
1
auth problem with secure authentication (cram-md5)
...hanisms = LOGIN CRAM-MD5 DIGEST-MD5 PLAIN APOP
passdb sql {
args=/etc/dovecot-crammd5.conf
}
passdb sql {
args=/etc/dovecot-sql.conf
}
userdb sql {
args=/etc/dovecot-sql.conf
}
}
in dovecot-sql.conf:
driver = mysql
connect = host=/var/run/mysql/mysql.sock port= dbname=mail
user=vmailuser password=vmailpassword
password_query = SELECT clear AS password , user FROM mailbox WHERE user
= '%n' AND IF('%d'='',clear = '%w',domain = '%d') AND status ='1' LIMIT 1
user_query = SELECT CONCAT(home,'/',maildir) AS home, '1001' AS uid,
'1001' AS...