Hi,all
i have resolved this problem, when i am modify password_query parameter.
password_query = SELECT username AS user,password FROM (select username,password,disableimap as imap ,disablepop3 as pop3,disablesmtp as smtp,disablesieve as sieve FROM mailbox WHERE username = '%u' AND active='1') as tb1 where %s='0'
thanks.
Deng
On Tue, 22 Feb 2011 11:22:07 +0800, 邓卫华 wrote:
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
modify password_query.
i had writed :" select user,password from user where username='%u' and contact('disable',%s)='0' " in
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
can password_query, 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 use Dovecot's SASL¹ for
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] [1] for further details. Regards, Pascal -- 1 = http://wiki.dovecot.org/Sasl [2] [2]
-- Best Cheer (XiaMen) Stone Works CO.,LTP. Phone: 0592-7221600
Links:
[1] http://wiki.dovecot.org/Variables [2] http://wiki.dovecot.org/Sasl