<div dir="ltr"><div>Hello</div><div><br></div><div>Currently, I am deploying amavisd with MySQL quarantine. When I try to release the email, I get error "missing X-Envelope-From or Return-Path". Oddly, when I inspect the database, the Return-Path header wasn't not found in quarantine.mail_text column.</div>
<div><br></div><div>*PS: My script to release the email was modified version of MailZu</div><div><br></div><div>*Here the version of perl and amavisd</div><div>$myversion_id = '2.8.0'; $myversion_date = '20120630';</div>
<div>This is perl 5, version 16, subversion 2 (v5.16.2) built for amd64-freebsd-thread-multi</div><div><br></div><div>a) Here log when i receive the message, The return-path should be "<a href="mailto:dummy@example.org">dummy@example.org</a>"</div>
<div><br></div><div>Dec 27 07:08:40 av1 amavis[68566]: (68566-03) Checking: eNGJpO_Wvslk [103.28.23.16] <<a href="mailto:dummy@example.org">dummy@example.org</a>> -> <<a href="mailto:root@example.com">root@example.com</a>></div>
<div>Dec 27 07:08:43 av1 amavis[68566]: (68566-03) delivering to sql:, SEND via SQL (DBI:mysql:amavis:167.205.1.68): <<a href="mailto:dummy@example.org">dummy@example.org</a>> -> <<a href="mailto:root@example.com">root@example.com</a>>, mail_id eNGJpO_Wvslk</div>
<div>Dec 27 07:08:43 av1 amavis[68566]: (68566-03) Blocked SPAM {DiscardedInbound,Quarantined}, [103.28.23.16]:34121 [103.28.23.16] <<a href="mailto:dummy@example.org">dummy@example.org</a>> -> <<a href="mailto:root@example.com">root@example.com</a>>, quarantine: eNGJpO_Wvslk, Queue-ID: 3YWrx16bgJzDFqT, Message-ID: <<a href="mailto:20121226234503.453525642A@ophrek.co.cc">20121226234503.453525642A@ophrek.co.cc</a>>, mail_id: eNGJpO_Wvslk, Hits: 8.002, size: 399, 3523 ms</div>
<div><br></div><div>b) The output from query "select mail_text from quarantine WHERE mail_id='eNGJpO_Wvslk';"</div><div><br></div><div>====================================================================================</div>
<div>X-Envelope-To: <<a href="mailto:root@example.com">root@example.com</a>></div><div>X-Envelope-To-Blocked: <<a href="mailto:root@example.com">root@example.com</a>></div><div>X-Quarantine-ID: <eNGJpO_Wvslk></div>
<div>X-Spam-Flag: YES</div><div>X-Spam-Score: 8.002</div><div>X-Spam-Level: ********</div><div>X-Spam-Status: Yes, score=8.002 tag=4 tag2=4.5 kill=5 tests=[BAYES_99=3.5,</div><div> DRUG_ED_CAPS=0.936, RDNS_NONE=0.793, SERGIO_SUBJECT_VIAGRA01=2.773]</div>
<div> autolearn=disabled</div><div>Received: from <a href="http://mx.example.com">mx.example.com</a> ([aaa.bbb.ccc.ddd])</div><div> by <a href="http://av1.example.com">av1.example.com</a> (<a href="http://av1.example.com">av1.example.com</a> [aaa.bbb.ccc.ddd]) (amavisd-new, port 9419)</div>
<div> with ESMTP id eNGJpO_Wvslk for <<a href="mailto:root@example.com">root@example.com</a>>;</div><div> Thu, 27 Dec 2012 07:08:40 +0700 (WIT)</div><div>Received: from <a href="http://example.org">example.org</a> (unknown [aaa.bbb.ccc.ddd])</div>
<div> by <a href="http://mx.example.com">mx.example.com</a> (Postfix) with SMTP id 3YWrx16bgJzDFqT</div><div> for <<a href="mailto:root@example.com">root@example.com</a>>; Thu, 27 Dec 2012 07:08:07 +0700 (WIT)</div>
<div>To: <a href="mailto:root@example.com">root@example.com</a></div><div>Subject: VIAGRAM NOT SPAM :P (test sp</div><div>Message-Id: <<a href="mailto:20121226234503.453525642A@ophrek.co.cc">20121226234503.453525642A@ophrek.co.cc</a>></div>
<div>Date: Thu, 27 Dec 2012 06:45:03 +0700 (WIT)</div><div>From: <a href="mailto:root@example.org">root@example.org</a> (Charlie Root)</div><div><br></div><div>test</div><div>=======================================================</div>
<div><br></div><div>c) When i release the message</div><div><br></div><div>Dec 27 07:10:31 av1 amavis[68559]: (rel-eNGJpO_Wvslk) Request: release eNGJpO_Wvslk /var/amavis/tmp/amavis-20121227T071031-68559-_H784jPO: -> <<a href="mailto:root@example.com">root@example.com</a>></div>
<div>Dec 27 07:10:31 av1 amavis[68559]: (rel-eNGJpO_Wvslk) Quarantined message release (miscategorized): eNGJpO_Wvslk <> -> <<a href="mailto:root@example.com">root@example.com</a>></div><div>Dec 27 07:10:31 av1 amavis[68559]: (rel-eNGJpO_Wvslk) Quarantine release eNGJpO_Wvslk: missing X-Envelope-From or Return-Path</div>
<div>Dec 27 07:10:32 av1 amavis[68559]: (rel-eNGJpO_Wvslk) FWD from <> -> <<a href="mailto:root@example.com">root@example.com</a>>, 250 2.0.0 from MTA(smtp:[167.205.1.69]:10025): 250 2.0.0 Ok: queued as 204FD62</div>
<div>Dec 27 07:10:32 av1 amavis[68559]: (rel-eNGJpO_Wvslk) size: 0, TIMING [total 281 ms] - got data: 0 (0%)0, mkdir tempdir: 2 (1%)1, fwd-connect: 15 (5%)6, fwd-mail-pip: 169 (60%)66, fwd-rcpt-pip: 0 (0%)66, fwd-data-chkpnt: 0 (0%)66, write-header: 2 (1%)67, fwd-data-contents: 0 (0%)67, fwd-end-chkpnt: 92 (33%)100, rmdir: 1 (0%)100, rundown: 0 (0%)100</div>
<div><br></div><div>I tried to google this problem and found similar problem in [1] and [2] but I couldn't find the useful information. Any suggestions?</div><div><br></div><div>Thanks :)</div><div><br></div><div>[1] <a href="http://lists.amavis.org/pipermail/amavis-users/2012-February/001188.html">http://lists.amavis.org/pipermail/amavis-users/2012-February/001188.html</a></div>
<div>[2] <a href="http://lists.amavis.org/pipermail/amavis-users/2012-May/001454.html">http://lists.amavis.org/pipermail/amavis-users/2012-May/001454.html</a></div></div>