[Dovecot] [SOLVED] quota with: postfixadmin, postfix, mysql & dovecot

[Peter Veerman]

Hi,

I'm quite new to dovecot but already quite satisfied. Your documentation
in the wiki is great but on quota + mysql it is not very clear. Because
of the previously mentioned I have got the following note to make which
you will hopefully use to adjust your wiki documentation on
per-user-quota + mysql. I've searched your mail archive as good as
possible and found no messages on this. If already messages have been
exactly on this topic I want to apologize for sending this one.

The notes I want to make is about this page: http://wiki.dovecot.org/Quota

I'm using postfix + postfixadmin & mysql and dovecot  (previously I used
courier-imap instead of dovecot).

The problems I ran in to was with setting up the per-user quota, as the
explanation at the wiki is quite vague.

For instance, the dict plugin is used to keep the quota counters in the
mysql backend but only one single line shows how to set-up a per user quota.

Setting up a per user quota where the max-quota is stored in mysql
should be made making use of this setting:

==========
user_query = SELECT home, uid, gid, 'dirsize:storage=' || quota_bytes AS
quota FROM users WHERE userid = '%u'
==========


nowhere is mentioned that this should also! be set:

===========
protocol imap {
mail_plugins = quota imap_quota
}
protocol pop3 {
mail_plugins = quota
}
===========


the second point I want to make is that the mysqlquery is incorrect as
|| does not do the job of joining the two strings. Secondly is dovecot
making use of kilobytes instead of bytes like postfix (and postfixadmin)
does.

For this I have found the following solution:

==========

user_query = SELECT maildir, 125 AS uid, 125 AS gid,\
 CONCAT('dirsize:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota \
 FROM mailbox WHERE username = '%u' AND active = '1'

==========

Here I select the quota field from the mailbox table. This is then
divided by 1024 (1Kbyte) and ROUNDED off in order to get rid of the .00
that results from this division.


Greetz,

Peter Veerman
pveerman NO-SPAM at NO-SPAM hackwerk DOT net