Quota & prefetch uiserDB questions

[Cédric ML]

I'll answer my own question :

Adding quota information in user_query like this :

user_query = SELECT \
     maildir as mail, \
     homedir as home, \
     uid, \
     gid, \
--->    CONCAT('*:bytes=', quota) AS quota_rule \
     FROM mailbox WHERE username = '%u'


fixed my problem.

Regards,

Cédric


Le 12/10/2016 à 08:53, Cédric ML a écrit :
> Hello,
>
> I'm trying to make quota work on my dovecot server.
> I'm using prefetch userdb (source : 
> http://wiki2.dovecot.org/UserDatabase/Prefetch) with a database 
> located on a remote host :
>
> passdb {
>   driver = sql
>   args = /etc/dovecot/dovecot-sql.conf.ext
> }
>
> userdb {
>    driver = prefetch
> }
>
> userdb {
>   driver = sql
>   args = /etc/dovecot/dovecot-sql.conf.ext
> }
>
>
> With password_query containing (source : 
> http://wiki2.dovecot.org/Quota/Configuration) :
> password_query = SELECT \
>         username AS user, \
>         password, \
>         homedir AS userdb_home, \
>         maildir AS userdb_mail, \
>         uid AS userdb_uid, \
>         gid AS userdb_gid, \
>         CONCAT('*:bytes=', quota) AS userdb_quota_rule \
>     FROM mailbox \
>     WHERE username = '%u'
>
>
>
> When I change the quota value in DB, it's not reflected to maildirsize 
> file of the user.
> If I delete maildirsize file, it's re-created but not with the quota 
> value which is set in the DB.
>
> Questions : how is this maildirsize file created ? how is it updated ?
> is there a way to make maildir++ quota work with dovecot using 
> prefetch userDB ? Or do I have to use dict quotas ?
>
> Many thanks for your help.
> Regards,
> Cédric