Sending email issue

Discussion in 'Installation/Configuration' started by lezelf, Aug 5, 2011.

  1. lezelf

    lezelf New Member

    Hi,

    I used this tutorial:
    http://www.howtoforge.com/perfect-server-debian-squeeze-with-bind-and-courier-ispconfig-3

    EDIT: Wrong Link, i used this one: http://www.howtoforge.com/perfect-server-debian-lenny-debian-5.0-with-bind-and-dovecot-ispconfig-3

    And i got some issue. My webs applications are sending mails, but those mails stay local.

    -On isp config 3, i can found every mail in the queue tab.
    -error tab:

    Code:
    Aug 4 16:35:11 server postfix/smtp[9320]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/smtp[9403]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/error[9411]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/error[9412]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/error[9413]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/error[9414]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:12 server postfix/error[9415]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 16:35:59 server postfix/smtpd[9463]: fatal: no SASL authentication mechanisms
    warning-tab:

    Code:
    Aug 4 17:52:20 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
    Aug 4 17:52:20 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14349 exit status 1
    Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14350 exit status 1
    Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14351 exit status 1
    Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14352 exit status 1
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 4AD584C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5A8AA4C79F6: virtual_alias_maps map lookup problem for root@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5AC5E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 55E184C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 6A85B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 6B0FD4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 765894C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7A4F04C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7AEAC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7BC674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7DA944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7E42A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 80B264C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 814594C79F6: virtual_alias_maps map lookup problem for www-data@mydomnain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 81CC84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 826164C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 82EF24C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 840034C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 848E74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8517F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 85B384C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 864394C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 86A0B4C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 876634C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 883EB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 891944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 89ECB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8A7D84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8B1114C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8BA654C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8C75D4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8D3AF4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8E45A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8EAE54C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 901C74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 90B0A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 914604C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 91DFC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9311B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 93A754C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 946E64C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 953BB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 965184C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 9AC474C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 9D5EA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9DEC14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A28A84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A31FB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A3B074C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A47E14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A501E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A90A34C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A9A4A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AA4304C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AB5DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: ABF514C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AC7FC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AD20B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AE3DC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14360]: warning: AEC774C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AF5674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B154E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B1E564C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B42014C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B4B134C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B541F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B61DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
    Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
    Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)FWD via SMTP: -> , 451 4.5.0 From MTA([127.0.0.1]:10025) during fwd-connect (Negative greeting: at (eval 84) line 555, line 868.): id=10580-12
    Aug 4 17:52:55 server postfix/smtp[14340]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Aug 4 17:52:55 server postfix/smtp[14340]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Aug 4 17:52:56 server postfix/master[3594]: warning: process /usr/lib/postfix/smtp pid 14340 exit status 1
    Aug 4 17:52:56 server postfix/qmgr[12515]: warning: private/amavis socket: malformed response
    Aug 4 17:52:56 server postfix/qmgr[12515]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
    Aug 4 17:53:00 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
    Aug 4 17:53:00 server postfix/smtpd[14406]: warning: SASL: Connect to private/auth failed: Connection refused
    Aug 4 17:53:00 server postfix/smtpd[14406]: fatal: no SASL authentication mechanisms
    Aug 4 17:53:01 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14406 exit status 1
    Aug 4 17:53:01 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    Aug 4 17:53:18 server postfix/smtpd[14413]: warning: SASL: Connect to private/auth failed: Connection refused
    Aug 4 17:53:18 server postfix/smtpd[14413]: fatal: no SASL authentication mechanisms
    Aug 4 17:53:19 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14413 exit status 1
    Aug 4 17:53:19 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
    If look for solutions on the forum, but none seems to be working.
    If it can help, my postfix/main.conf :
    Code:
    # See /usr/share/postfix/main.cf.dist for a commented, more complete version
    
    
    # Debian specific:  Specifying a file name will cause the first
    # line of that file to be used as the name.  The Debian default
    # is /etc/mailname.
    #myorigin = /etc/mailname
    
    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
    
    readme_directory = /usr/share/doc/postfix
    
    # TLS parameters
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_use_tls = yes
    smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
    smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
    
    # See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
    # information on enabling SSL in the smtp client.
    
    myhostname = server.mydomain.com
    alias_maps = hash:/etc/aliases
    alias_database = hash:/etc/aliases
    myorigin = /etc/mailname
    mydestination = server.mydomain.com, localhost, localhost.localdomain
    relayhost =
    mynetworks = 127.0.0.0/8 [::1]/128
    mailbox_command = procmail -a "$EXTENSION"
    mailbox_size_limit = 0
    recipient_delimiter = +
    inet_interfaces = all
    html_directory = /usr/share/doc/postfix/html
    virtual_alias_domains =
    virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_mailbox_base = /var/vmail
    virtual_uid_maps = static:5000
    virtual_gid_maps = static:5000
    smtpd_sasl_auth_enable = yes
    broken_sasl_auth_clients = yes
    smtpd_sasl_authenticated_header = yes
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
    smtpd_tls_security_level = may
    transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
    relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
    relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
    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_canon$
    smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
    # See /usr/share/postfix/main.cf.dist for a commented, more complete version
    
    
    # Debian specific:  Specifying a file name will cause the first
    # line of that file to be used as the name.  The Debian default
    # is /etc/mailname.
    #myorigin = /etc/mailname
    
    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
    
    readme_directory = /usr/share/doc/postfix
    
    # TLS parameters
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_use_tls = yes
    smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
    smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
    
    # See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
    # information on enabling SSL in the smtp client.
    
    myhostname = server.mydomain.com
    alias_maps = hash:/etc/aliases
    alias_database = hash:/etc/aliases
    myorigin = /etc/mailname
    mydestination = server.mydomain.com, localhost, localhost.localdomain
    relayhost =
    mynetworks = 127.0.0.0/8 [::1]/128
    mailbox_command = procmail -a "$EXTENSION"
    mailbox_size_limit = 0
    recipient_delimiter = +
    inet_interfaces = all
    html_directory = /usr/share/doc/postfix/html
    virtual_alias_domains =
    virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_mailbox_base = /var/vmail
    virtual_uid_maps = static:5000
    virtual_gid_maps = static:5000
    smtpd_sasl_auth_enable = yes
    broken_sasl_auth_clients = yes
    smtpd_sasl_authenticated_header = yes
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
    smtpd_tls_security_level = may
    transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
    relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
    relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
    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_canon$
    smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
    
    and
    Code:
    telnet localhost 25
    doesn't work instead of
    Code:
    telnet 127.0.0.1 25

    could you please help me? It would be really apreciated.
     
    Last edited: Aug 5, 2011
  2. Mark_NL

    Mark_NL New Member

    double, triple, quadrupal check the how-to, because if you follow it to the letter, it WILL work.

    From the information you provided i see there is a problem with your mysql server

    you get that because of:

     
  3. falko

    falko Super Moderator

    What's the output of
    Code:
    netstat -tap
    ?
     
  4. lezelf

    lezelf New Member

    Thanks for your answers.

    @falko, the output shows:

    Code:
    (No info could be read for "-p": geteuid()=1000 but you should be root.)
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 localhost:10024         *:*                     LISTEN      -               
    tcp        0      0 localhost:10025         *:*                     LISTEN      -               
    tcp        0      0 *:mysql                 *:*                     LISTEN      -               
    tcp        0      0 localhost:spamd         *:*                     LISTEN      -               
    tcp        0      0 server.mydomai:domain *:*                     LISTEN      -               
    tcp        0      0 localhost:domain        *:*                     LISTEN      -               
    tcp        0      0 *:ssh                   *:*                     LISTEN      -               
    tcp        0      0 *:smtp                  *:*                     LISTEN      -               
    tcp        0      0 localhost:953           *:*                     LISTEN      -               
    tcp        0      0 *:1723                  *:*                     LISTEN      -               
    tcp        0     48 server.mydomain.c:ssh modemcable028.124:11445 ESTABLISHED -               
    tcp        0      0 server.mydomain:56401 akismet.com:www         TIME_WAIT   -               
    tcp6       0      0 [::]:http-alt           [::]:*                  LISTEN      -               
    tcp6       0      0 [::]:www                [::]:*                  LISTEN      -               
    tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN      -               
    tcp6       0      0 [::]:domain             [::]:*                  LISTEN      -               
    tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      -               
    tcp6       0      0 localhost:953           [::]:*                  LISTEN      -               
    tcp6       0      0 [::]:https              [::]:*                  LISTEN      -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1166 TIME_WAIT   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1158 TIME_WAIT   -               
    tcp6       0  16610 server.mydomain.c:www 89.35.223.218%3463:1170 FIN_WAIT1   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1143 TIME_WAIT   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1153 TIME_WAIT   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1133 TIME_WAIT   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1130 TIME_WAIT   -               
    tcp6       0      0 server.mydomain.c:www 89.35.223.218%3463:1118 TIME_WAIT   -
    any idee of what is wrong?

    @Mark_NL I followed it. everything else is working i don't know what's wrong here :(.

    I don't have any /etc/init.d/mysqld to restart :(

    Thanks again.


    EDIT: I got this:

    Code:
    myname@server:~$ sudo /etc/init.d/mysql restart
    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld.
    Checking for corrupt, not cleanly closed and upgrade needing tables..
    
     
    Last edited: Aug 5, 2011
  5. Mark_NL

    Mark_NL New Member

    Oke, so mysql is running .. does the socket file exist?

    Code:
    ls -al /var/run/mysqld/mysqld.sock
     
  6. lezelf

    lezelf New Member


    yes
    Code:
    myname@server:~$ ls -al /var/run/mysqld/mysqld.sock
    srwxrwxrwx 1 mysql mysql 0 2011-08-05 09:40 /var/run/mysqld/mysqld.sock
    
    i'm trying some restart and other stuff, i assume this is why the date is the today's date.
     
  7. Mark_NL

    Mark_NL New Member

    Ii'm guessing you changed the password of the ispconfig mysql user and now all your daemons can't log into mysql anymore. Or you made a typo ..

    if you can log into the ispconfig3 web admin, then f.e. check this:

    Code:
    grep db_password /usr/local/ispconfig/interface/lib/config.inc.php
    that's the correct password for the mysql 'ispconfig' user.

    Result should be somthing like this:
    Code:
    $conf['db_password'] = '<PASSWORD>';
    define('DB_PASSWORD',$conf['db_password']);
    
    Now check if it's the same as the one in these files:
    Code:
    ./courier/authmysqlrc
    ./amavis/conf.d/50-user
    ./pure-ftpd/db/mysql.conf
    ./pam.d/smtp
    ./postfix/mysql-virtual_client.cf
    ./postfix/mysql-virtual_forwardings.cf
    ./postfix/mysql-virtual_relayrecipientmaps.cf~
    ./postfix/mysql-virtual_sender.cf~
    ./postfix/mysql-virtual_recipient.cf~
    ./postfix/mysql-virtual_email2email.cf
    ./postfix/mysql-virtual_email2email.cf~
    ./postfix/mysql-virtual_mailboxes.cf~
    ./postfix/mysql-virtual_mailboxes.cf
    ./postfix/mysql-virtual_transports.cf~
    ./postfix/mysql-virtual_domains.cf
    ./postfix/mysql-virtual_client.cf~
    ./postfix/mysql-virtual_relaydomains.cf
    ./postfix/mysql-virtual_domains.cf~
    ./postfix/mysql-virtual_forwardings.cf~
    ./postfix/sasl/smtpd.conf
    ./postfix/sasl/smtpd.conf~
    ./postfix/mysql-virtual_relaydomains.cf~
    ./postfix/mysql-virtual_relayrecipientmaps.cf
    ./postfix/mysql-virtual_transports.cf
    ./postfix/mysql-virtual_recipient.cf
    ./postfix/mysql-virtual_sender.cf
    ./vlogger-dbi.conf
    you can check it if it exists in the files with this command:

    Code:
    find /etc -type f -exec grep -l '<PASSWORD>' {} \;
     
  8. lezelf

    lezelf New Member

    Code:
    /etc/postfix/mysql-virtual_relaydomains.cf
    /etc/postfix/mysql-virtual_sender.cf
    /etc/postfix/mysql-virtual_email2email.cf
    /etc/postfix/mysql-virtual_recipient.cf
    /etc/postfix/mysql-virtual_client.cf
    /etc/postfix/mysql-virtual_mailboxes.cf
    /etc/postfix/mysql-virtual_forwardings.cf
    /etc/postfix/mysql-virtual_transports.cf
    /etc/postfix/mysql-virtual_relayrecipientmaps.cf
    /etc/postfix/mysql-virtual_domains.cf
    /etc/amavis/conf.d/50-user
    /etc/vlogger-dbi.conf
    /etc/dovecot/dovecot-sql.conf
    /etc/pure-ftpd/db/mysql.conf
    
    here is the list i got.
    there is no "courier" subfolder,
    neither pam.d/smtp files.

    /postfix/sasl exist but is empty.
     
  9. Mark_NL

    Mark_NL New Member

  10. lezelf

    lezelf New Member

    Last edited: Aug 5, 2011
  11. falko

    falko Super Moderator

    Can you check if maybe your Postfix is running chrooted (it shouldn't) - you can find that info in /etc/postfix/master.cf.
     
  12. lezelf

    lezelf New Member

    Code:
    # 
    # Postfix master process configuration file.  For details on the format
    # of the file, see the master(5) manual page (command: "man 5 master").
    # 
    # Do not forget to execute "postfix reload" after editing this file.
    #
    # ==========================================================================
    # service type  private unpriv  chroot  wakeup  maxproc command + args
    #               (yes)   (yes)   (yes)   (never) (100)
    # ==========================================================================
    smtp      inet  n       -       -       -       -       smtpd
    #submission inet n       -       -       -       -       smtpd
    #  -o smtpd_tls_security_level=encrypt
    #  -o smtpd_sasl_auth_enable=yes
    #  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
    #  -o milter_macro_daemon_name=ORIGINATING
    #smtps     inet  n       -       -       -       -       smtpd
    #  -o smtpd_tls_wrappermode=yes
    #  -o smtpd_sasl_auth_enable=yes
    #  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
    #  -o milter_macro_daemon_name=ORIGINATING
    #628      inet  n       -       -       -       -       qmqpd
    pickup    fifo  n       -       -       60      1       pickup
    cleanup   unix  n       -       -       -       0       cleanup
    qmgr      fifo  n       -       n       300     1       qmgr
    #qmgr     fifo  n       -       -       300     1       oqmgr
    tlsmgr    unix  -       -       -       1000?   1       tlsmgr
    rewrite   unix  -       -       -       -       -       trivial-rewrite
    bounce    unix  -       -       -       -       0       bounce
    defer     unix  -       -       -       -       0       bounce
    trace     unix  -       -       -       -       0       bounce
    verify    unix  -       -       -       -       1       verify
    flush     unix  n       -       -       1000?   0       flush
    proxymap  unix  -       -       n       -       -       proxymap
    proxywrite unix -       -       n       -       1       proxymap
    smtp      unix  -       -       -       -       -       smtp
    # When relaying mail as backup MX, disable fallback_relay to avoid MX loops
    relay     unix  -       -       -       -       -       smtp
            -o smtp_fallback_relay=
    #       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
    showq     unix  n       -       -       -       -       showq
    error     unix  -       -       -       -       -       error
    retry     unix  -       -       -       -       -       error
    discard   unix  -       -       -       -       -       discard
    local     unix  -       n       n       -       -       local
    virtual   unix  -       n       n       -       -       virtual
    lmtp      unix  -       -       -       -       -       lmtp
    anvil     unix  -       -       -       -       1       anvil
    scache    unix  -       -       -       -       1       scache
    #
    # ====================================================================
    # Interfaces to non-Postfix software. Be sure to examine the manual
    # pages of the non-Postfix software to find out what options it wants.
    #
    # Many of the following services use the Postfix pipe(8) delivery
    # agent.  See the pipe(8) man page for information about ${recipient}
    # and other message envelope options.
    # ====================================================================
    #
    # maildrop. See the Postfix MAILDROP_README file for details.
    # Also specify in main.cf: maildrop_destination_recipient_limit=1
    #
    maildrop  unix  -       n       n       -       -       pipe
      flags=DRhu user=vmail argv=/usr/bin/maildrop -d vmail ${extension} ${recipient} ${user} ${nexthop} ${sender}
    #
    # See the Postfix UUCP_README file for configuration details.
    #
    uucp      unix  -       n       n       -       -       pipe
      flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
    #
    # Other external delivery methods.
    #
    ifmail    unix  -       n       n       -       -       pipe
      flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
    bsmtp     unix  -       n       n       -       -       pipe
      flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
    scalemail-backend unix  -       n       n       -       2       pipe
      flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
    mailman   unix  -       n       n       -       -       pipe
      flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
      ${nexthop} ${user}
    
    dovecot   unix  -       n       n       -       -       pipe
      flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${user}@${nexthop}
    amavis unix - - - - 2 smtp
            -o smtp_data_done_timeout=1200
            -o smtp_send_xforward_command=yes
    
    127.0.0.1:10025 inet n - - - - smtpd
            -o content_filter=
            -o local_recipient_maps=
            -o relay_recipient_maps=
            -o smtpd_restriction_classes=
            -o smtpd_client_restrictions=
            -o smtpd_helo_restrictions=
            -o smtpd_sender_restrictions=
            -o smtpd_recipient_restrictions=permit_mynetworks,reject
            -o mynetworks=127.0.0.0/8
            -o strict_rfc821_envelopes=yes
            -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
            -o smtpd_bind_address=127.0.0.1
    
    looks like chinese to me :(, thank you for helping, :)

    EDIT: Just giving a try, isn't it because it's written 127.0.0.1, instead of localhost? i read somewhere that it coul'd be a pb :s
     
  13. falko

    falko Super Moderator

    Your master.cf looks ok, Postfix isn't running chrooted.

    Where is 127.0.0.1 used?
     
  14. lezelf

    lezelf New Member

    at the end:
    Code:
    mynetworks=127.0.0.0/8
    it's about smtp config.
    i just read smth on the web that it might be a problem.

    But you know better on the subject. any idee where it could come from?

    Thank for your help anyway.
     
  15. lezelf

    lezelf New Member

    If you or someone have an idea, it would be great!!. It's a production server and this issue is costing us alot :(.

    Any help will be much appreciated.

    EDIT:
    When i check this table, it's empty. Is it supposed to?
     
    Last edited: Aug 8, 2011
  16. falko

    falko Super Moderator

    Are the MySQL details in /etc/postfix/mysql-virtual_relaydomains.cf correct? Can you connect to MySQL on the command line if you use these details?
     

Share This Page