[Dovecot] Quota exceeded messages

[Frank Church]

On 10/07/07, Frank Church <voipfc at googlemail.com> wrote:
> >
> >
>
> I think I got to the bottom of the problem, which probably is the
> result of too much dependency on howtos and not enough RTFMing. I have
> an empty blog named 'howtos considered harmful' , and this will
> provide a good article.
>
> It appears that I changed my dovecot/sql.conf from one with a separate
> user_query and password_query to one with just the password_query in
> conjunction with the prefetch scheme, which did not include the quota
> setting. I will add " concat('dirsize:storage=', quota) AS
> userdb_quota " to the password_query to see if it will fix the
> problem.
>

Update:

After modifying the password_query to include
concat('dirsize:storage=', quota) AS
 userdb_quota, moving mails between mailboxes works.

Another thing to note is that the quota snippet in the SQL requires a
cast and should be
concat('dirsize:storage=', cast(quota as char)) AS
 userdb_quota