[Dovecot] 回复: Re: mysql auth failover failing

[fy]

it is so easy to use .
if you using dovecot2.0 ,in  /etc/dovecot/dovecot-sql.conf.ext  like this :
connect =host=localhost dbname=extmail user=root password=********
user_query=select concat('*:bytes=',trim(TRAILING 'S' FROM quota)) as quota_rule,concat('/home/data/domains/',maildir) as mail ,concat('/home/data/domains/',homedir) as home,uidnumber as uid,gidnumber as gid from mailbox where username='%u'
password_query= select username as user ,password,uidnumber as userdb_uid,gidnumber as userdb_gid,concat('*:bytes=',trim(TRAILING 'S' FROM quota)) as userdb_quota_rule from mailbox where username='%u'

my profile include quota, see this http://wiki2.dovecot.org/AuthDatabase/SQL




fy

From: Noel Butler
Date: 2012-07-29 11:45
To: dovecot
Subject: Re: [Dovecot] mysql auth failover failing
On Sat, 2012-07-28 at 19:53 +0300, Timo Sirainen wrote:

> It's in my TODO, but I don't know when I'll get around to implementing it. So many things to do right now..
> 


Thanks