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@dovecot.org [mailto:dovecot-bounces+shayne=stmartins.sa.edu.au@dovecot.org] On Behalf Of e-frog Sent: Sunday, 30 May 2010 10:09 PM To: dovecot@dovecot.org Subject: Re: [Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder
Hello,
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
On 30.05.2010 13:34, wrote Shayne Jellesma: 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_rule2See also http://wiki.dovecot.org/Quota/1.1#Quota_rules
Regards, e-frog