At this point, my amavisd-new install (2.5.3 on Centos5) is not working
correctly. Perhaps the problem I am having is a bug, as I have a very similar
installation elsewhere that does work.
I have amavisd setup to use a Pgsql database for lookups:
@lookup_sql_dsn = ( ['DBI:Pg:dbname=postfix', 'vscan', 'XXXXX']);
I can confirm that amavisd is connecting to the DB as pgsql is logging
connections and queries for the vscan user. The issue is that amavisd is not
sending the correct query. The following is from my pgsql log:
vscan on postfix LOG: connection authorized: user=vscan database=postfix
vscan on postfix LOG: statement: PREPARE dbdpg_1 AS SELECT *, users.id FROM
users LEFT JOIN policy ON users.policy_id=policy.id WHERE users.email IN
($1,$2,$3,$4,$5) ORDER BY users.priority DESC
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT *,
users.id FROM users LEFT JOIN policy ON users.policy_id=policy.id WHERE
users.email IN ($1,$2,$3,$4,$5) ORDER BY users.priority DESC]
vscan on postfix LOG: duration: 0.224 ms
vscan on postfix LOG: statement: PREPARE dbdpg_2 AS SELECT wb FROM wblist JOIN
mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND mailaddr.email IN
($2,$3,$4,$5,$6) ORDER BY mailaddr.priority DESC
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.040 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.019 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.018 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT *,
users.id FROM users LEFT JOIN policy ON users.policy_id=policy.id WHERE
users.email IN ($1,$2,$3,$4,$5) ORDER BY users.priority DESC]
vscan on postfix LOG: duration: 0.110 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6,$7,$8) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.036 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6,$7,$8) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.019 ms
vscan on postfix LOG: statement: <BIND>
vscan on postfix LOG: statement: EXECUTE <unnamed> [PREPARE: SELECT wb FROM
wblist JOIN mailaddr ON wblist.sid=mailaddr.id WHERE wblist.rid=$1 AND
mailaddr.email IN ($2,$3,$4,$5,$6,$7,$8) ORDER BY mailaddr.priority DESC]
vscan on postfix LOG: duration: 0.018 ms
As you can see, amavisd is not replacing the variables in the query string.
They should be ('[EMAIL
PROTECTED]','user','@domain.tld','@.domain.tld','@.tld','@.')
If I manually add the appropriate values in the WHERE clause, it returns 2 rows
as I expect it to.
Below is my amavisd config:
<amavisd config>
use strict;
$max_servers = 2; # num of pre-forked children (2..15 is common), -m
$daemon_user = "amavis"; # (no default; customary: vscan or amavis), -u
$daemon_group = "amavis"; # (no default; customary: vscan or amavis), -g
$mydomain = 'marklar.6og.net'; # a convenient default for other settings
$MYHOME = '/var/amavis'; # a convenient default for other settings, -H
$TEMPBASE = "$MYHOME/tmp"; # working directory, needs to exist, -T
$ENV{TMPDIR} = $TEMPBASE; # environment variable TMPDIR, used by SA, etc.
$QUARANTINEDIR = "/var/virusmails";
$quarantine_subdir_levels = 1; # add level of subdirs to disperse quarantine
$db_home = "$MYHOME/db"; # dir for bdb nanny/cache/snmp databases, -D
$log_level = 3; # verbosity 0..5, -d
$log_recip_templ = undef; # disable by-recipient level-0 log entries
$DO_SYSLOG = 1; # log via syslogd (preferred)
$syslog_facility = 'mail'; # Syslog facility as a string
$syslog_priority = 'debug'; # Syslog base (minimal) priority as a string,
$enable_db = 1; # enable use of BerkeleyDB/libdb (SNMP and nanny)
$enable_global_cache = 1; # enable use of libdb-based cache if $enable_db=1
$nanny_details_level = 2; # nanny verbosity: 1: traditional, 2: detailed
@mynetworks = qw( 127.0.0.0/8 [::1] [FE80::]/10 [FEC0::]/10
10.0.0.0/8 172.16.0.0/12 192.168.0.0/16 );
# option(s) -p overrides $inet_socket_port and $unix_socketname
$inet_socket_port = 10024; # listen on this local TCP port(s)
$policy_bank{'MYNETS'} = { # mail originating from @mynetworks
originating => 1, # is true in MYNETS by default, but let's make it explicit
os_fingerprint_method => undef, # don't query p0f for internal clients
};
$sa_tag_level_deflt = -50; # add spam info headers if at, or above that level
$sa_tag2_level_deflt = 4; # add 'spam detected' headers at that level
$sa_kill_level_deflt = 99; # triggers spam evasive actions (e.g. blocks mail)
$penpals_bonus_score = 8; # (no effect without a @storage_sql_dsn database)
$penpals_threshold_high = $sa_kill_level_deflt; # don't waste time on hi spam
$sa_mail_body_size_limit = 400*1024; # don't waste time on SA if mail is larger
$sa_local_tests_only = 0; # only tests which do not require internet access?
@lookup_sql_dsn = ( ['DBI:Pg:dbname=postfix', 'vscan', 'XXXXXXXXXXX']);
$recipient_delimiter = '-'; # undef disables address extensions altogether
$path = '/usr/local/sbin:/usr/local/bin:/usr/sbin:/sbin:/usr/bin:/bin';
$dspam = 'dspam';
$MAXLEVELS = 14;
$MAXFILES = 1500;
$MIN_EXPANSION_QUOTA = 100*1024; # bytes (default undef, not enforced)
$MAX_EXPANSION_QUOTA = 300*1024*1024; # bytes (default undef, not enforced)
$sa_spam_subject_tag = '***SPAM*** ';
$defang_virus = 1; # MIME-wrap passed infected mail
$defang_banned = 1; # MIME-wrap passed mail containing banned name
$defang_by_ccat{+CC_BADH.",3"} = 1; # NUL or CR character in header
$defang_by_ccat{+CC_BADH.",5"} = 1; # header line longer than 998 characters
$defang_by_ccat{+CC_BADH.",6"} = 1; # header field syntax error
$forward_method = 'smtp:[127.0.0.1]:10025'; # set to undef with milter!
$notify_method = $forward_method;
$final_virus_destiny = D_DISCARD;
$final_banned_destiny = D_BOUNCE;
$final_spam_destiny = D_PASS;
$final_bad_header_destiny = D_PASS;
@keep_decoded_original_maps = (new_RE(
qr'^MAIL-UNDECIPHERABLE$', # recheck full mail if it contains undecipherables
qr'^(ASCII(?! cpio)|text|uuencoded|xxencoded|binhex)'i,
));
$banned_filename_re = new_RE(
qr'^\.(exe-ms|dll)$', # banned file(1) types, rudimentary
[ qr'^\.(rpm|cpio|tar)$' => 0 ], # allow any in Unix-type archives
qr'.\.(pif|scr)$'i, # banned extensions - rudimentary
qr'^application/x-msdownload$'i, # block these MIME types
qr'^application/x-msdos-program$'i,
qr'^application/hta$'i,
qr'\.[^./]*[A-Za-z][^./]*\.\s*(exe|vbs|pif|scr|bat|cmd|com|cpl|dll)[.\s]*$'i,
qr'.\.(exe|vbs|pif|scr|cpl)$'i, # banned extension - basic
);
@score_sender_maps = ({
'.' => [ # the _first_ matching sender determines the score boost
new_RE( # regexp-type lookup table, just happens to be all soft-blacklist
[qr'^(bulkmail|offers|cheapbenefits|earnmoney|foryou)@'i => 5.0],
[qr'^(greatcasino|investments|lose_weight_today|market\.alert)@'i=> 5.0],
[qr'^(money2you|MyGreenCard|new\.tld\.registry|opt-out|opt-in)@'i=> 5.0],
[qr'^(optin|saveonlsmoking2002k|specialoffer|specialoffers)@'i => 5.0],
[qr'^(stockalert|stopsnoring|wantsome|workathome|yesitsfree)@'i => 5.0],
[qr'^(your_friend|greatoffers)@'i => 5.0],
[qr'^(inkjetplanet|marketopt|MakeMoney)\d*@'i => 5.0],
),
{ # a hash-type lookup table (associative array)
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'securityfocus.com' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]'=> -3.0,
'[EMAIL PROTECTED]' => -3.0,
'spamassassin.apache.org' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
'[EMAIL PROTECTED]' => -5.0,
'[EMAIL PROTECTED]' => -3.0,
'returns.groups.yahoo.com' => -3.0,
'[EMAIL PROTECTED]' => -3.0,
lc('[EMAIL PROTECTED]') => -3.0,
lc('[EMAIL PROTECTED]') => -5.0,
'[EMAIL PROTECTED]' => 3.0,
'.example.net' => 1.0,
},
], # end of site-wide tables
});
@decoders = (
['mail', \&do_mime_decode],
['asc', \&do_ascii],
['uue', \&do_ascii],
['hqx', \&do_ascii],
['ync', \&do_ascii],
['F', \&do_uncompress, ['unfreeze','freeze -d','melt','fcat'] ],
['Z', \&do_uncompress, ['uncompress','gzip -d','zcat'] ],
['gz', \&do_uncompress, 'gzip -d'],
['gz', \&do_gunzip],
['bz2', \&do_uncompress, 'bzip2 -d'],
['lzo', \&do_uncompress, 'lzop -d'],
['rpm', \&do_uncompress, ['rpm2cpio.pl','rpm2cpio'] ],
['cpio', \&do_pax_cpio, ['pax','gcpio','cpio'] ],
['tar', \&do_pax_cpio, ['pax','gcpio','cpio'] ],
['deb', \&do_ar, 'ar'],
['zip', \&do_unzip],
['7z', \&do_7zip, ['7zr','7za','7z'] ],
['rar', \&do_unrar, ['rar','unrar'] ],
['arj', \&do_unarj, ['arj','unarj'] ],
['arc', \&do_arc, ['nomarch','arc'] ],
['zoo', \&do_zoo, ['zoo','unzoo'] ],
['lha', \&do_lha, 'lha'],
['cab', \&do_cabextract, 'cabextract'],
['tnef', \&do_tnef_ext, 'tnef'],
['tnef', \&do_tnef],
['exe', \&do_executable, ['rar','unrar'], 'lha', ['arj','unarj'] ],
);
@av_scanners = (
['ClamAV-clamd',
\&ask_daemon, ["CONTSCAN {}\n", "/var/run/clamav/clamd.sock"],
qr/\bOK$/, qr/\bFOUND$/,
qr/^.*?: (?!Infected Archive)(.*) FOUND$/ ],
);
@av_scanners_backup = (
['ClamAV-clamscan', 'clamscan',
"--stdout --no-summary -r --tempdir=$TEMPBASE {}",
[0], qr/:.*\sFOUND$/, qr/^.*?: (?!Infected Archive)(.*) FOUND$/ ],
);
1; # insure a defined return
</amavisd config>
Here is my amavisd startup log:
Feb 25 11:19:10 mailserver amavis[7292]: logging initialized, log level 3,
syslog: amavis.mail
Feb 25 11:19:10 mailserver amavis[7292]: starting. /usr/sbin/amavisd at
mailserver.domain.tld amavisd-new-2.5.3 (20071212), Unicode aware,
LANG="en_US.UTF-8"
Feb 25 11:19:10 mailserver amavis[7292]: user=102, EUID: 102 (102); group=,
EGID: 105 105 (105 105)
Feb 25 11:19:10 mailserver amavis[7292]: Perl version 5.008008
Feb 25 11:19:10 mailserver amavis[7292]: INFO: SA version: 3.1.9, 3.001009, no
optional modules: Net::CIDR::Lite Sys::Hostname::Long
Mail::SpamAssassin::Plugin::DKIM Mail::SpamAssassin::Plugin::URIDetail
Razor2::Client::Agent IP:
:Country::Fast Mail::DKIM Mail::DKIM::Verifier Mail::SPF::Query
Crypt::OpenSSL::RSA auto::Crypt::OpenSSL::RSA::new_public_key
auto::Crypt::OpenSSL::RSA::new_key_from_parameters
auto::Crypt::OpenSSL::RSA::get_key_parameters aut
o::Crypt::OpenSSL::RSA::import_random_seed Digest::SHA Error
Feb 25 11:19:10 mailserver amavis[7292]: SpamControl: init_pre_chroot done
Feb 25 11:19:10 mailserver amavis[7293]: Net::Server: Process Backgrounded
Feb 25 11:19:10 mailserver amavis[7293]: Net::Server: 2008/02/25-11:19:10
Amavis (type Net::Server::PreForkSimple) starting! pid(7293)
Feb 25 11:19:10 mailserver amavis[7293]: Net::Server: Binding to TCP port 10024
on host 127.0.0.1
Feb 25 11:19:10 mailserver amavis[7293]: Net::Server: Group Not Defined.
Defaulting to EGID '105 105'
Feb 25 11:19:10 mailserver amavis[7293]: Net::Server: User Not Defined.
Defaulting to EUID '102'
Feb 25 11:19:10 mailserver amavis[7293]: config files read: /etc/amavisd.conf
Feb 25 11:19:10 mailserver amavis[7293]: Module Amavis::Conf 2.093
Feb 25 11:19:10 mailserver amavis[7293]: Module Archive::Zip 1.16
Feb 25 11:19:10 mailserver amavis[7293]: Module BerkeleyDB 0.33
Feb 25 11:19:10 mailserver amavis[7293]: Module Compress::Zlib 2.008
Feb 25 11:19:10 mailserver amavis[7293]: Module Convert::TNEF 0.17
Feb 25 11:19:10 mailserver amavis[7293]: Module Convert::UUlib 1.051
Feb 25 11:19:10 mailserver amavis[7293]: Module DBD::Pg 1.49
Feb 25 11:19:10 mailserver amavis[7293]: Module DBD::mysql 3.0007
Feb 25 11:19:10 mailserver amavis[7293]: Module DBI 1.52
Feb 25 11:19:10 mailserver amavis[7293]: Module DB_File 1.814
Feb 25 11:19:10 mailserver amavis[7293]: Module Digest::MD5 2.36
Feb 25 11:19:10 mailserver amavis[7293]: Module Digest::SHA1 2.11
Feb 25 11:19:10 mailserver amavis[7293]: Module IO::Socket::INET6 2.51
Feb 25 11:19:10 mailserver amavis[7293]: Module MIME::Entity 5.420
Feb 25 11:19:10 mailserver amavis[7293]: Module MIME::Parser 5.420
Feb 25 11:19:10 mailserver amavis[7293]: Module MIME::Tools 5.420
Feb 25 11:19:10 mailserver amavis[7293]: Module Mail::Header 2.02
Feb 25 11:19:10 mailserver amavis[7293]: Module Mail::Internet 2.02
Feb 25 11:19:10 mailserver amavis[7293]: Module Mail::SpamAssassin 3.001009
Feb 25 11:19:10 mailserver amavis[7293]: Module Net::DNS 0.59
Feb 25 11:19:10 mailserver amavis[7293]: Module Net::Server 0.97
Feb 25 11:19:10 mailserver amavis[7293]: Module Time::HiRes 1.86
Feb 25 11:19:10 mailserver amavis[7293]: Module URI 1.35
Feb 25 11:19:10 mailserver amavis[7293]: Module Unix::Syslog 1.0
Feb 25 11:19:10 mailserver amavis[7293]: Amavis::DB code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Amavis::Cache code loaded
Feb 25 11:19:10 mailserver amavis[7293]: SQL base code loaded
Feb 25 11:19:10 mailserver amavis[7293]: SQL::Log code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: SQL::Quarantine NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: Lookup::SQL code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Lookup::LDAP code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: AM.PDP-in proto code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: SMTP-in proto code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Courier proto code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: SMTP-out proto code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Pipe-out proto code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: BSMTP-out proto code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: Local-out proto code loaded
Feb 25 11:19:10 mailserver amavis[7293]: OS_Fingerprint code NOT loaded
Feb 25 11:19:10 mailserver amavis[7293]: ANTI-VIRUS code loaded
Feb 25 11:19:10 mailserver amavis[7293]: ANTI-SPAM code loaded
Feb 25 11:19:10 mailserver amavis[7293]: ANTI-SPAM-SA code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Unpackers code loaded
Feb 25 11:19:10 mailserver amavis[7293]: Found $file at /usr/bin/file
Feb 25 11:19:10 mailserver amavis[7293]: No $dspam, not using it
Feb 25 11:19:10 mailserver amavis[7293]: No $altermime, not using it
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .mail
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .asc
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .uue
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .hqx
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .ync
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .F at
/usr/bin/unfreeze
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .Z at
/usr/bin/uncompress
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .gz at
/usr/bin/gzip -d
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .gz (backup,
not used)
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .bz2 at
/usr/bin/bzip2 -d
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .lzo at
/usr/bin/lzop -d
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .rpm at
/usr/bin/rpm2cpio
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .cpio at
/usr/bin/pax
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .tar at
/usr/bin/pax
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .deb at
/usr/bin/ar
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .zip
Feb 25 11:19:10 mailserver amavis[7293]: No decoder for .7z tried: 7zr,
7za, 7z
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .rar at
/usr/bin/unrar
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .arj at
/usr/bin/arj
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .arc at
/usr/bin/nomarch
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .zoo at
/usr/bin/zoo
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .lha at
/usr/bin/lha
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .cab at
/usr/bin/cabextract
Feb 25 11:19:10 mailserver amavis[7293]: No decoder for .tnef tried: tnef
Feb 25 11:19:10 mailserver amavis[7293]: Internal decoder for .tnef
Feb 25 11:19:10 mailserver amavis[7293]: Found decoder for .exe at
/usr/bin/unrar; /usr/bin/lha; /usr/bin/arj
Feb 25 11:19:10 mailserver amavis[7293]: Using primary internal av scanner code
for ClamAV-clamd
Feb 25 11:19:10 mailserver amavis[7293]: Found secondary av scanner
ClamAV-clamscan at /usr/bin/clamscan
Feb 25 11:19:10 mailserver amavis[7293]: Creating db in /var/amavis/db/;
BerkeleyDB 0.33, libdb 4.3
Feb 25 11:19:10 mailserver amavis[7293]: SpamControl: initializing
Mail::SpamAssassin
Feb 25 11:19:11 mailserver amavis[7293]: SpamControl: init_pre_fork done
Feb 25 11:19:11 mailserver amavis[7296]: TIMING [total 4 ms] - bdb-open: 4
(100%)100, rundown: 0 (0%)100
Feb 25 11:19:11 mailserver amavis[7297]: TIMING [total 4 ms] - bdb-open: 4
(100%)100, rundown: 0 (0%)100
Also, a snippet of my maillog shows that amavisd and spamassassin are working
together, but since the destination address is not being returned by the query,
no headers are added:
Feb 25 12:01:18 mailserver postfix/smtpd[7576]: connect from
lists-outbound.sourceforge.net[66.35.250.225]
Feb 25 12:01:19 mailserver postfix/smtpd[7576]: 259C3153008F:
client=lists-outbound.sourceforge.net[66.35.250.225]
Feb 25 12:01:19 mailserver postfix/cleanup[7594]: 259C3153008F:
message-id=<[EMAIL PROTECTED]>
Feb 25 12:01:19 mailserver postfix/qmgr[2965]: 259C3153008F: from=<[EMAIL
PROTECTED]>, size=4858, nrcpt=1 (queue active)
Feb 25 12:01:19 mailserver postfix/smtpd[7576]: disconnect from
lists-outbound.sourceforge.net[66.35.250.225]
Feb 25 12:01:19 mailserver amavis[7484]: (07484-01) process_request: fileno
sock=10, STDIN=0, STDOUT=1
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) ESMTP::10024
/var/amavis/tmp/amavis-20080225T113810-07484: <[EMAIL PROTECTED]> -> <[EMAIL
PROTECTED]> SIZE=4858 Received: from mailserver.domain.tld ([127.0.
0.1]) by localhost (mailserver.domain.tld [127.0.0.1]) (amavisd-new, port
10024) with ESMTP for <[EMAIL PROTECTED]>; Mon, 25 Feb 2008 12:01:19 -0700 (MST)
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) body hash:
e5f63c081bee849de3c592fed592eebd
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) Checking: GpgpqmhNqKFi
[66.35.250.225] <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) 2822.From: <[EMAIL
PROTECTED]>, 2822.Sender: <[EMAIL PROTECTED]>
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) p001 1 Content-Type:
text/plain, size: 1948 B, name:
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) Checking for banned types
and filenames
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) collect banned table[0]:
[EMAIL PROTECTED], tables: DEFAULT=>Amavis::Lookup::RE=ARRAY(0xa561358)
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) p.path [EMAIL PROTECTED]:
"P=p001,L=1,M=text/plain,T=asc"
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) Using ClamAV-clamd:
(built-in interface)
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) Using (ClamAV-clamd) on
dir: CONTSCAN /var/amavis/tmp/amavis-20080225T113810-07484/parts\n
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) ClamAV-clamd: Connecting to
socket /var/run/clamav/clamd.sock
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) ClamAV-clamd: Sending
CONTSCAN /var/amavis/tmp/amavis-20080225T113810-07484/parts\n to UNIX socket
/var/run/clamav/clamd.sock
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) ask_av (ClamAV-clamd):
/var/amavis/tmp/amavis-20080225T113810-07484/parts CLEAN
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) ClamAV-clamd result: clean
Feb 25 12:01:19 mailserver amavis[7484]: (07484-02) wbl: soft-whitelisted (-3)
sender <[EMAIL PROTECTED]> => <[EMAIL PROTECTED]>, recip_key="."
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) spam_scan: score=0.479
autolearn=no tests=[DNS_FROM_RFC_ABUSE=0.479]
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) do_notify_and_quar:
ccat=Clean (1,0) ("1":Clean, "0":CatchAll) ccat_block=(), q_mth=, qar_mth=
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp creating socket by
IO::Socket::INET: 127.0.0.1
Feb 25 12:01:22 mailserver postfix/smtpd[7599]: connect from
localhost[127.0.0.1]
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to greeting: 220
mailserver.domain.tld ESMTP Postfix
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp cmd> EHLO localhost
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to EHLO: 250
mailserver.domain.tld\nPIPELINING\nSIZE 10240000\nVRFY\nETRN\nSTARTTLS\nAUTH
PLAIN LOGIN\nAUTH=PLAIN LOGIN\nENHANCEDSTATUSCODES\n8BITMIME\nDSN
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) AUTH not needed, user='',
MTA offers 'PLAIN LOGIN'
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp cmd> MAIL FROM:<[EMAIL
PROTECTED]> BODY=7BIT
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp cmd> RCPT TO:<[EMAIL
PROTECTED]> ORCPT=rfc822;[EMAIL PROTECTED]
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp cmd> DATA
Feb 25 12:01:22 mailserver postfix/smtpd[7599]: B2AA8153008E:
client=localhost[127.0.0.1]
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to MAIL (pip):
250 2.1.0 Ok
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to RCPT (pip)
(<[EMAIL PROTECTED]>): 250 2.1.5 Ok, id=07484-02, from MTA([127.0.0.1]:10025):
250 2.1.5 Ok
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to DATA: 354 End
data with <CR><LF>.<CR><LF>
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp cmd> QUIT
Feb 25 12:01:22 mailserver postfix/cleanup[7594]: B2AA8153008E:
message-id=<[EMAIL PROTECTED]>
Feb 25 12:01:22 mailserver postfix/smtpd[7599]: disconnect from
localhost[127.0.0.1]
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to data-dot
(<[EMAIL PROTECTED]>): 250 2.0.0 Ok: queued as B2AA8153008E
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) smtp resp to QUIT: 221
2.0.0 Bye
Feb 25 12:01:22 mailserver postfix/qmgr[2965]: B2AA8153008E: from=<[EMAIL
PROTECTED]>, size=5014, nrcpt=1 (queue active)
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) FWD via SMTP: <[EMAIL
PROTECTED]> -> <[EMAIL PROTECTED]>,BODY=7BIT 250 2.6.0 Ok, id=07484-02, from
MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as B2AA8153008E
Feb 25 12:01:22 mailserver amavis[7484]: (07484-02) Passed CLEAN,
[66.35.250.225] [216.239.58.187] <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>,
Message-ID: <[EMAIL PROTECTED]
l.gmail.com>, mail_id: GpgpqmhNqKFi, Hits: -2.521, size: 4858, queued_as:
B2AA8153008E, 3524 ms
Feb 25 12:01:22 mailserver postfix/smtp[7596]: 259C3153008F: to=<[EMAIL
PROTECTED]>, relay=127.0.0.1[127.0.0.1]:10024, delay=3.8,
delays=0.22/0.01/0/3.5, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as
B2AA8153008E)
Feb 25 12:01:22 mailserver postfix/qmgr[2965]: 259C3153008F: removed
I am running Postfix with the content_filter = smtp-amavis:[127.0.0.1]:10024
Mail delivery is functional. Amavisd is using clamscan, which is functioning
correctly. I know that spamassassin does work (adds the headers to messages)
if I remove the sql lookup DSN and add the appropriate domain to the
@local_domains_maps, SA headers are inserted into the email.
The following is a list of packages I have installed that are related to
amavisd and pgsql. I have not installed anything that is not part of an RPM.
amavisd-new-2.5.3-2.el5.rf
libdbi-0.8.1-2.1
libdbi-dbd-pgsql-0.8.1a-1.2.2
libdbi-drivers-0.8.1a-1.2.2
perl-5.8.8-10.el5_0.2
perl-BerkeleyDB-0.33-1.el5.rf
perl-DBD-Pg-1.49-1.fc6
perl-DBI-1.52-1.fc6
perl-MailTools-2.02-1.el5.rf
perl-MIME-tools-5.420-2.el5.rf
postgresql-8.1.9-1.el5
postgresql-devel-8.1.9-1.el5
postgresql-libs-8.1.9-1.el5
postgresql-server-8.1.9-1.el5
Thanks in advance,
Kevin Davidson
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
