[Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder

[Shayne Jellesma]

Hello,

I am getting a slightly different output in my log file with
"mail_debug=yes" set in my config:

May 31 09:25:51 IMAP(xxx): Info: Quota root: name= backend=maildir args=
May 31 09:25:51 IMAP(xxx): Info: Quota rule: root= mailbox=* bytes=10240000
messages=0
May 31 09:25:51 IMAP(xxx): Info: Quota rule: root= mailbox=Trash ignored


Regards,

Shayne Jellesma
Network Administrator / ICT Support
St Martins Lutheran College
Web: http://www.stmartins.sa.edu.au
Phone: (08) 87 251 430
Mobile: 0439 491 590
Skype: shayne.jellesma.smlc


-----Original Message-----
From: e-frog [mailto:e-frog at gmx.de] 
Sent: Sunday, 30 May 2010 11:28 PM
To: Dovecot List
Cc: Shayne Jellesma
Subject: Re: [Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder

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