Hi people,
I have do use an old Version of Spamassassin (2.55) with a new version
of Confixx (which should not realy be the problem...)
However, the database is set, data is within the database, but no user
prefs are used!!
Where is the configuration error?
I'm runnig a SuSE 9.1 System
Spamd is running with wollowing Options:
/usr/sbin/spamd -d -x -q -L
/etc/mail/spamassassin/local.cf looks like this (remove comments):
-------------------------------------
required_hits 5.0
rewrite_subject 1
subject_tag *****SPAM*****
report_safe 1
use_terse_report 0
use_bayes 1
auto_learn 1
skip_rbl_checks 0
use_razor2 1
use_dcc 1
use_pyzor 1
ok_languages all
ok_locales all
all_spam_to [EMAIL PROTECTED]
user_scores_dsn
DBI:mysql:confixx:localhost;mysql_socket=/var/lib/mysql/mysql.sock
user_scores_sql_username confixx
user_scores_sql_password password
user_scores_sql_table spampref
-------------------------------------
Table spampref looks like this:
-------------------------------------
CREATE TABLE `spampref` (
`username` varchar(100) NOT NULL default '',
`preference` varchar(30) NOT NULL default '',
`value` varchar(100) NOT NULL default '',
`prefid` int(11) NOT NULL auto_increment,
`server_id` varchar(32) NOT NULL default 'foo',
PRIMARY KEY (`prefid`,`server_id`),
KEY `username` (`username`),
KEY `prefid` (`prefid`)
) TYPE=MyISAM AUTO_INCREMENT=137 ;
-------------------------------------
Some example data inside...
-------------------------------------
INSERT INTO `spampref` VALUES ('web34p1', 'rewrite_subject', '1', 39,
'foo');
INSERT INTO `spampref` VALUES ('web34p1', 'required_hits', '1', 40,
'foo');
INSERT INTO `spampref` VALUES ('web34p1', 'report_header', '1', 41,
'foo');
INSERT INTO `spampref` VALUES ('web34p1', 'defang_mime', '0', 42,
'foo');
INSERT INTO `spampref` VALUES ('web34p1', 'use_terse_report', '1', 43,
'foo');
-------------------------------------
Here an example mail header for a recieved mail where you can see that
the prefs have not been applied (require hits should be 1.0)!
-------------------------------------
Return-Path: <[EMAIL PROTECTED]>
X-Original-To: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: by XX.serverkompetenz.net (Postfix, from userid 670)
id 7423166403D; Sun, 20 Aug 2006 19:24:58 +0200 (CEST)
Received: from fmmailgate02.web.de (fmmailgate02.web.de
[217.72.192.227])
by XX.serverkompetenz.net (Postfix) with ESMTP id 271DD664038
for <[EMAIL PROTECTED]>; Sun, 20 Aug 2006 19:24:58 +0200 (CEST)
Received: from mx30.web.de (mx30.dlan.cinetic.de [172.20.6.145])
by fmmailgate02.web.de (Postfix) with ESMTP id 207AA14DFBFB
for <[EMAIL PROTECTED]>; Sun, 20 Aug 2006 19:25:03 +0200 (CEST)
Received: from [212.25.75.41] (helo=carco-east.com)
by mx30.web.de with smtp (WEB.DE 4.107 #114)
id 1GEr2k-0007oC-00
for [EMAIL PROTECTED]; Sun, 20 Aug 2006 19:25:02 +0200
Received: by 192.168.93.59 with SMTP id knNyEMA;
for <[EMAIL PROTECTED]>; Sun, 20 Aug 2006 10:24:42 -0700
Message-ID: <[EMAIL PROTECTED]>
Reply-To: "foo" <[EMAIL PROTECTED]>
From: "foo" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: news ieteve
Date: Sun, 20 Aug 2006 10:24:42 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0001_01C6C442.D9EF6BB0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Spam-Status: No, hits=0.7 required=5.0
tests=HTML_30_40,HTML_MESSAGE
version=2.55
X-Spam-Level:
X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp)
X-UIDL: *>P!!DWL"!SgR!!S'+"!
Status: RO
-------------------------------------
Any Idea whats going wrong?
Thanks,
Haiko
