Missing emails

Discussion in 'General' started by HenrysCat, Dec 4, 2019.

  1. HenrysCat

    HenrysCat Member

    I am not receiving emails from aliexpress.com, I have looked in the log and found this,
    Code:
    Dec  2 08:49:15 mail postfix/smtpd[8804]: connect from out171-165.dm.aliyun.com[106.11.171.165]
    Dec  2 08:49:16 mail postfix/smtpd[8804]: NOQUEUE: filter: RCPT from out171-165.dm.aliyun.com[106.11.171.165]: <[email protected]>: Sender address triggers FILTER amavis:[127.0.0.1]:10026; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<out171-165.dm.aliyun.com>
    Dec  2 08:49:16 mail postfix/smtpd[8804]: NOQUEUE: filter: RCPT from out171-165.dm.aliyun.com[106.11.171.165]: <[email protected]>: Sender address triggers FILTER amavis:[127.0.0.1]:10024; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<out171-165.dm.aliyun.com>
    Dec  2 08:49:16 mail postfix/smtpd[8804]: 7CCEF1476BF: client=out171-165.dm.aliyun.com[106.11.171.165]
    Dec  2 08:49:16 mail postfix/cleanup[8880]: 7CCEF1476BF: message-id=56c5f89480084990b9c8b6b0ce2cc1b7
    Dec  2 08:49:16 mail postfix/qmgr[12499]: 7CCEF1476BF: from=<[email protected]>, size=12454, nrcpt=1 (queue active)
    Dec  2 08:49:17 mail postfix/smtpd[8804]: disconnect from out171-165.dm.aliyun.com[106.11.171.165] ehlo=1 mail=1 rcpt=1 data=1 quit=1 commands=5
    Dec  2 08:49:17 mail amavis[23034]: (23034-10) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 110) line 173.
    Dec  2 08:49:20 mail postfix/smtpd[8885]: connect from localhost.localdomain[127.0.0.1]
    Dec  2 08:49:20 mail postfix/smtpd[8885]: 758591476C0: client=localhost.localdomain[127.0.0.1]
    Dec  2 08:49:20 mail postfix/cleanup[8880]: 758591476C0: message-id=56c5f89480084990b9c8b6b0ce2cc1b7
    Dec  2 08:49:20 mail postfix/qmgr[12499]: 758591476C0: from=<[email protected]>, size=12901, nrcpt=1 (queue active)
    Dec  2 08:49:20 mail postfix/smtpd[8885]: disconnect from localhost.localdomain[127.0.0.1] ehlo=1 mail=1 rcpt=1 data=1 quit=1 commands=5
    Dec  2 08:49:20 mail amavis[23034]: (23034-10) Passed CLEAN {RelayedOpenRelay}, [106.11.171.165]:52517 [106.11.171.165] <[email protected]> -> <[email protected]>, Queue-ID: 7CCEF1476BF, Message-ID: <56c5f89480084990b9c8b6b0ce2cc1b7>, mail_id: ioQ10EBsnwRt, Hits: 3.554, size: 12452, queued_as: 758591476C0, dkim_sd=s1024:aliexpress.com, 3455 ms
    Dec  2 08:49:20 mail postfix/smtp[8881]: 7CCEF1476BF: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=4.5, delays=0.95/0.02/0.36/3.2, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 758591476C0)
    Dec  2 08:49:20 mail postfix/qmgr[12499]: 7CCEF1476BF: removed
    Dec  2 08:49:20 mail dovecot: lda([email protected])<8887><0wTCJBDQ5F23IgAAGzfytg>: sieve: msgid=56c5f89480084990b9c8b6b0ce2cc1b7: stored mail into mailbox 'INBOX'
    Dec  2 08:49:20 mail postfix/pipe[8886]: 758591476C0: to=<[email protected]>, relay=dovecot, delay=0.15, delays=0.01/0.03/0/0.11, dsn=2.0.0, status=sent (delivered via dovecot service)
    Dec  2 08:49:20 mail postfix/qmgr[12499]: 758591476C0: removed
    "Sender address triggers FILTER amavis:" is this it? where do the emails go?
    For the mailbox Spam filter is not enabled, under email > user/domain > Spamfilter users policy is Normal.
     
  2. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    Your mysql server seems to have crashed.
     
  3. HenrysCat

    HenrysCat Member

    Would that not affect other sites on the same server that rely on MySQL ?
     
  4. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    yes, if you have websites which use mysql on the same server as those email logs are from and mysql is down, they would be affected, too. As your question somewhat implies that's not what's happening, I re-read the logs on a computer rather than a phone - lets try again. :)

    Indeed the mysql message is just a reconnect notice, and the message proceeds to deliver.

    That says it delivered to the INBOX. So /var/vmail/{domain}/{user}/Maildir/cur/ (or .../new/ if it hasn't been read by any mail clients, which is not likely at this point).
     
  5. HenrysCat

    HenrysCat Member

    Strange they are just not in the inbox, could they be getting rejected by the Real-time Blackhole List? I can't seem to find a log for that.
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    The log you posted shows the mails are delivered, so they should be in that mailbox. Or the mailbox forwards them somewhere else, it may be in this case no copy is left in the mailbox. The Real-time Blackhole list is used before the delivery, so if the mail is delivered it has passed the RBL test.
     
  7. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    possible corrupt dovecot index?
    ssh to the server hosting the mailbox and look in /var/vmail/<domain>/<mailbox>/Maildir/new (or cur) and see if the actual email
    file is there.
     
  8. HenrysCat

    HenrysCat Member

    New is empty, cur is full of messages all looking like below and yes the email is there, strange it never appeared in the inbox.
    1575276560.M616650P8887.mail,S=12775,W=12982:2,S
    I have changed the policy setting for the mail domain under Spamfilter Users to "Wants all spam" let's see how that goes, I have 3 RBL lists hopefully they will keep the junk out.
    Just gotta wait until Aliexpress sends another email now.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    This is not related to spam filtering, so changing policies or rbl's will have no effect. Emails are in cur instead of new when an email client has marked the messages as read. Maybe you access the same inbix with multiple mail clients?
     
  10. HenrysCat

    HenrysCat Member

    I do have outlook on a desktop also, but that is set not delete unless deleted from outlook. Trying to think of way to force Aliexpress to send me an email, might have to buy something cheap :)
    It's obviously working I am getting loads of mail and no spam.
     
  11. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    As others have mentioned, it's likely just what one of your mail clients is doing that causes you to not see the message (close examination of mail log will show which clients connect, etc.), but as @nhybgtvfr implied, try running `doveadm index -u [email protected] INBOX`, it won't hurt anything.

    Also I find logging in with the local roundcube to be a pretty reliable way to check for mail when mail client settings/behavior is in question.
     

Share This Page