ok. 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@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.
--
Atenciosamente;
Graciously;
*Lucas Possamai *
http://psyscrew.posterous.com/
"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 environment.**