[Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder

[e-frog]

On 30.05.2010 15:28, wrote Shayne Jellesma:
> Hello e-frog,
> 
> Thanks for your reply. I have made the changes you suggested and it is still
> not working.
> 
> The new updated SQL query is as follows: 
> user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, CONCAT('*:storage=',
> quota, 'B') AS quota_rule, 'Trash:ignore' AS quota_rule2 FROM mailbox WHERE
> username = '%u' AND active = '1'
> 

Looks correct and works for me.

You could try and set mail_debug=yes in dovecot.conf

This should log the quota rules dovecot is using once you login. e.g.

May 30 15:36:52 server dovecot: IMAP(xxx): Quota rule: root=user
mailbox=* bytes=1073741824 messages=0
May 30 15:36:52 server dovecot: IMAP(xxx): Quota rule: root=user
mailbox=Trash ignored


> Regards,
> 
> Shayne Jellesma
> Network Administrator / ICT Support
> St Martins Lutheran College
> Web: http://www.stmartins.sa.edu.au
> Skype: shayne.jellesma.smlc
> 
> -----Original Message-----
> From: dovecot-bounces+shayne=stmartins.sa.edu.au at dovecot.org
> [mailto:dovecot-bounces+shayne=stmartins.sa.edu.au at dovecot.org] On Behalf Of
> e-frog
> Sent: Sunday, 30 May 2010 10:09 PM
> To: dovecot at dovecot.org
> Subject: Re: [Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder
> 
> Hello,
> 
> On 30.05.2010 13:34, wrote Shayne Jellesma:
>> Hello guys,
>>
>> Firstly I would like to state that I am fairly new to Dovecot. I have 
>> played around with it in the past here and there but mainly with debian
> packages.
>> I have compiled this version of Dovecot from source, so please go easy 
>> with me.
>>
>> Ok now down to my questions:
>> I am having trouble getting Dovecot to 'ignore' the Trash folder when 
>> summing up the used quota for a user.
> 
> [snip]
> 
>> plugin:
>>
>>   quota: maildir:ignore=Trash
> 
> Change this to
> 
>     quota = maildir
> 
> [snip]
> 
>>
>> charged:/usr/local/etc# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf
>>
>> driver = mysql
>>
>> connect = host=localhost dbname=xxx user=mailuser password=xxx
>>
>> default_pass_scheme = MD5-CRYPT
>>
>> user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, 
>> CONCAT('*:storage=', quota, 'B') AS quota_rule FROM mailbox WHERE 
>> username = '%u' AND active = '1'
> 
> Insert a second quota_rule in your sql query
> 
>      'Trash:ignore' AS quota_rule2
> 
> See also http://wiki.dovecot.org/Quota/1.1#Quota_rules
> 
> Regards,
> e-frog