[Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder

[e-frog]

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