Mail errors after mysql/db issues

Discussion in 'General' started by ikrudolf, Aug 29, 2015.

  1. ikrudolf

    ikrudolf Member

    I have a lot of errors and mail is not arriving.

    Aug 29 08:14:33 h2 postfix/smtpd[12199]: NOQUEUE: reject: RCPT from mx68130.sh03.musvc.com[93.174.68.130]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mx68130.sh03.musvc.com>
    Aug 29 08:14:33 h2 postfix/smtpd[12199]: disconnect from mx68130.sh03.musvc.com[93.174.68.130]
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:33 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:33 h2 postfix/smtpd[12231]: NOQUEUE: reject: RCPT from mx68131.sh03.musvc.com[93.174.68.131]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mx68131.sh03.musvc.com>
    Aug 29 08:14:33 h2 postfix/smtpd[12231]: disconnect from mx68131.sh03.musvc.com[93.174.68.131]
    Aug 29 08:14:35 h2 postfix/smtpd[11734]: connect from mx68132.sh03.musvc.com[93.174.68.132]
    Aug 29 08:14:35 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:35 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:35 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:35 h2 postfix/smtpd[11734]: NOQUEUE: reject: RCPT from mx68132.sh03.musvc.com[93.174.68.132]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mx68132.sh03.musvc.com>
    Aug 29 08:14:35 h2 postfix/smtpd[11734]: disconnect from mx68132.sh03.musvc.com[93.174.68.132]
    Aug 29 08:14:39 h2 postfix/smtpd[12199]: connect from mailout.eni.com[151.96.2.127]
    Aug 29 08:14:39 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:39 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:39 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:39 h2 postfix/smtpd[12199]: NOQUEUE: reject: RCPT from mailout.eni.com[151.96.2.127]: 451 4.3.0 <dianne_matthewsskoena.nl>: Temporary lookup failure; from=<> to=<[email protected]> proto=ESMTP helo=<mailout.eni.com>
    Aug 29 08:14:39 h2 postfix/smtpd[12199]: disconnect from mailout.eni.com[151.96.2.127]
    Aug 29 08:14:40 h2 postfix/smtpd[12231]: connect from mx67202.jobrapidoalert.com[93.174.67.202]
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:40 h2 postfix/smtpd[12231]: NOQUEUE: reject: RCPT from mx67202.jobrapidoalert.com[93.174.67.202]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mx67202.jobrapidoalert.com>
    Aug 29 08:14:40 h2 postfix/smtpd[12231]: disconnect from mx67202.jobrapidoalert.com[93.174.67.202]
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "mike-oq6_2nbq=[email protected]"
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:40 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:40 h2 postfix/smtpd[12179]: NOQUEUE: reject: RCPT from dj-133.qdjiajiao.com[190.211.146.133]: 451 4.3.0 <mike-oq6_2nbq=[email protected]>: Temporary lookup failure; from=<mike-oq6_2nbq=[email protected]> to=<[email protected]> proto=ESMTP helo=<dj-133.qdjiajiao.com>
    Aug 29 08:14:42 h2 postfix/smtpd[11734]: connect from mta5093.outspot.be[178.208.55.93]
    Aug 29 08:14:42 h2 postfix/smtpd[11734]: NOQUEUE: reject: RCPT from mta5093.outspot.be[178.208.55.93]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mta5093.outspot.be>
    Aug 29 08:14:42 h2 postfix/smtpd[11734]: disconnect from mta5093.outspot.be[178.208.55.93]
    Aug 29 08:14:43 h2 postfix/smtpd[12199]: connect from mail.embaixadadobrasil.pt[62.28.245.142]
    Aug 29 08:14:44 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:44 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:44 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:44 h2 postfix/smtpd[12199]: NOQUEUE: reject: RCPT from mail.embaixadadobrasil.pt[62.28.245.142]: 451 4.3.0 <Lucia.Arrudaembaixadadobrasil.pt>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mail.embaixadadobrasil.pt>
    Aug 29 08:14:44 h2 postfix/smtpd[12199]: disconnect from mail.embaixadadobrasil.pt[62.28.245.142]
    Aug 29 08:14:45 h2 postfix/smtpd[12231]: connect from lb1.huisvandesport.nl[62.177.173.226]
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman is unavailable. open database /var/lib/mailman/data/transport-mailman.db: Invalid argument
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: hash:/var/lib/mailman/data/transport-mailman lookup error for "[email protected]"
    Aug 29 08:14:45 h2 postfix/trivial-rewrite[11974]: warning: transport_maps lookup failure
    Aug 29 08:14:45 h2 postfix/smtpd[12231]: NOQUEUE: reject: RCPT from lb1.huisvandesport.nl[62.177.173.226]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<lb1.huisvandesport.nl>
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    run:

    touch /var/lib/mailman/data/transport-mailman
    postmap /var/lib/mailman/data/transport-mailman
    service postfix restart
     
  3. ikrudolf

    ikrudolf Member

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    It worked when you did not receive an error.

    "Temporary lookup failure" means that the domain mydomain.com could not be resolved in DNS.
     
  5. ikrudolf

    ikrudolf Member

    I get different errors in the mail error log. What do they mean and what would the solution be?

    Aug 30 20:04:29 h2408438 postfix/smtpd[13357]: NOQUEUE: reject: RCPT from mail2.ontopcorp.com[72.44.213.235]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<> to=<[email protected]> proto=ESMTP helo=<mail.ontopcorp.com>
    Aug 30 20:04:29 h2408438 postfix/smtpd[13676]: disconnect from s184302.nfrance.com[80.247.239.216]
    Aug 30 20:04:29 h2408438 postfix/smtpd[13357]: disconnect from mail2.ontopcorp.com[72.44.213.235]
    Aug 30 20:04:33 h2408438 postfix/smtpd[13675]: connect from mail.intralotnetherlands.nl[62.21.128.198]
    Aug 30 20:04:33 h2408438 postfix/smtpd[13675]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:33 h2408438 postfix/smtpd[13675]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:33 h2408438 postfix/smtpd[13675]: NOQUEUE: reject: RCPT from mail.intralotnetherlands.nl[62.21.128.198]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mail.intralotnetherlands.nl>
    Aug 30 20:04:33 h2408438 postfix/smtpd[13675]: disconnect from mail.intralotnetherlands.nl[62.21.128.198]
    Aug 30 20:04:35 h2408438 postfix/smtpd[13676]: connect from mail.intralotnetherlands.nl[62.21.128.198]
    Aug 30 20:04:35 h2408438 postfix/smtpd[13676]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:35 h2408438 postfix/smtpd[13676]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:35 h2408438 postfix/smtpd[13676]: NOQUEUE: reject: RCPT from mail.intralotnetherlands.nl[62.21.128.198]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mail.intralotnetherlands.nl>
    Aug 30 20:04:35 h2408438 postfix/smtpd[13676]: disconnect from mail.intralotnetherlands.nl[62.21.128.198]
    Aug 30 20:04:39 h2408438 dovecot: pop3-login: Login: user=<[email protected]>, method=PLAIN, rip=188.81.3.145, lip=81.169.203.43, mpid=13800, TLS, session=<OOiOJoseiQC8UQOR>
    Aug 30 20:04:39 h2408438 dovecot: pop3-login: Login: user=<[email protected]>, method=PLAIN, rip=188.81.3.145, lip=81.169.203.43, mpid=13801, TLS, session=</vKOJoseugC8UQOR>
    Aug 30 20:04:39 h2408438 dovecot: pop3-login: Login: user=<[email protected]>, method=PLAIN, rip=188.81.3.145, lip=81.169.203.43, mpid=13802, TLS, session=<XP+OJoseXAC8UQOR>
    Aug 30 20:04:39 h2408438 dovecot: pop3-login: Login: user=<[email protected]>, method=PLAIN, rip=188.81.3.145, lip=81.169.203.43, mpid=13803, TLS, session=<XgWPJoseyAC8UQOR>
    Aug 30 20:04:39 h2408438 dovecot: pop3([email protected]): Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0
    Aug 30 20:04:40 h2408438 dovecot: pop3([email protected]): Disconnected: Logged out top=0/0, retr=0/0, del=0/496, size=17582041
    Aug 30 20:04:40 h2408438 dovecot: pop3([email protected]): Disconnected: Logged out top=0/0, retr=0/0, del=0/11, size=1829423
    Aug 30 20:04:40 h2408438 dovecot: pop3([email protected]): Disconnected: Logged out top=0/0, retr=0/0, del=0/22, size=16571984
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: connect from scandium-onsiei.emv8.com[81.92.117.168]
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: NOQUEUE: reject: RCPT from scandium-onsiei.emv8.com[81.92.117.168]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<scandium-onsiei.emv8.com>
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: NOQUEUE: reject: RCPT from scandium-onsiei.emv8.com[81.92.117.168]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<scandium-onsiei.emv8.com>
    Aug 30 20:04:40 h2408438 postfix/smtpd[13357]: disconnect from scandium-onsiei.emv8.com[81.92.117.168]
    Aug 30 20:04:43 h2408438 postfix/smtpd[13675]: connect from 66-220-144-148.outmail.facebook.com[66.220.144.148]
    Aug 30 20:04:45 h2408438 postfix/smtpd[13675]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:45 h2408438 postfix/smtpd[13675]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:45 h2408438 postfix/smtpd[13675]: NOQUEUE: reject: RCPT from 66-220-144-148.outmail.facebook.com[66.220.144.148]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mx-out.facebook.com>
    Aug 30 20:04:47 h2408438 postfix/smtpd[13676]: connect from snt004-omc3s1.hotmail.com[65.55.90.140]
    Aug 30 20:04:48 h2408438 postfix/smtpd[13676]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:48 h2408438 postfix/smtpd[13676]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:48 h2408438 postfix/smtpd[13676]: NOQUEUE: reject: RCPT from snt004-omc3s1.hotmail.com[65.55.90.140]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<SNT004-OMC3S1.hotmail.com>
    Aug 30 20:04:49 h2408438 postfix/smtpd[13676]: disconnect from snt004-omc3s1.hotmail.com[65.55.90.140]
    Aug 30 20:04:50 h2408438 postfix/smtpd[13358]: disconnect from mxslcpool84.ebay.com[66.135.215.187]
    Aug 30 20:04:50 h2408438 postfix/smtpd[13675]: disconnect from 66-220-144-148.outmail.facebook.com[66.220.144.148]
    Aug 30 20:04:58 h2408438 postfix/smtpd[13357]: connect from mta3.mail.wehkamp.nl[198.245.86.3]
    Aug 30 20:04:59 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman is unavailable. open database /var/lib/mailman/data/virtual-mailman.db: Invalid argument
    Aug 30 20:04:59 h2408438 postfix/smtpd[13357]: warning: hash:/var/lib/mailman/data/virtual-mailman lookup error for "[email protected]"
    Aug 30 20:04:59 h2408438 postfix/smtpd[13357]: NOQUEUE: reject: RCPT from mta3.mail.wehkamp.nl[198.245.86.3]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<mta3.mail.wehkamp.nl>
    Aug 30 20:04:59 h2408438 postfix/smtpd[13357]: disconnect from mta3.mail.wehkamp.nl[198.245.86.3]
     
  6. ikrudolf

    ikrudolf Member

    The only thing that is done is a restore of the VM a few days ago. Since than the mail server is nof functioning anymore. No config file was changed or whatever.

    Btw this doesn't solve the issues:
    touch /var/lib/mailman/data/transport-mailman
    postmap /var/lib/mailman/data/transport-mailman
    service postfix restart
     
    Last edited: Aug 31, 2015
  7. ikrudolf

    ikrudolf Member

    I saw this in /var/log/mysql/error.log
    150831 9:50:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    For some reason, not clear for me, bind-address = 127.0.0.1 was deleted from etc/mysql/my.cnf

    When I netstat -tap | grep mysql I get:
    tcp 0 0 localhost:mysql *:* LISTEN 14480/mysqld
    tcp 0 0 localhost:60497 localhost:mysql ESTABLISHED 14105/smtpd
    tcp 0 0 localhost:mysql localhost:60498 ESTABLISHED 14480/mysqld
    tcp 0 0 localhost:60565 localhost:mysql ESTABLISHED 14135/smtpd
    tcp 0 0 localhost:mysql localhost:60502 ESTABLISHED 14480/mysqld
    tcp 0 0 localhost:mysql localhost:60565 ESTABLISHED 14480/mysqld
    tcp 0 0 web01.server.nl:54626 D57E7C3A.static.z:mysql TIME_WAIT -
    tcp 0 0 localhost:60500 localhost:mysql ESTABLISHED 13856/smtpd
    tcp 0 0 localhost:60496 localhost:mysql ESTABLISHED 14105/smtpd
    tcp 0 0 localhost:mysql localhost:60496 ESTABLISHED 14480/mysqld
    tcp 0 0 localhost:60564 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:60498 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:mysql localhost:60566 ESTABLISHED
    tcp 0 0 localhost:60423 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:mysql localhost:60564 ESTABLISHED
    tcp 0 0 localhost:mysql localhost:60500 ESTABLISHED
    tcp 0 0 localhost:60424 localhost:mysql ESTABLISHED
    tcp 0 0 web01.server.nl:54826 D57E7.static:mysql TIME_WAIT
    tcp 1 0 localhost:57013 localhost:mysql CLOSE_WAIT
    tcp 1 0 localhost:54448 localhost:mysql CLOSE_WAIT
    tcp 0 0 localhost:mysql localhost:60501 ESTABLISHED
    tcp 0 0 localhost:60501 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:60566 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:60502 localhost:mysql ESTABLISHED
    tcp 1 0 localhost:43199 localhost:mysql CLOSE_WAIT
    tcp 0 0 localhost:mysql localhost:60423 ESTABLISHED
    tcp 0 0 localhost:mysql localhost:60497 ESTABLISHED
    tcp 0 0 web01.skoena.nl:55444 D57E7.static:mysql TIME_WAIT
    tcp 0 0 web01.skoena.nl:54357 D57E7.static:mysql TIME_WAIT
    tcp 1 0 localhost:57012 localhost:mysql CLOSE_WAIT
    tcp 0 0 localhost:mysql localhost:60424 ESTABLISHED
    tcp 0 0 localhost:60425 localhost:mysql ESTABLISHED
    tcp 0 0 localhost:mysql localhost:60425 ESTABLISHED
    Is this correct?
     

Share This Page