[Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder
e-frog
e-frog at gmx.de
Sun May 30 16:57:43 EEST 2010
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
More information about the dovecot
mailing list