achraf tangui,
> In the same context I tried to use amavisd-report, just to see what's the
> result, but i cant get it to work ! [...]
> 451 4.5.0 From MTA([127.0.0.1]:10025) during fwd-data-contents
> read: sql select failed, DBD::mysql::st fetchrow_arrayref failed:
> fetch() without execute()
> I googled a lot on this but found no results,
> Any ideas? what am I missing here?
You found a bug, thanks!
Here is a patch to 2.6.1 (it will be included in 2.6.2-rc2):
--- amavisd~ 2008-10-03 19:37:23.000000000 +0200
+++ amavisd 2008-12-05 18:16:07.000000000 +0100
@@ -18595,11 +18595,12 @@
or die "Seek to $whence,$pos on sql i/o only supported for read mode";
if ($pos < $self->{pos}) {
- if ($self->{chunk_ind} <= 1) { # still in the first chunk, just reset pos
- $self->{pos} = $self->{bufpos} = $self->{eof} = 0; # reset
- } else { # beyond the first chunk, restart the query from the beginning
- my($con,$clause,$key,$mode,$maxb) =
- @$self{qw(conn_h clause dbkey mode maxbuf)};
+ if (!$self->{eof} && $self->{chunk_ind} <= 1) {
+ # still in the first chunk, just reset pos
+ $self->{pos} = $self->{bufpos} = 0; # reset
+ } else { # beyond the first chunk, restart the query from the beginning
+ my($con,$clause,$key,$mode,$partition_tag,$maxb,$rx_time) =
+ @$self{qw(conn_h clause dbkey mode partition_tag maxbuf rx_time)};
$self->close or die "seek: error closing, $!";
- $self->open($con,$clause,$key,$mode,$maxb)
+ $self->open($con,$clause,$key,$mode,$partition_tag,$maxb,$rx_time)
or die "seek: reopen failed: $!";
}
> I'm running Amavisd-new 2.6.1 with Postfix
> I have amavis quarantining spam and infected mails to MYSQL DB,
> when I run amavisd-release on any of those quarantined messages, The mail
> is successfully released but when I look at the header all the information
> about spam assassin scores disapear. Eventought in the quarantine the
> mail_text field contains the whole details in the headers
>
> I think this is due to the fact that Amavis re-edits the mail
> Is there any way to release a mail and keep all the information in the
> header ?
You are right, on releasing from quarantine amavisd strips header
fields previously inserted by itself, to present a clean mail to
recipient. The main reason is that X-Spam-Status, X-Spam-Level,
X-Spam-Flag or X-Spam-Score could be acted upon by a recipient's
mailbox filtering (procmail, sieve), so indicating that a released
mail is still spam seems counterproductive for most normal cases
of releases (false positives).
This is not currently configurable, but with a simple patch
you can avoid it:
--- amavisd~ 2008-06-29 02:37:58.000000000 +0200
+++ amavisd 2008-12-05 18:36:09.000000000 +0100
@@ -7860,5 +7860,5 @@
} elsif (/^X-Quarantine-ID:[ \t]*(.*)$/si) {
$qid = $1; $qid = $1 if $qid =~ /^<(.*)>\z/s;
- } elsif (/^X-Spam-(?:Flag|Score|Level|Status|Report|Tests):/si) { # skip
+# } elsif (/^X-Spam-(?:Flag|Score|Level|Status|Report|Tests):/si) { # skip
} elsif (/^X-Amavis-Hold:/si) {
# skip (but not X-Amavis-OS-Fingerprint or Authentication-Results)
Mark
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
