Is the maildir support mail-quota in ispconfig?

Discussion in 'Installation/Configuration' started by chengkinhung, May 23, 2011.

  1. chengkinhung

    chengkinhung New Member

    ISPConfig 3.0.3.3
    CentOS 5.5
    dovecot-sieve-0.1.18-6.el5
    dovecot-1.2.15-1_113.el5
    postfix-2.3.3-2.1.centos.mysql_pgsql
     
    Last edited: May 23, 2011
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig uses maildir with quota.
     
  3. chengkinhung

    chengkinhung New Member

    But it is not working at all

    i setup the quota to 50M, and receive mails more than 100M now.

    could you please tell me how the mail quota with maildir in ISPConfig 3 work? any file name like "mailsize" need to create ?

    Thanks.
     
  4. chengkinhung

    chengkinhung New Member

    I found the reasone now:

    as the dovecot 1.2.x use field "quota_rule" to control quota:

    vi /etc/dovecot-sql.conf
    --------------------------------------------------------------------------------
    user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir')
    as mail, uid, gid, CONCAT('maildir:storage=', floor(quota/1024)) AS quota,
    CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
    #need to change to:
    user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', floor(quota/1024)) AS quota, CONCAT('*:storage=',floor(quota/1024)) AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
    --------------------------------------------------------------------------------

    Note: added CONCAT('*:storage=',floor(quota/1024)) AS quota_rule

    then restart the dovecot service,
    the quota function is working well now
     

Share This Page