Problems to configure IMAP Quota

[Alex JOST]

Am 08.09.2017 um 14:42 schrieb Jacques Belin:
> 
> Hello,
> 
> We manage a mail server using Dovecot under Debian.
> Since a long time, we run nightly a script permitting to display the
> storage usage of each user on the webmail, using internal calls. The
> usage on each mailbox is stored in a Mysql database.
> 
> For several reasons, we would now want to use the IMAP quota feature,
> not only to let users have the quota displayed from their Mail clients.
> 
> But testing that features, I encounter two problems :
> 
> 1) It seems that when we use the sql dict, a map contaning the patern
> "priv/quota/limit/messages" is mandatory. Not specifying it  in
> dovecot-dict-sql.conf.ext issues an error.  As we are interested only by
> the storage size and don't want to process the number of messages, how
> to get rid of it ?

Set it to unlimited?


> 2) We store the storage value in kilobytes.
> But the plugin seems to only accept storage in bytes, Is there any way
> to let know to dovecot that the value stored in the database is in
> kilobytes ? (of course, I tried to put "size/1024" in the value_field
> field of the map. It works, but generate a lot of error lines in the
> dovecot log as it create a syntaxly incorrect MySQL uodate request...)

Using 'storage' instead of 'bytes' should provide limits as kilobytes.

See Wiki:
   https://wiki2.dovecot.org/Quota/Configuration#Limit_configuration

-- 
Alex JOST