[Dovecot] Enforcing Dovecot Quotas

[Tim]

Thanks Leon

I changed my SQL to the following after trying a few combinations:

user_query = SELECT maildir, 5000 as uid, 5000 as
gid,concat('maildir:bytes=',quota) as quota FROM virtual_mailbox WHERE
username = '%u'

It seems that Dovecot didn't understand the * backend for some reason
(even though it's mentioned in the documentation)

and my logs now seem to picking up on this

May 09 22:29:09 IMAP(test at example.com): Info: Effective uid=mailuser,
gid=mailgroup, home=(none)
May 09 22:29:09 IMAP(test at example.com): Info: Quota root: name=bytes=1
backend=maildir args=

But the address in question is still receiving mail - should I be doing
something additional to cease mail delivery?

Thanks in advance!

Tim

On Tue, 2012-05-08 at 22:12 +0200, Leon Meßner wrote: 

> On Tue, May 08, 2012 at 01:59:38AM -0700, tcsmith1978 wrote:
> > 
> > Hello,
> > 
> > I have been looking at enforcing quotas for users of my mail system (postfix
> > and Dovecot v1.2). Have tried to follow a few tuts on the web but its not
> > having the desired effect. Essentially I can still send and receive mail on
> > an account that I believe has had its quota exceeded.
> > 
> > In my main.cf, I have:
> > 
> > userdb sql {
> >          args = /etc/dovecot/mysql/dovecot-mysql.conf
> > }
> > passdb sql {
> >          args = /etc/dovecot/mysql/dovecot-mysql.conf
> > }
> > 
> > and...
> > 
> > protocol lda {
> >         mail_plugins = quota
> > }
> > 
> > protocol imap {
> >         mail_plugins = quota imap_quota
> > }
> > 
> > plugin {
> >         quota_exceeded_message = You have exceeded the maximum quota for
> > your mailbox
> > }
> > 
> > the dovecot sql (mysql) file has the following query for pulling out user
> > ids and quotas etc:
> > 
> > user_query = SELECT maildir, mymailuser as uid, mymailgroup as
> > gid,concat('maildir:storage=',quota) as quota FROM virtual_mailbox WHERE
> > username = '%u'
> > 
> > I have set one of my users to have a quota of 1 (so one byte I believe) so
> > it should be over the limit pretty much immedisoemately.
> > 
> > Looking at the logs I can see that the system is picking up on the quota
> > limit but doesn't seem to enforce it.
> > 
> > Apr 27 10:29:02 deliver(test at testdomain.com): Info: auth input:
> > quota=maildir:storage=1
> > Apr 27 10:29:02 deliver(test at testdomain.com): Info: Quota root:
> > name=storage=1 backend=maildir args=
> > 
> > Any ideas? Am i missing something?
> 
> i would try something like in the wiki:
> plugin {
> 	quota = maildir:User quota
> 	quota_exceeded_message = You have exceeded
> }
> 
> Never used mysql for userdb or passdb though. Perhaps this would work:
> 
> user_query = SELECT maildir, mymailuser as uid, mymailgroup as
> gid,concat('*:storage=',quota) as quota_rule FROM virtual_mailbox
> WHERE
> username = '%u
> 
> 
> > -- 
> > View this message in context: http://old.nabble.com/Enforcing-Dovecot-Quotas-tp33763561p33763561.html
> > Sent from the Dovecot mailing list archive at Nabble.com.
> > 



-- 
Tim <tcsmith1978 at googlemail.com>