[Dovecot] Quota from passdb sql
Hello folks!
Is it possible to retrieve quota information from a passdb sql lookup and using static userdb?
I've tried here without success, and I can't find in the wiki or forum.
Some ways I configured dovecot-sql.conf:
password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS quota, password FROM users WHERE email = '%u'
password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS userdb_quota, password FROM users WHERE email = '%u'
With userdb sql things worked perfect, but as I can use static userdb I just need quota information per user from passwd sql.
Thanks, Bruno.
Forgot to inform that no error log is generated!
---------- Forwarded message ---------- From: Bruno Puga <brpuga@gmail.com> Date: Jun 22, 2007 6:33 PM Subject: Quota from passdb sql To: Dovecot Mailing List <dovecot@dovecot.org>
Hello folks!
Is it possible to retrieve quota information from a passdb sql lookup and using static userdb?
I've tried here without success, and I can't find in the wiki or forum.
Some ways I configured dovecot-sql.conf:
password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS quota, password FROM users WHERE email = '%u'
password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS userdb_quota, password FROM users WHERE email = '%u'
With userdb sql things worked perfect, but as I can use static userdb I just need quota information per user from passwd sql.
Thanks, Bruno.
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.
participants (2)
-
Bruno Puga
-
Timo Sirainen