[Dovecot] Quota from passdb sql
Timo Sirainen
tss at iki.fi
Mon Jun 25 19:47:14 EEST 2007
On Fri, 2007-06-22 at 18:33 -0300, Bruno Puga wrote:
> Hello folks!
>
> Is it possible to retrieve quota information from a passdb sql lookup and
> using static userdb?
No, but you can use prefetch userdb.
> password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS
> userdb_quota, password FROM users WHERE email = '%u'
Add the other fields to this SQL query as explained in
http://wiki.dovecot.org/UserDatabase/Prefetch
Of course it adds a bit of overhead for the SQL queries, but I don't
think it matters much.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20070625/a21137c5/attachment.bin
More information about the dovecot
mailing list