[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