Mail quota problem

Discussion in 'Installation/Configuration' started by pma_, May 27, 2011.

  1. pma_

    pma_ New Member

    I tried to implement mail quota notification, but there is no maildirsize file in vmail/domain/user. How can I check quota for a user?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    There should be a maildirsize file there. Which ISPConfig Version, imap daemin and Linux distribution do you use?
     
  3. pma_

    pma_ New Member

    CentOs 5.6 on OpenVZ
    ISPConfig 3 latest (installed yesterday)
    dovecot (dovecot-sieve is disabled because of incompatibility)

    just followed perfect server. One difference I enabled quota after ISPConfig installation

    update:
    I discovered that I commented out quota plug in for lda (while commenting out sieve), corrected, dovecot restarted, new user created and still no success

    update 2:
    quota is corretly set in mail_user table
     
    Last edited: May 27, 2011
  4. pma_

    pma_ New Member

    Any idea how to make it work? I need 2 simple things quota limit notification (functionality of dovecot) and mailbox size in roundcube.


    I digged a bit into logs and I discovered something that I don't understand.
    In quota plugin there is simple statement quota = maildir but in select results there is something like quota=maildir:storage=1024 so I assume that statement in dovecot.conf isn't important, is this right?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Make sure that the quota plugin is enabled for imap.
     
  6. pma_

    pma_ New Member

    I checked parameters about 10 times and after digging in many places I found a solution, I'm not sure if this is a bug or feature of dovecot, but this works.
    I changed query in dovecot-sql.conf to (reformated a bit here)

    user_query =
    SELECT email as user, maildir as home,
    CONCAT('maildir:', maildir, '/Maildir') as mail,
    uid, gid,
    'maildir' 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'


    Should I create a ticket?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Please create a ticket if you use dovecot 1.x (as dovecot 2.x is not supported yet) and also post the exact dovecot version number as this query depends on the dovecot version that you use.
     

Share This Page