[Dovecot] Dovecot+Postfix+Mysql+quotas doesn't work

drum.lucas at gmail.com drum.lucas at gmail.com
Tue Mar 1 14:41:46 EET 2011

Thank's Ben.

My dovecot-sql.conf :

user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'
as mail, 150 AS uid, 12 AS gid, CONCAT('dirsize:storage=', ROUND(
mailbox.quota / 1024 ) ) AS quota FROM mailbox WHERE username = '%u' AND
active = '1'

So, I changed to:
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'
as mail, 150 AS uid, 12 AS gid, CONCAT('*:bytes=', quota) AS quota_rule,
'INBOX.Trash:ignore' AS quota_rule2, 'INBOX.Spam:ignore' AS quota_rule3,
'INBOX.Virus:ignore' AS quota_rule4, FROM mailbox WHERE username = '%u' AND
active = '1'

Are you agree?

Thank's again

2011/2/28 <ben at electricembers.net>

>  In my webmail, he informs me that I'm using the percentage of quota. But I
>>> can't make the TRASH folder is ignored. That is, I can't put a higher
>>> limit on it than the others.
>>> Am I doing something wrong?
> We use something like this in our "user_query" SQL, which overrides the
> rules put in config file(s):
>  concat('*:bytes=', quota) AS quota_rule, 'INBOX.Trash:ignore' AS
> quota_rule2, 'INBOX.Spam:ignore' AS quota_rule3, 'INBOX.Virus:ignore' AS
> quota_rule4,
> But we run version 2.0.9 - quota stuff changed a bit from 1 to 2.
> (I think I had to add the "INBOX." part.)
>  Another thing. I'm not receiving message of quota exceeded. This is with
>>> the MTA or dovecot?
> That is another thing. Likely a bit different in Dovecot 2 now, but in any
> version, only the LDA knows when the theshold is being crossed @ deliver
> time. Dovecot's LDA can be configured to execute a script which must do the
> actual delivering of the warning message. Example script given in
> documentation is working for us.




*Lucas Possamai


"Sucesso é a capacidade de enfrentar o fracasso sem perder o entusiasmo"

"Success is the ability to cope with failure without losing enthusiasm"

*INFORMAÇÃO DE SEGURANÇA:* Este e-mail é de uso restritamente pessoal. As
informações nele contidas podem ser de caráter confidencial e/ou
privilegiada. Se você não for o destinatário e recebeu a mensagem por
engano, avise imediatamente o remetente e em seguida apague o e-mail,
ficando, expressamente vedado o uso, cópia e/ou divulgação das informações
contidas, sob pena de responsabilização.

*SAFETY INFORMATION:* This e-mail is strictly personal use. The
information contained
here may be confidential and / or privileged. If you aren't the intended
recipient and received the message in error, please notify the sender
immediately and delete the email, being expressly forbidden the use, copying
and / or disclosure of information, under penalty of accountability.
*P* Antes de imprimir, pense em sua responsabilidade e seu compromisso com o
meio ambiente.
*P* Before printing, think about your responsibility and commitment to the

More information about the dovecot mailing list