Cant send email, wrong IPs for amavis and postfix?

Discussion in 'Installation/Configuration' started by andreasnrb, Mar 22, 2010.

  1. andreasnrb

    andreasnrb New Member

    Apparantly when installing ISPConfig it assumes my external IP to be used for a bunch of services. In this case Amavis and Postfix.
    How can I get it to connect with MySQL?
    For Postfix I know I can alter 20 postfix mysql.cf files but it feels wrong. Its the same stuff in all those files anyway. When I change host ip in all those files still the amavis error occurs and I get new ones about cant send data.
    I have no clue where the amavis conf files is reciding.

    I also havent messed with anything it was this way from the start after installing ISPConfig 3 =).

    maillog
    Code:
    Mar 22 17:19:29 arty postfix/pickup[7824]: 41E772A0878B: uid=5005 from=<web3>
    Mar 22 17:19:29 arty postfix/proxymap[11922]: warning: connect to mysql server 79.99.2.34: Can't connect to MySQL server on '79.*.2.*' (111)
    Mar 22 17:19:29 arty postfix/cleanup[11921]: 41E772A0878B: message-id=<73897138f4a27e7d6fa3d9d44b8920e8@mysite.com>
    Mar 22 17:19:29 arty postfix/qmgr[7823]: 41E772A0878B: from=<web3@arty.example.se>, size=841, nrcpt=1 (queue active)
    Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=79.*.2.*;port=3306': Can't connect to MySQL server on '79.*.2.*' (111)
    Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 244, <GEN24> line 3.
    Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!)Requesting process rundown after fatal error
    Mar 22 17:19:29 arty postfix/smtp[11924]: 41E772A0878B: to=<myemail@gmail.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.24, delays=0.03/0/0.01/0.2, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command))
    Mar 22 17:19:29 arty postfix/smtp[11924]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111)
    Mar 22 17:19:29 arty postfix/smtp[11924]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Mar 22 17:19:30 arty postfix/qmgr[7823]: warning: private/amavis socket: malformed response
    Mar 22 17:19:30 arty postfix/qmgr[7823]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
    Mar 22 17:19:30 arty postfix/master[7822]: warning: process /usr/lib/postfix/smtp pid 11924 exit status 1
    Mar 22 17:19:30 arty postfix/master[7822]: warning: /usr/lib/postfix/smtp: bad command startup -- throttling
    Mar 22 17:19:30 arty postfix/error[11930]: 41E772A0878B: to=<myemail@gmail.com>, relay=none, delay=1.3, delays=0.03/1.2/0/0.01, dsn=4.3.0, status=deferred (unknown mail transport error)
    Mar 22 17:19:30 arty postfix/error[11930]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111)
    Mar 22 17:19:30 arty postfix/error[11930]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: private/retry socket: malformed response
    Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
    Mar 22 17:19:31 arty postfix/master[7822]: warning: process /usr/lib/postfix/error pid 11930 exit status 1
    Mar 22 17:19:31 arty postfix/master[7822]: warning: /usr/lib/postfix/error: bad command startup -- throttling
    Mar 22 17:19:31 arty postfix/qmgr[7823]: 41E772A0878B: to=<myemail@gmail.com>, relay=none, delay=2.3, delays=0.03/2.2/0/0, dsn=4.3.0, status=deferred (unknown mail transport error)
    Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111)
    Mar 22 17:19:31 arty postfix/qmgr[7823]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Mar 22 17:19:32 arty postfix/master[7822]: warning: process /usr/lib/postfix/qmgr pid 7823 exit status 1
    
    netstat -tap
    Code:
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 127.0.0.1:10025         *:*                     LISTEN      7822/master     
    tcp        0      0 127.0.0.1:mysql         *:*                     LISTEN      7681/mysqld     
    tcp        0      0 127.0.0.1:spamd         *:*                     LISTEN      3611/spamd.pid  
    tcp        0      0 *:webcache              *:*                     LISTEN      9969/apache2    
    tcp        0      0 *:www                   *:*                     LISTEN      9969/apache2    
    tcp        0      0 *:tproxy                *:*                     LISTEN      9969/apache2    
    tcp        0      0 *:ftp                   *:*                     LISTEN      10017/pure-ftpd (SE
    tcp        0      0 *:smtp                  *:*                     LISTEN      7822/master     
    tcp        0      0 *:https                 *:*                     LISTEN      9969/apache2    
    tcp        0      0 127.0.0.1:10024         *:*                     LISTEN      7887/amavisd (maste
    tcp        0      0 arty.example:44051 arty.example.s:www TIME_WAIT   -               
    tcp        0      0 arty.example.s:ftp arty.example:50359 TIME_WAIT   -               
    tcp6       0      0 [::]:pop3               [::]:*                  LISTEN      9866/couriertcpd
    tcp6       0      0 [::]:imap2              [::]:*                  LISTEN      9756/couriertcpd
    tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      10017/pure-ftpd (SE
    tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      3393/sshd       
    tcp6       0      0 [::]:imaps              [::]:*                  LISTEN      9849/couriertcpd
    tcp6       0      0 [::]:pop3s              [::]:*                  LISTEN      9891/couriertcpd
    tcp6       0   1968 arty.example.s:ssh h86n2c1o1100.bred:56059 ESTABLISHED 32461/1         
    
    postconf -n
    Code:
    alias_database = hash:/etc/aliases
    alias_maps = hash:/etc/aliases
    append_dot_mydomain = no
    biff = no
    body_checks = regexp:/etc/postfix/body_checks
    broken_sasl_auth_clients = yes
    config_directory = /etc/postfix
    content_filter = amavis:[127.0.0.1]:10024
    header_checks = regexp:/etc/postfix/header_checks
    html_directory = /usr/share/doc/postfix/html
    inet_interfaces = all
    mailbox_size_limit = 0
    message_size_limit = 0
    mime_header_checks = regexp:/etc/postfix/mime_header_checks
    mydestination = arty.example.se, localhost, localhost.localdomain
    myhostname = arty.example.se
    mynetworks = 127.0.0.0/8 [::1]/128
    myorigin = /etc/mailname
    nested_header_checks = regexp:/etc/postfix/nested_header_checks
    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
    readme_directory = /usr/share/doc/postfix
    receive_override_options = no_address_mappings
    recipient_delimiter = +
    relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
    relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
    relayhost = 
    smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
    smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
    smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf
    smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
    smtpd_sasl_auth_enable = yes
    smtpd_sasl_authenticated_header = yes
    smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
    smtpd_tls_cert_file = /etc/postfix/smtpd.cert
    smtpd_tls_key_file = /etc/postfix/smtpd.key
    smtpd_tls_security_level = may
    smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
    smtpd_use_tls = yes
    transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
    virtual_alias_domains = 
    virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
    virtual_gid_maps = static:5000
    virtual_mailbox_base = /var/vmail
    virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
    virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
    virtual_transport = maildrop
    virtual_uid_maps = static:5000
    
     
    Last edited: Mar 22, 2010
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Firstm check your /etc/hosts file and make sure that the IP 127.0.0.1 is set to resolve to localhost and that no other Ip resolves to localhost.

    Then uninstall ispconfig by using the uninstall.php script which is in the same folder then the install.php script in the ispconfig tar.gz file. Then install ispconfig again and make sure that you enter "localhost" when the installer asks for the mysql hostname.
     
  3. andreasnrb

    andreasnrb New Member

    The /etc/hosts file is autogenerated by the VPS hotell. It is reseted whenever the VPS is rebooted.
    Its default is
    myip servername etc
    79.*.2.* arty localhost localhost.localdomain
    I've altered it because hostname was always arty otherwise, no FQDM
    79.*.2.* arty.mydomain.com arty localhost localhost.localdomain

    How would the hosts file be constructed then given the default values?

    Also don't remember writing anything when it asked for mysql server. I think the default said localhost though.
     
    Last edited: Mar 22, 2010
  4. andreasnrb

    andreasnrb New Member

    Ok everything works fine now.
    Had one error left about the system couldnt send DATA which apparantly was due to low amount of free RAM but that was easy to fix.

    Thx for the help Till.
     

Share This Page