incoming mail sits in queue after running ispconfig_update.sh

Discussion in 'General' started by Greg1968, Jun 8, 2015.

  1. Greg1968

    Greg1968 New Member

    Hi
    I ran ispconfig_update.sh a day or two ago and all appeared OK but this morning it was highlighted that no email was being received, I checked the server and the mail is sat in the mailq.

    I then checked mail.log and saw the following error repeated for each incoming email:

    postfix/error[18028]: 21C6B4C082D: to=<something @ domain>, relay=none, delay=0.28, delays=0.24/0/0/0.04, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while receiving the initial server greeting)

    I restarted amavis and postfix but the error remained, i got so desperate I even rebooted the server but that made no difference what so ever.
    I then added
    debug_peer_list = 127.0.0.1
    to main.cf and restart postfix. When checking mail.log again I found the following errors

    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: 956F24C07FB: to=<user @ domain>, relay=127.0.0.1[127.0.0.1]:10024, delay=2635, delays=2635/0.12/0/0, dsn=4.4.2, status=deferred (lost connection with 127.0.0.1[127.0.0.1] while receiving the initial server greeting)
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: flush_add: site domain id 956F24C07FB
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: match_hostname: domain ~? mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix)
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql_get_active: found active connection to host 127.0.0.1
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql: successful query from host 127.0.0.1
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql_lookup: retrieved 0 rows
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: match_hostname: lookup mysql:/etc/postfix/mysql-virtual_relaydomains.cf domain.com: notfound
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql_get_active: found active connection to host 127.0.0.1
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql: successful query from host 127.0.0.1
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: dict_mysql_lookup: retrieved 0 rows
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: match_hostname: lookup mysql:/etc/postfix/mysql-virtual_relaydomains.cf com: notfound
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: match_list_match: domain: no match
    Jun 8 18:56:00 theeuropeanserver postfix/smtp[18435]: flush_add: site domain id 956F24C07FB status 4


    So I checked the mysql-virtual_relaydomains.cf and found the database information:

    user = ispconfig
    password = biglongpassword
    dbname = dbispconfig
    table = mail_transport
    select_field = domain
    where_field = domain
    additional_conditions = and active = 'y' and server_id = 1


    I logged into mysql as ispconfig and found the mail_transport table is actually empty which I am assuming is the problem.

    What has happened in the update?

    Thanks

    Greg
     
  2. Greg1968

    Greg1968 New Member

    sorry currently running ispconfig version is 3.0.5.4p8
     
  3. Greg1968

    Greg1968 New Member

    I've resolvefd the issue, turns out amavis was listening on 127.0.0.1 only, I had to add network IP addresses to the amavis configuration and email is now working as it should.
     

Share This Page