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@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
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@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@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
Hello all,
There was a problem with email account. Deleted it and readded and everything seems to be working. Thanks e-frog :)
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 Shayne Jellesma Sent: Monday, 31 May 2010 9:33 AM To: 'e-frog' Cc: dovecot@dovecot.org Subject: Re: [Dovecot] Dovecot 1.2 - Quotas - Ignoring Trash folder
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 Skype: shayne.jellesma.smlc
-----Original Message----- From: e-frog [mailto:e-frog@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@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
participants (2)
-
e-frog
-
Shayne Jellesma