[Dovecot] Quota from passdb sql

[Timo Sirainen]

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