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