Peter Veerman wrote:

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

nowhere is mentioned that this should also! be set:

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

To quote the second paragraph of http://wiki.dovecot.org/Quota:

--->8---

The quota backends are implemented as plugins for Dovecot. There is
also a plugin named "quota" which does the actual work. For reporting
quota information via IMAP, there is the "imap_quota" plugin. Usually
you'd enable these by adding them to the mail_plugins settings in
config file:

protocol imap { mail_plugins = quota imap_quota } protocol pop3 { mail_plugins = quota } # In case you're using Dovecot-LDA: protocol lda { mail_plugins = quota }

--->8---

the second point I want to make is that the mysqlquery is incorrect as || does not do the job of joining the two strings.

The page solely states this as "an example using a SQL-based user
database". No word about mysql.

You just ran into the problem that mysql isn't following the
standards concerning the ||-operator (as it is by the way documented
in the mysql manuals). But maybe there should simply be a small note that this doesn't work
with mysql because it is broken in this part and that one should use
concat instead.

Secondly is dovecot making use of kilobytes instead of bytes like postfix (and
postfixadmin) does.

Which is also documented on the wiki page. But I agree - this
behaviour is in contrast to about all other programs and IMHO this is
very annoying.

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'

I solved this in a similar way using views with postgresql.

But the real problem IMHO is not bytes vs. kilobytes (solution is
very simple as you showed above) but dovecot treating '0' values in
the database literally. All the other programs take '0' as unlimited
quota and therefore it's very easy to experience an unpleasant
surprise with dovecot-lda.

If you run postfixadmin as mentioned above you will probably
completely lock out all your users with unlimited quota. I could be
wrong here but IIRC postfixadmin uses '0' for unlimited/unset quota,
too.

Marcus