-ERR: Maildir

Discussion in 'Server Operation' started by mickey, Jul 25, 2006.

  1. mickey

    mickey New Member

    Hi!
    I installed new mail server, according Perfect setup (postfix+mysql+pop3/imap+clamav). Telnet on ports 25 and 110 is working. I still get a message in Outlook "-ERR: Maildir. No such file or directory".

    When I look into mail.log, there is:
    Jul 25 17:04:57 mail courierpop3login: LOGIN FAILED, ip=[::ffff:10.10.10.11]
    Jul 25 17:05:20 mail courierpop3login: Connection, ip=[::ffff:10.10.10.11]
    Jul 25 17:05:25 mail courierpop3login: LOGIN FAILED, ip=[::ffff:10.10.10.11]
    Jul 25 17:05:31 mail courierpop3login: Connection, ip=[::ffff:10.10.10.11]

    I tried it with two different login names and passwords into two accounts :(

    My main.cf:
    # See /usr/share/postfix/main.cf.dist for a commented, more complete version

    smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
    biff = no

    # appending .domain is the MUA's job.
    append_dot_mydomain = no

    # Uncomment the next line to generate "delayed mail" warnings
    #delay_warning_time = 4h

    myhostname = mail.automa.sk
    alias_maps = hash:/etc/aliases
    alias_database = hash:/etc/aliases
    myorigin = /etc/mailname
    mydestination = mail.automa.sk, localhost, localhost.localdomain
    relayhost =
    mynetworks = 127.0.0.0/8, 10.10.10.0/24
    mailbox_command =
    mailbox_size_limit = 0
    recipient_delimiter = +
    inet_interfaces = all
    smtpd_sasl_local_domain =
    smtpd_sasl_auth_enable = yes
    smtpd_sasl_security_options = noanonymous
    broken_sasl_auth_clients = yes
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
    smtpd_tls_auth_only = no
    smtp_use_tls = yes
    smtpd_use_tls = yes
    smtp_tls_note_starttls_offer = yes
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem
    smtpd_tls_loglevel = 1
    smtpd_tls_received_header = yes
    smtpd_tls_session_cache_timeout = 3600s
    tls_random_source = dev:/dev/urandom
    home_mailbox = Maildir/
    virtual_alias_domains =
    virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_mailbox_base = /home/vmail
    virtual_uid_maps = static:5000
    virtual_gid_maps = static:5000
    transport_maps = mysql:/etc/postfix/mysql-virtual_transports.cf
    virtual_create_maildirsize = yes
    virtual_mailbox_extended = yes
    virtual_mailbox_limit_maps = 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
    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_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
    content_filter = amavis:[127.0.0.1]:10024
    receive_override_options = no_address_mappings

    Where could be a problem?
    Thanks,
    mickey
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Have you sent an email to this account before you tried to login with pop3?

    Postfix cretaes your Maildir when the first email arrives.
     
  3. mickey

    mickey New Member

    How can I create Maildir, when this server is not actually connected to no network?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Use the command "maildirmake".
     
  5. mickey

    mickey New Member

    I proceed this command in /home/vmail. Maildir was created, but it still not working.

    Here is mail.log:
    Jul 27 11:02:34 mail amavis[2606]: (02606-05) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060727T110234-02606
    Jul 27 11:02:34 mail postfix/smtp[2689]: 63ED68EF19: to=<[email protected]>, relay=127.0.0.1[127.0.0.1], delay=39752, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=02606-05, creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN17> line 8. (in reply to end of DATA command))
    Jul 27 11:19:14 mail postfix/qmgr[1615]: 872D48EF16: from=<[email protected]>, size=476, nrcpt=1 (queue active)
    Jul 27 11:19:14 mail amavis[2610]: (02610-05) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=127.0.0.1;port=3306': Access denied for user: '[email protected]' (Using password: YES)
    Jul 27 11:19:14 mail amavis[2610]: (02610-05) TROUBLE in check_mail: creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN17> line 8.
    Jul 27 11:19:14 mail amavis[2610]: (02610-05) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060727T111914-02610
    Jul 27 11:19:14 mail postfix/smtp[2706]: 872D48EF16: to=<[email protected]>, relay=127.0.0.1[127.0.0.1], delay=206353, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=02610-05, creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN17> line 8. (in reply to end of DATA command))
    Jul 27 11:40:49 mail courierpop3login: Connection, ip=[::ffff:10.10.10.11]

    Here is main.cf:
    mail:/etc/postfix# cat main.cf
    # See /usr/share/postfix/main.cf.dist for a commented, more complete version

    smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
    biff = no

    # appending .domain is the MUA's job.
    append_dot_mydomain = no

    # Uncomment the next line to generate "delayed mail" warnings
    #delay_warning_time = 4h

    myhostname = mail.automa.sk
    alias_maps = hash:/etc/aliases
    alias_database = hash:/etc/aliases
    myorigin = /etc/mailname
    mydestination = mail.automa.sk, localhost, localhost.localdomain
    relayhost =
    mynetworks = 127.0.0.0/8, 10.10.10.0/24
    mailbox_command =
    mailbox_size_limit = 0
    recipient_delimiter = +
    inet_interfaces = all
    smtpd_sasl_local_domain =
    smtpd_sasl_auth_enable = yes
    smtpd_sasl_security_options = noanonymous
    broken_sasl_auth_clients = yes
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
    smtpd_tls_auth_only = no
    smtp_use_tls = yes
    smtpd_use_tls = yes
    smtp_tls_note_starttls_offer = yes
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem
    smtpd_tls_loglevel = 1
    smtpd_tls_received_header = yes
    smtpd_tls_session_cache_timeout = 3600s
    tls_random_source = dev:/dev/urandom
    home_mailbox = Maildir/
    virtual_alias_domains =
    virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_mailbox_base = /home/vmail
    virtual_uid_maps = static:5000
    virtual_gid_maps = static:5000
    transport_maps = mysql:/etc/postfix/mysql-virtual_transports.cf
    virtual_create_maildirsize = yes
    virtual_mailbox_extended = yes
    virtual_mailbox_limit_maps = 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
    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_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
    content_filter = amavis:[127.0.0.1]:10024
    receive_override_options = no_address_mappings

    mickey
     
  6. falko

    falko Super Moderator Howtoforge Staff

    Please make sure you use the correct MySQL password for mail_admin in your Postfix configuration. Also check that MySQL is running.
     
  7. mickey

    mickey New Member

    I checked MySQL - still runs. I also checked password in amavis.conf and is OK.

    I restarted mysql and amavis, but I still cannot connect with Outlook via POP3.

    mail.log shows:
    Jul 27 14:05:54 mail postfix/qmgr[1615]: 9D85A8EF14: from=<[email protected]>, size=371, nrcpt=1 (queue active)
    Jul 27 14:05:54 mail postfix/qmgr[1615]: 48B898EF17: from=<[email protected]>, size=476, nrcpt=1 (queue active)
    Jul 27 14:05:54 mail amavis[3058]: (03058-01) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=127.0.0.1;port=3306': Access denied for user: '[email protected]' (Using password: YES)
    Jul 27 14:05:54 mail amavis[3058]: (03058-01) TROUBLE in check_mail: creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN9> line 8.
    Jul 27 14:05:54 mail amavis[3058]: (03058-01) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060727T140554-03058
    Jul 27 14:05:54 mail postfix/smtp[3112]: 9D85A8EF14: to=<[email protected]>, relay=127.0.0.1[127.0.0.1], delay=242560, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=03058-01, creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN9> line 8. (in reply to end of DATA command))
    Jul 27 14:05:54 mail amavis[3059]: (03059-01) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=127.0.0.1;port=3306': Access denied for user: '[email protected]' (Using password: YES)
    Jul 27 14:05:54 mail amavis[3059]: (03059-01) TROUBLE in check_mail: creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN9> line 8.
    Jul 27 14:05:54 mail amavis[3059]: (03059-01) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20060727T140554-03059
    Jul 27 14:05:54 mail postfix/smtp[3113]: 48B898EF17: to=<[email protected]>, relay=127.0.0.1[127.0.0.1], delay=129952, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=03059-01, creating_partsdir FAILED: SQL server(s) not reachable at (eval 38) line 198, <GEN9> line 8. (in reply to end of DATA command))

    :confused:
     
  8. falko

    falko Super Moderator Howtoforge Staff

    Does your mail_admin MySQL password contain uncommon characters? Please try a password with just numbers and letters.
    Is there an entry for mail_admin in the mysql.user table? Is the host listed there localhost and/or localhost.localdomain?
     

Share This Page