You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "H. Etzel" <he...@web.de> on 2006/08/20 21:37:36 UTC
Userprefs Spamassassin 2.55
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 *@foo.com
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: <XX...@carco-east.com>
X-Original-To: web34p1@XX.serverkompetenz.net
Delivered-To: web34p1@XX.serverkompetenz.net
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 <ko...@foo.de>; 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 <ko...@foo.de>; 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 foo@web.de; Sun, 20 Aug 2006 19:25:02 +0200
Received: by 192.168.93.59 with SMTP id knNyEMA;
for <fo...@web.de>; Sun, 20 Aug 2006 10:24:42 -0700
Message-ID: <00...@cslj>
Reply-To: "foo" <XX...@carco-east.com>
From: "foo" <XX...@carco-east.com>
To: foo@web.de
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
Re: Userprefs Spamassassin 2.55
Posted by Benny Pedersen <me...@junc.org>.
On Sun, August 20, 2006 22:35, Theo Van Dinter wrote:
> On Sun, Aug 20, 2006 at 09:37:36PM +0200, H. Etzel wrote:
>> 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 don't think anyone here is going to be able to help you with such an old
> version of SpamAssassin (2.55 was from 5/2003). I would recommend upgrading
> to a more recent version (3.1.4 is the latest) and going from there.
later versions have the same problem as 2.55 have with mysql prefs :/(
spamassassin need better virtual prefs for hosts that does not use unix accounts
one way of doing it could be to make mta send only one recipient at a time,
and make sure that spamc using this as recipient user in mysql, this way it
should work, but it will be terible slow if its to more then one recipient
--
Benny
Re: Userprefs Spamassassin 2.55
Posted by Theo Van Dinter <fe...@apache.org>.
On Sun, Aug 20, 2006 at 09:37:36PM +0200, H. Etzel wrote:
> 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 don't think anyone here is going to be able to help you with such an old
version of SpamAssassin (2.55 was from 5/2003). I would recommend upgrading
to a more recent version (3.1.4 is the latest) and going from there.
--
Randomly Generated Tagline:
"So many pedestrians... so little time."