On 02/19/2011 02:20 PM 邓卫华 wrote:
Dear Pascal,
thanks for your reply ASAP. can i only add pop3 and imap column in the password table, and not to add sieve and smtp column? can password not verified if there have not existing smtp and sieve column?
You don't need to add the column sieve as long as do not provide MamageSieve. I don't know if you use Dovecot's SASL¹ for SMTP-Auth. If not. you did not need to add the smtp column. When you don't add the sieve column but provide ManageSieve, the login will always fail because an SQL error '… unknown column sieve …'
The first example query was wrong, sorry. The correct one would be: SELECT user, password FROM tbl WHERE user = '%u' AND %s
See also http://wiki.dovecot.org/Variables for further details.
Regards, Pascal
-- 1 = http://wiki.dovecot.org/Sasl
The trapper recommends today: face1e55.1105023@localdomain.org