Hi all, I'm using Dovecot 2.1.16 and I'd like to know if the following configuration is supported: * An SQL dictionary quota * A static userdb to get uid/gid/home information * An SQL userdb to get per-user quota limit Currenlty, current quota usage are properly stored into the database but per-user limits are not found. If I replace the SQL dictionary by the maildir backend (my previous config.), it works as expected. Do you have any idea? Thanks in advance, Antoine Nguyen http://modoboa.org/
Up. Any idea about this? Does anybody ever try to build such a configuration? Thanks. 2013/4/13 Antoine Nguyen <ngu.antoine at gmail.com>> Hi all, > > I'm using Dovecot 2.1.16 and I'd like to know if the following > configuration is supported: > > * An SQL dictionary quota > * A static userdb to get uid/gid/home information > * An SQL userdb to get per-user quota limit > > Currenlty, current quota usage are properly stored into the database but > per-user limits are not found. If I replace the SQL dictionary by the > maildir backend (my previous config.), it works as expected. > > Do you have any idea? > > Thanks in advance, > > Antoine Nguyen > http://modoboa.org/ >
On 13.4.2013, at 15.52, Antoine Nguyen <ngu.antoine at gmail.com> wrote:> I'm using Dovecot 2.1.16 and I'd like to know if the following > configuration is supported: > > * An SQL dictionary quota > * A static userdb to get uid/gid/home information > * An SQL userdb to get per-user quota limit > > Currenlty, current quota usage are properly stored into the database but > per-user limits are not found. If I replace the SQL dictionary by the > maildir backend (my previous config.), it works as expected. > > Do you have any idea?You can't have both static userdb and sql userdb. Create just one sql userdb, which returns something like: select quota_rule, 123 uid, 123 as gid, '/home/%u' as home from quota_limits where username = '%u' I don't really understand what sql dict vs maildir backend has to do with it. Both of them get the limits from the same quota_rule the same way (although with maildir if you don't return a quota_rule, it gets the limits from the maildirsize file, maybe you were seeing this).