when quota is zero means?

Discussion in 'HOWTO-Related Questions' started by Rupert, Feb 26, 2008.

  1. Rupert

    Rupert New Member

  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    He should not get any mails at all.
     
  3. Rupert

    Rupert New Member

    ok, so how can I debug this?
     
  4. Rupert

    Rupert New Member

    I just realized that we use maildrop for final delivery
    should i get maildrop than to check the quota stuff?

    this is our global maildroprc

    Code:
    # Ruta al /home/vmail/domains
    VHOME="/home/vmail/"
    # This extracts the username part from username at domain.tld
    ACCOUNT=`echo "$LOGNAME" | cut -d@ -f1`
    # This extracts the domain name from username at domain.tld
    USERDOMAIN=`echo "$LOGNAME" | cut -d@ -f2`
    # Path to the file where we will log the account creation.
    VMAIL_LOGFILE="/home/vmail/maildrop-maildirmake.log"
    # Path to maildirmake
    MAILDIRMAKE=/usr/bin/maildirmake
    
    # Let's check if /home/vmail/domain.tld/username exists
    `test -d "$VHOME/$USERDOMAIN/$ACCOUNT"`
    if( $RETURNCODE == 1 )
    {
        MESSAGE_DATE = `date`
        # Log the creation date of this account in maildrop-maildirmake.log
        `echo CREATION DATE:    "$MESSAGE_DATE" >> $VMAIL_LOGFILE`
        # Log the full path of the mailbox directory in maildrop-maildirmake.log
        `echo EMAIL DIRECTORY:  "$VHOME/$USERDOMAIN/$ACCOUNT" >> $VMAIL_LOGFILE`
        # Log the username at domain.tld in maildrop-maildirmake.log
        `echo USER EMAIL LOGIN: "$LOGNAME" >> $VMAIL_LOGFILE`
        # Append a blanck line to maildrop-maildirmake.log
        `echo " " >> $VMAIL_LOGFILE`
    
        # Now check if the domain directory /home/vmail/dominio.tld exists.
        `test -d "$VHOME/$USERDOMAIN"`
        if( $RETURNCODE == 1 )
        {
            # Log the domain directory to maildrop-maildirmake.log
            `echo CREATING DIRECTORY: "$VHOME/$USERDOMAIN" >> $VMAIL_LOGFILE`
            # This creates the domain directory under /home/vmail/domains/
            `mkdir -p "$VHOME/$USERDOMAIN"`
            # Append a blanck line to maildrop-maildirmake.log
            `echo " " >> $VMAIL_LOGFILE`
        }
        # Create the mailbox directory for the new account, this will be:
        # /home/vmail/domains/domain.tld/username/
        `$MAILDIRMAKE "$VHOME/$USERDOMAIN/$ACCOUNT"`
        # Lets create the Sent directory for IMAP users
        `$MAILDIRMAKE -f Sent "$VHOME/$USERDOMAIN/$ACCOUNT"`
        # Suscribe the new Sent directory to the suscribed folders, only for courier-imap users.
        `echo INBOX.Sent >> $VHOME/$USERDOMAIN/$ACCOUNT/courierimapsubscribed`
        # Lets create the Thrash directory for IMAP users
        `$MAILDIRMAKE -f Trash "$VHOME/$USERDOMAIN/$ACCOUNT"`
        # Suscribe the new Trash directory to the suscribed folders, only for courier-imap users.
        `echo INBOX.Trash >> $VHOME/$USERDOMAIN/$ACCOUNT/courierimapsubscribed`
        # Create the curierimapuiddb directory under the user maildir
        `touch $VHOME/$USERDOMAIN/$ACCOUNT/courierimapuiddb`
        # Create the courierimapkeywords file under the user maildir
        `mkdir -p "$VHOME/$USERDOMAIN/$ACCOUNT/courierimapkeywords"`
    }
    
    
    
    # GLOBAL VARIABLES
    # HOME=/home/vmail/dominios
    # LOGNAME=username at dominio.tld
    # DEFAULT=dominio.tld/username/
    
    # Log everything to this file
    logfile "/home/vmail/maildrop.log"
    
    # LOG BEGING OF FILTERING
    log "====  BEGIN maildrop processing for $LOGNAME ==="
    
    exception {
        log "Including $HOME/$DEFAULT.mailfilter"
        include "$HOME/$DEFAULT.mailfilter"
    }
    
    ##
    # move spam to spamfolder
    ##
    SPAMFLD=$DEFAULT/.Junk/
    SUBSCRIPT=$DEFAULT/courierimapsubscribed
    
    # test idf Junk folder exists, if notr create one
    # autosubscribe to the Junk folder
    `test -d "$SPAMFLD"`
    if( $RETURNCODE == 1 )
    {
            `maildirmake "$SPAMFLD"`
            `echo INBOX.Junk >> $SUBSCRIPT`
    }
    
    
    ## verschiebe die mail in den Junk Ordner, wenn Spam
    if (/^X-Spam-Status: Yes,/)
    {
            exception {
                    to $SPAMFLD
            }
    }
    
    
    thx
     
  5. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    The quota stuff should normally be handled by Postfix. Have you compared your configuration to the one from the tutorial? Maybe you made a typo somewhere.
     
  6. Rupert

    Rupert New Member

    well i found out that postfix does not create the file maildirsize.
    when i create that manually and put in the first line "5000S"
    it works.
    But it should get all that stuff from the DB, so how can i proceed?

    these are the entries from my main.cf


    #virtual_mailbox_extended = yes
    virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
    virtual_mailbox_limit_override = yes
    virtual_maildir_limit_message = "The user you are trying to reach is over quota."
    virtual_overquota_bounce = yes
    virtual_mailbox_limit_inbox = yes
    virtual_maildir_extended = yes
    virtual_create_maildirsize = yes
    virtual_maildir_suffix = Maildir/


    EDIT: i took a log in the mysql_query logfile and it seems the query in mailbox_limit_maps does not get executed?
    Why not`?

    greetings

    .r
     
    Last edited: Feb 29, 2008
  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Please check all your configuration files again. Maybe you made a typo somewhere?
     
  8. Rupert

    Rupert New Member

    this is the output of postconf -n:
    can there be an option somewhere else wrong?
    All the other queries run fine

    Code:
    alias_maps = hash:/etc/aliases
    biff = no
    broken_sasl_auth_clients = yes
    command_directory = /usr/sbin
    config_directory = /etc/postfix
    daemon_directory = /usr/libexec/postfix
    debug_peer_level = 1
    html_directory = no
    inet_interfaces = all
    mail_owner = postfix
    mailq_path = /usr/bin/mailq.postfix
    manpage_directory = /usr/share/man
    message_size_limit = 30720000
    newaliases_path = /usr/bin/newaliases.postfix
    proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_can
    queue_directory = /var/spool/postfix
    readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
    receive_override_options = no_address_mappings
    sample_directory = /usr/share/doc/postfix-2.3.3/samples
    sendmail_path = /usr/sbin/sendmail.postfix
    setgid_group = postdrop
    smtpd_client_restrictions = permit_sasl_authenticated,permit_mynetworks,reject
    smtpd_hard_error_limit = 1
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination, reject_unlisted_recipient
    smtpd_sasl_auth_enable = yes
    smtpd_sasl_security_options = noanonymous
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_use_tls = yes
    transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf, proxy:mysql:/etc/postfix/mysql-virtual_mailhosts.cf
    unknown_local_recipient_reject_code = 550
    virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf
    virtual_create_maildirsize = yes
    virtual_gid_maps = static:5000
    virtual_mailbox_base = /home/vmail
    virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
    virtual_mailbox_limit_override = yes
    virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_maildir_limit_message = "The user you are trying to reach is over quota."
    virtual_overquota_bounce = yes
    virtual_transport = maildrop
    virtual_uid_maps = static:5000
    
    
    even the maildrop has the quota extension enabled

    # maildrop -v
    maildrop 2.0.4 Copyright 1998-2005 Double Precision, Inc.
    GDBM extensions enabled.
    Courier Authentication Library extension enabled.
    Maildir quota extension enabled.
    This program is distributed under the terms of the GNU General Public
    License. See COPYING for additional information.
     
    Last edited: Mar 3, 2008
  9. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Are there any errors in your mail log?
     
  10. Rupert

    Rupert New Member

    havent seen any. I run for 2 weeks on degublogig, but never saw anything about that some queries couldnt be launched :(.
     
  11. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Does
    Code:
    postfix check
    show any output?
     

Share This Page