Re: [Postfixadmin-devel] Message count quotas

[Christian B. <pos...@cb...>]

Hello,

Am Montag, 9. Februar 2015 schrieb Robert Moskowitz:
> I am running postfixadmin 2.91

You might want to update to 2.92 which contains some fixes ;-)

> I just got hit with the message count quota in dovecot:

> user_query = SELECT concat('/home/vmail/', maildir) as home,
> concat('maildir:/home/vmail/', maildir) as mail, 101 AS uid, 12 AS
> gid, CONCAT('*:messages=10000:bytes=', quota) as quota_rule FROM
> mailbox WHERE username = '%u' AND active = '1'
> 
> Note that messages=10000 is hard coded, where as bytes is pulled out
> of the postfixadmin database.
> 
> Has this been added since 2.91?  If not could it be?  I upped my
> message limit to 30000...

The current DOCUMENTS/DOVECOT.txt contains:

user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 
    1001 AS uid, 1001 AS gid, 
    CONCAT('*:bytes=', quota) AS quota_rule 
    FROM mailbox WHERE username = '%u' AND active='1'

so there's nothing that restricts the number of messages.

I'm quite sure we never had the messages= part in the query (I'd have to 
change the SVN history to be really sure).

Maybe you got your query from somewhere else and should just switch to 
the query I quoted above?


Regards,

Christian Boltz
-- 
There's such a thing as real life? Is it packages for openSUSE yet? 
Will there be a YaST2 module for easy configuration? Is it going to be
included in 11.2 or is it so complex it's going to have to wait until
11.3? More importantly, will it be on the DVD, or would people need to
use one of the online repos to download it?
[David Bolt in opensuse-packaging]