Hi, Pascal
thanks, that's great. it's work in our test environment. but i have a problem in mail server.
i have a user manage program of mail server, runing on mysql. it had a disableIMAP disablePOP3, disablesmtp column in user table.
that's easy if i can modify password_query.
i had writed :" select user,password from user where username='%u' and contact('disable',%s)='0' " in password_query, but it is not work and i got
"Password query failed: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077" in maillog file.
so ,how to modify password_query to get work?
Thanks.
Deng
On Sat, 19 Feb 2011 23:23:19 +0100, Pascal Volk wrote:
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 [1] for further details. Regards, Pascal -- 1 = http://wiki.dovecot.org/Sasl [2]
-- Best Cheer (XiaMen) Stone Works CO.,LTP. Phone: 0592-7221600
Links:
[1] http://wiki.dovecot.org/Variables [2] http://wiki.dovecot.org/Sasl