25 Jun
2007
25 Jun
'07
7:47 p.m.
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.