Re: RCVD_FAKE_HELO_DOTCOM score zero

2004-09-26 Thread Bob Proulx
Bob Proulx wrote:
0.0 RCVD_FAKE_HELO_DOTCOM  Received contains a faked HELO hostname
2.2 FORGED_YAHOO_RCVD  'From' yahoo.com does not match 'Received' 
 headers
   score RCVD_FAKE_HELO_DOTCOM 0.899 0.034 0.969 0.424

Thanks to jdow and also to Bob Menschel who mailed me offlist I now
have the answer.  My bayes database was (temporarily) broken when that
message was scored.

  grep -r score.*FORGED_YAHOO_RCVD /usr/share/spamassassin
  score FORGED_YAHOO_RCVD 1.668 2.174 2.095 2.700

Since FORGED_YAHOO_RCVD lists here as 2.2 I was operating on column
two.  I was expecting to be operating in column four.  Column four
would print 0.4 but column two would print 0.0 within the rounding and
truncation of the formatting.

Quoting the docs:

   If four valid scores are listed, then the score that
   is used depends on how SpamAssassin is being used. The
   first score is used when both Bayes and network tests
   are disabled. The second score is used when Bayes is
   disabled, but network tests are enabled. The third
   score is used when Bayes is enabled and network tests
   are disabled. The fourth score is used when Bayes is
   enabled and network tests are enabled.

Basically: score tag -bayes-net -bayes+net +bayes-net +bayes+net

Why was I operating in -bayes+net mode?  Not sure.  I am normally
using bayes and getting column four scores.  I had just done the
upgrade to sa-3.0 and that changes the database from version 2 to
version 3.  I also did some more training on spam.  But my sa-learn
--dump numbers were very low in the 250 range even though I should
have had a thousand messages trained.

I think the bayes db was lost during my upgrade.  Then I trained on
top of it.  In the middle of that this message was scored without
bayes but with net and so got the column two scores.  That explains
the strange behavior.

To double check this I recovered my previous bayes db from backup.  I
downgraded back to the previous sa-2.64.  Then upgraded again to
sa-3.0 to try to recreate my problem with the bayes database.  But I
was unable to recreate the problem.  Everything worked fine this time
and my bayes database lists 1137/1272 ham/spam now.  So it must have
been some strange problem between the chair and keyboard when I did
the first upgrade.

Bob


Re: Installing SpamAssassin on AIX

2004-09-26 Thread Theo Van Dinter
On Sat, Sep 25, 2004 at 09:24:31PM -0400, Harold Pritchett wrote:
 I downloaded Mail-SpamAssassin-3.0.0.tar.gz from the
 apache site.  Following the instructions in the INSTALL
 file, I unpacked it, and ran the following commands:
 version.h.pl: version.h.pl: version.h.pl: version.h.pl: version.h.pl:
   version.h.pl: version.h.pl: Can't locate Digest/SHA1.pm
 
 Help!

It looks as if you don't have the Digest::SHA1 module installed (listed
in the INSTALL document as required).

-- 
Randomly Generated Tagline:
Why use Windows, since there is a door?
 (By [EMAIL PROTECTED], Andre Fachat)


pgp5AR7xIMnju.pgp
Description: PGP signature


Re: no dbs present

2004-09-26 Thread JP Kelly
Yes I see that during regular spam scanning the bayes_db is working.
Thanks for all your effort!
SpamAssassin ROCKS!
On 25 Sep 2004, at 6:42 PM, Theo Van Dinter wrote:
That's the debug output from the initial get everything going 
internal
message run.  Don't worry about it. :)
-
Jon-Paul Kelly
A11 SA TEX
[EMAIL PROTECTED]
web hosting
http://www.jpkvideo.net


Cygwin SA3.0 Problems

2004-09-26 Thread JamesDR








I am trying to figure out how to install SA3.0 under a clean
cygwin install. I can get it quasi
working, however, I have a huge problem.
It seems that Spamd is truncating emails with
attachments (doesnt matter the attachment) around the same spot. Spamd in its logs report that it sends back the entire
message, however, (for example) a non spam message of ~60k is truncated to ~34k.
This issue has been around since RC3, although I dont think it is
entirely related to the code of spamd. 

The instructions I wrote, and the process I am using are available
at :

http://www.jamesdr.dyndns.org/sa3.asp

I am not the only one having the issue, and it is not
related to just one version of windows (happens on 2k pro, xp,
 2k server) if any one has tried a clean install of cygwin and
spamassassin with the mysql bayses/awl/user
prefs and got it working with out attachment truncation,
or needs more information, feel free to ask. Weve been scratching our
heads on this one for a while.



Thanks, 

James










Re: MIMEDefang, SpamAssassin and URIDNSBLs

2004-09-26 Thread Ryan Thompson
Tim Boyer wrote to users@spamassassin.apache.org:
3.  Do I have DNS lookup enabled?  Yup:
# Enable or disable network checks
dns_available yes
skip_rbl_checks 0
rbl_timeout 15
Can't think of anything else to try.
Do you have
# If boolean true, skip SA network tests
$SALocalTestsOnly = 1;
in your mimedefang-filter? Make sure you set $SALocalTestsOnly to zero.
For whatever reason, MIMEDefang decided they would override this *one*
SA option within mimedefang-filter. ;-)
If that doesn't help, get a bigger hammer, or maybe ask on the
MIMEDefang list.
If I knew how to make MIMEDefang call SpamAssassin with the debug
switch, that might point me in the right direction.
MIMEDefang uses the SA libs directly... which means, so can you, in
mimedefang-filter. :-) I've never tried it, but you should be able to
enable debugging output before calling the SA check in filter_end().
- Ryan
--
  Ryan Thompson [EMAIL PROTECTED]
  SaskNow Technologies - http://www.sasknow.com
  901-1st Avenue North - Saskatoon, SK - S7K 1Y4
Tel: 306-664-3600   Fax: 306-244-7037   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America


Re: FreeBSD port of SpamAssassin 3.0.0 (continued)

2004-09-26 Thread Dan Mahoney, System Admin
On Sun, 26 Sep 2004, Justin Mason wrote:
On Sat, Sep 25, 2004 at 01:21:19PM -0400, Dan Mahoney, System Admin wrote:
On Sat, 25 Sep 2004, Mathieu Arnold wrote:
Does this mean we're going to get/need a port in for the IP::Country::Fast
module?  I can create it if you like.
(I haven't been able to find a useful documentation on creating a port 00
is there one?)
A menu-based config (like the one for the mod_php) port would probably be
useful as well, to enable things like SSL, and database support.
guys -- bear in mind that IP:C:F is an optional
module, so I wouldn't worry about it too much.
I know, but it should be there for the sake of completeness.  I read that 
the country filters are off by default, how does one turn them on?

-Dan
--j.

+-le 25/09/2004 02:20 -0700, Pat Lashley ?crivait :
| --On Saturday, September 25, 2004 08:59:03 +0200 Mathieu Arnold
| [EMAIL PROTECTED] wrote:
|
| +-Le 24/09/2004 18:20 -0700, Pat Lashley a dit :
|| SA 3.0 should probably be a separate port rather than an update
|| to the existing SA port; due to the lack of backwards compatability
|| in the API.  For example, it would break the Exim port which by
|| default includes the ExiScan patches.  (The Exim port would still
|| build; but the SpamAssassin support would fail at run time.)
|
| I don't think we will keep the old spamassassin. The 2.64 version will
be
| the only one working with 5.005_03, but well... It's not possible to
have
| SA3 work with 5.005_03 (believe me, I tried).
| So, a few days before committing the SA3 update, I'll send a mail with
the
| patch I plan to commit to maintainers of ports depending on SA264 for
them
| to update/patch/whatever.
|
| That seems like an awfully short transition period.  Why not
| a separate 3.0 port for a while; with the old one being deprecated?
| Then remove the 2.64 port once the dependant ports have been updated
| and in the field long enough for some serious testing?
I don't want to have a SA3 port, I'm more in favor of a SA264 port designed
for perl 5.005_03 as the databases/p5-DBI-137 port. This is still under
discussion.
--
Mathieu Arnold
--
We need another cat.  This one's retarded.
-Cali, March 8, 2003 (3:43 AM)
Dan Mahoney
Techie,  Sysadmin,  WebGeek
Gushi on efnet/undernet IRC
ICQ: 13735144   AIM: LarpGM
Site:  http://www.gushi.org
---

--
Hey, call me anything you like.  I'm Dan to my friends, gushi to my
close friends, 'hey, you' to my girlfriend, 'mrrow?' to my cat, and 'why
the hell is the router on fire?' to my job.
-Dan Mahoney
 12/2/02

Dan Mahoney
Techie,  Sysadmin,  WebGeek
Gushi on efnet/undernet IRC
ICQ: 13735144   AIM: LarpGM
Site:  http://www.gushi.org
---


RE: MIMEDefang, SpamAssassin and URIDNSBLs

2004-09-26 Thread Tim Boyer

 Tim Boyer wrote to users@spamassassin.apache.org:

  3.  Do I have DNS lookup enabled?  Yup:
 
  # Enable or disable network checks
  dns_available yes
  skip_rbl_checks 0
  rbl_timeout 15
 
  Can't think of anything else to try.

 Do you have

  # If boolean true, skip SA network tests
  $SALocalTestsOnly = 1;

 in your mimedefang-filter? Make sure you set $SALocalTestsOnly to zero.
 For whatever reason, MIMEDefang decided they would override this *one*
 SA option within mimedefang-filter. ;-)


Yup:

$AdminAddress = '[EMAIL PROTECTED]';
$AdminName = Tim Boyer;
$SALocalTestsOnly = 0;


 If that doesn't help, get a bigger hammer, or maybe ask on the
 MIMEDefang list.


I've posted substantially the same message there - with substantially the
same results.

  If I knew how to make MIMEDefang call SpamAssassin with the debug
  switch, that might point me in the right direction.

 MIMEDefang uses the SA libs directly... which means, so can you, in
 mimedefang-filter. :-) I've never tried it, but you should be able to
 enable debugging output before calling the SA check in filter_end().


I'll give it a try in the morning.  Thanks much...

--
Tim Boyer
Director
Information Systems and Engineering Projects
Denman Tire Corporation
[EMAIL PROTECTED]




Re: SA-3.0.0 for FBSD Ports

2004-09-26 Thread Mathieu Arnold
+-Le 25/09/2004 18:16 -0500, Jack L. Stone a dit :
| At 07:32 PM 9.25.2004 +0200, Mathieu Arnold wrote:
| It's scheduled to be updated as soon as the port tree is unfrozen, if you
| want to test the patch, it's available there :
| http://people.freebsd.org/~mat/p5-Mail-SpamAssassin-3.0.0.diff
| 
| Mat: Thanks, the patch worked smoothly as silk. Had to do some tweaking
| here 'n there, but you covered the big job very well -- dependencies, etc.
| Found I needed NET::LDAP according to debug.

Well, Net::LDAP is a specificity of your local configuration (like it could
have been for instance DBD::mysql or DBD::whatever), and as I don't want to
add them all or to add a long long list of possible dependencies to keep it
simple, I'll leave that kind of thing to the upgrade procedure everyone's
going to have to follow :-)

| SA-3.0 is up and running on my test box and looks good.

Nice to hear positive feedback :-)

-- 
Mathieu Arnold

pgpILJZSDgXC9.pgp
Description: PGP signature


Re: Razor-Agent 2.61

2004-09-26 Thread Matt Kettler
At 11:50 PM 9/25/2004 -0500, Thomas Cameron wrote:
I finally created RPMs for Razor-Agent 2.61 on FC2.  I've read through the 
man pages for razor-check and razor-report and I am pretty sure I 
understand how to use them, but do I really need to directly use these 
tools?  Or does SA use Razor automagically via the use_razor2 1 entry in 
local.cf?

I am using SA 3.0.0.
There's generally no need to use either tool when you use SA, except for 
testing purposes or user preference. The only razor tool I sometimes use 
directly on a production server is razor-admin --force-discover.

SpamAssassin automatically detects and uses razor, provided use_razor2 is 
not set to 0, and provided that SA is not started in local only with the 
-L parameter. It will show up as a rule in the hits (RAZOR2_CHECK), and a 
second rule for the CF range is high (RAZOR2_CF_RANGE_51_100).

You can use spamassassin -r to report email as if you were using 
razor-report. It will also remove any SA markups, learn as spam, and report 
to any other hash-systems you have installed in the process. However, if 
you want you can still use razor-report if your copy of SA is configured to 
not touch the body of the email (ie: report_safe 0).

You can also use spamassassin -k as a replacement for razor-revoke.



RE: Cygwin SA3.0 Problems

2004-09-26 Thread Jason J. Ellingson
Here are CygWin instructions that I wrote a few months ago that worked for
me and others up to and including SA-3.0.0-rc2... at which point I moved to
a dedicated SuSE Linux 9.1 server for SpamD and then wrote a custom SpamC
client on windows for XMail Server.
 
Feel free to take whatever info you want from it (just add my name to your
credit list) as I will likely take them down in the future as I don't use it
anymore.
 
http://www.yourtech.net/documents/cw-sa/
 

Jason J Ellingson
Technical Consultant

615.301.1682 : nashville
612.605.1132 : minneapolis

www.ellingson.com
[EMAIL PROTECTED] 

 



From: JamesDR [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 25, 2004 9:26 PM
To: users@spamassassin.apache.org
Subject: Cygwin SA3.0 Problems



I am trying to figure out how to install SA3.0 under a clean cygwin install.
I can get it quasi working, however, I have a huge problem.  It seems that
Spamd is truncating emails with attachments (doesn't matter the attachment)
around the same spot.  Spamd in it's logs report that it sends back the
entire message, however, (for example) a non spam message of ~60k is
truncated to ~34k. This issue has been around since RC3, although I don't
think it is entirely related to the code of spamd.  

The instructions I wrote, and the process I am using are available at :

http://www.jamesdr.dyndns.org/sa3.asp

I am not the only one having the issue, and it is not related to just one
version of windows (happens on 2k pro, xp,  2k server) if any one has tried
a clean install of cygwin and spamassassin with the mysql bayses/awl/user
prefs and got it working with out attachment truncation, or needs more
information, feel free to ask. We've been scratching our heads on this one
for a while.

 

Thanks, 

James

 




Re: SA 3.0-RC2 producing extremely large bayes journal files

2004-09-26 Thread Kai Schaetzl
Kai Schaetzl wrote on Sat, 25 Sep 2004 22:34:10 +0200:

 FWIW, the problem seems to have been RC2-specific


I spoke to soon, I just needed to wait another day. So it took 15 days to 
surface this time. I'm going to open a bug on this if I can't find it on 
Bugzilla.

Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





Re: SA 3.0 upgrade bug and fix (spamd reporting to log, but not tagging messages)

2004-09-26 Thread Anthony Edwards
On Fri, Sep 24, 2004 at 06:12:53PM +0100, Anthony Edwards wrote:
 On Fri, Sep 24, 2004 at 03:04:58AM +0100, Anthony Edwards wrote:
  
  I removed all SpamAssassin files earlier this evening and re-installed
  using cpan.  With hindsight, I believe I could have simply done what
  you have suggested above.  I run a SuSE 8.2 system, and persuading
  manual configuration of startup script changes to co-exist with SuSE's
  YaST tool created configurations is far from trivial, so I shall be
  sticking with /usr/bin/spamassassin for the time being.
 
 In fact, it's easy, or would be if the script at:
 
 http://kmail.kde.org/unsupported/spamd
 
 Actually worked properly on SuSE 8.2.  Unfortunately, it doesn't seem
 to, quite.  If it did, it would be a simple matter of downloading and
 copying it to the /etc/init.d directory, changing file permissions,
 then running YaST and configuring spamd to start in runlevels 3 
 5  using the Runlevel Editor.
 
The answer to this, of course (on a SuSE 8.2 system at least) was to
download:

ftp://ftp.suse.com/pub/suse/i386/8.2/suse/src/spamassassin-2.50-14.src.rpm

Then, do:

[EMAIL PROTECTED]:~/software rpm2cpio spamassassin-2.50-14.src.rpm | cpio
-iv init.spamd

Next, edit init.spamd to change the line:

SPAMD_BIN=/usr/sbin/spamd

To read:

SPAMD_BIN=/usr/bin/spamd

Then, copy the resultant changed file [1] to /etc/init.d/spamd, and
next use the YaST Runlevel Editor to start spamd in runlevels 3  5.

Working perfectly now.

[1] http://www.805.org.uk/spamd.txt

-- 
Anthony Edwards
[EMAIL PROTECTED]


Mailscanner+Spamassassin

2004-09-26 Thread abusquets


Has somebody updated their Spamassassin old version to v3?
What version of Mailscanner uses?
Which version of Mailscanner I must install why Spamassassin 3 works
correctly?

Thanks


Re: Mailscanner+Spamassassin

2004-09-26 Thread Raymond Dijkxhoorn
Hi!
Has somebody updated their Spamassassin old version to v3?
What version of Mailscanner uses?
Which version of Mailscanner I must install why Spamassassin 3 works
correctly?
Latest stabil version works nicely together with SA3. Julian even builded 
complete installs to install SA3 also. Of for the guy who was lookin for 
SA3 RPM's. Perhaps he can take that tallball also.

See: http://www.sng.ecs.soton.ac.uk/mailscanner/downloads.shtml
install-Clam-SA.tar.gz
There is perl-Mail-SpamAssassin-3.0.0-1.src.rpm, and you can easilly 
rpmbuild --rebuild perl-Mail-SpamAssassin-3.0.0-1.src.rpm to get your own 
set of RPMs.

Bye,
Raymond.


RE: Cygwin SA3.0 Problems

2004-09-26 Thread JamesDR
It seems something in the Cygwin packages may be causing the problem. I
have version 3.0 working here and at work under cygwin, however, I
installed cygwin wyyy back when 2.62 was just released.  If I do a
copy install (install cygwin, overwrite install) with the old version,
messages are not truncated.  I will try your directions; however, I
think that there is something in the newest Cygwin packages that mess up
spamd... Will try something else, and will let the list know (also will
try your instructions).

Thanks, 
James


-Original Message-
From: Jason J. Ellingson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, September 26, 2004 4:46 AM
To: 'JamesDR'; users@spamassassin.apache.org
Subject: RE: Cygwin SA3.0 Problems

Here are CygWin instructions that I wrote a few months ago that worked
for
me and others up to and including SA-3.0.0-rc2... at which point I moved
to
a dedicated SuSE Linux 9.1 server for SpamD and then wrote a custom
SpamC
client on windows for XMail Server.
 
Feel free to take whatever info you want from it (just add my name to
your
credit list) as I will likely take them down in the future as I don't
use it
anymore.
 
http://www.yourtech.net/documents/cw-sa/
 

Jason J Ellingson
Technical Consultant

615.301.1682 : nashville
612.605.1132 : minneapolis

www.ellingson.com
[EMAIL PROTECTED] 

 



From: JamesDR [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 25, 2004 9:26 PM
To: users@spamassassin.apache.org
Subject: Cygwin SA3.0 Problems



I am trying to figure out how to install SA3.0 under a clean cygwin
install.
I can get it quasi working, however, I have a huge problem.  It seems
that
Spamd is truncating emails with attachments (doesn't matter the
attachment)
around the same spot.  Spamd in it's logs report that it sends back the
entire message, however, (for example) a non spam message of ~60k is
truncated to ~34k. This issue has been around since RC3, although I
don't
think it is entirely related to the code of spamd.  

The instructions I wrote, and the process I am using are available at :

http://www.jamesdr.dyndns.org/sa3.asp

I am not the only one having the issue, and it is not related to just
one
version of windows (happens on 2k pro, xp,  2k server) if any one has
tried
a clean install of cygwin and spamassassin with the mysql
bayses/awl/user
prefs and got it working with out attachment truncation, or needs more
information, feel free to ask. We've been scratching our heads on this
one
for a while.

 

Thanks, 

James

 





Re: (Upgrade 2.63 - 3.0.0) AND (Upgrade Bayes File - MySQL) Documentation?

2004-09-26 Thread Kai Schaetzl
Robert Menschel wrote on Sat, 25 Sep 2004 14:00:07 -0700:

 We split them out this way specifically because file 0 gives the most
 bang for the buck (er, computer resource), file 1 also gives good return
 on the investment, and files 2 and 3 are useful for aggressive sites with
 lots of computer resources, but sites that are low on resources should
 probably not use these low-return files.


I was gradually aware of these split versions, but I didn't make the 
connection from your answer to that, thanks. I use rules_du_jour and there 
doesn't seem to be another option as to use f.i. sare_header in general 
unless I make up my own rules. Or does it use the 0 rules only, anyway?


Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





Re: SPF_HELO_FAIL SPF_HELO_SOFTFAIL

2004-09-26 Thread Kai Schaetzl
Momo wrote on Sun, 26 Sep 2004 17:58:49 +0200:

 Just want to know what's the difference between SPF_HELO_FAIL 
 SPF_HELO_SOFTFAIL ?


- spf.pobox.com explains it all


Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





Re: [sa-list] DSPAM-plugin for SpamAssassin 3.* ?

2004-09-26 Thread Kai Schaetzl
Snowjack wrote on Sat, 25 Sep 2004 16:01:01 -0700:

 Actually, those numbers were from SA 2.64 with the URIDNSBL patch and 
 most of the more conservative SARE rulesets. Didn't include BigEvil, of 
 course, or any of the SARE rules that said they occasionally hit ham.


When I just reduce to the rules coming with SA I still have more than 17 
or 18 MB as you have, maybe 20. Adding a few SARE and some own rules and 
I'm at 40 - 50, bigevil adds another 40 or so to that. What Perl are you 
running?


Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





Re: SA 3.0 and Bigevil

2004-09-26 Thread Kai Schaetzl
Chris Santerre wrote on Wed, 22 Sep 2004 16:40:47 -0400:

 It will consume the
 souls of your server, your family, and that cute girl/guy at your local
 coffee shop!


Isn't that what big evil does? ;-) When I upgraded our first systems to 
3.0 RCs earlier this month I immediately removed bigevil from 
rules_du_jour and switched on SURBL. bigevil consumes the same amount of 
RAM on 2.64 and I think it doesn't really give that much back. I left it 
running on those of our systems which are still on 2.64 for compatibility 
reasons and can afford that RAM drain. I don't think that the SA accuracy 
will drop much when removing it. So, when you want to retire it, just go 
ahead. It was a good idea, but it's finally hitting a threshold ...


Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





Re: [OT]: Charting the history of SPAM

2004-09-26 Thread Kai Schaetzl
Chris Santerre wrote on Wed, 22 Sep 2004 16:17:07 -0400:

 He don't get much spam!


Note, that's only the spam which gets past the MS spam filter!


Kai

-- 

Kai Schätzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com
IE-Center: http://ie5.de  http://msie.winware.org





can't get SQL AWL working in 3.0.0

2004-09-26 Thread Daniel M. Drucker

I have the following /etc/mail/spamassassin/settings.cf:

=
user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_usernamemail
user_scores_sql_passwordmypassword

bayes_store_module  Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn   DBI:mysql:spamassassin:localhost
bayes_sql_username  mail
bayes_sql_password  mypassword

user_awl_dsnDBI:mysql:spamassassin:localhost
user_awl_sql_username   mail
user_awl_sql_password   mypassword
=

SA 3.0.0 is picking up the user scores and bayes from SQL without any
problems, but it seems to be ignoring the awl settings completely --
it is still writing to /root/.spamassassin/auto-whitelist.

I have the database set up correctly, I think:

=
mysql show tables;
++
| Tables_in_spamassassin |
++
| awl|
| bayes_expire   |
| bayes_global_vars  |
| bayes_seen |
| bayes_token|
| bayes_vars |
| userpref   |
++
7 rows in set (0.00 sec)

mysql describe awl;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| username | varchar(100) |  | PRI | |   |
| email| varchar(200) |  | PRI | |   |
| ip   | varchar(10)  |  | PRI | |   |
| count| int(11)  | YES  | | 0   |   |
| totscore | float| YES  | | 0   |   |
+--+--+--+-+-+---+
5 rows in set (0.00 sec)
=

 ... and yet, after several thousand emails processed:
 
=
mysql select * from awl;
Empty set (0.00 sec)
=

Here is output from spamd -D --sql-config --nouser-config :

=
trying to connect to syslog/unix...
no error connecting to syslog/unix
logging enabled:
facility: mail
socket:   unix
output:   syslog
creating INET socket:
Listen: 128
LocalAddr: 127.0.0.1
LocalPort: 783
Proto: 6
ReuseAddr: 1
Type: 1
debug: SpamAssassin version 3.0.0
debug: Score set 0 chosen.
debug: Storable module v2.13 found
debug: Preloading modules with HOME=/tmp/spamd-12206-init
debug: ignore: test message to precompile patterns and load modules
debug: using /etc/mail/spamassassin/init.pre for site rules init.pre
debug: config: read file /etc/mail/spamassassin/init.pre
debug: using /usr/share/spamassassin for default rules dir
debug: config: read file /usr/share/spamassassin/10_misc.cf
debug: config: read file /usr/share/spamassassin/20_anti_ratware.cf
debug: config: read file /usr/share/spamassassin/20_body_tests.cf
debug: config: read file /usr/share/spamassassin/20_compensate.cf
debug: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf
debug: config: read file /usr/share/spamassassin/20_drugs.cf
debug: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf
debug: config: read file /usr/share/spamassassin/20_head_tests.cf
debug: config: read file /usr/share/spamassassin/20_html_tests.cf
debug: config: read file /usr/share/spamassassin/20_meta_tests.cf
debug: config: read file /usr/share/spamassassin/20_phrases.cf
debug: config: read file /usr/share/spamassassin/20_porn.cf
debug: config: read file /usr/share/spamassassin/20_ratware.cf
debug: config: read file /usr/share/spamassassin/20_uri_tests.cf
debug: config: read file /usr/share/spamassassin/23_bayes.cf
debug: config: read file /usr/share/spamassassin/25_body_tests_es.cf
debug: config: read file /usr/share/spamassassin/25_hashcash.cf
debug: config: read file /usr/share/spamassassin/25_spf.cf
debug: config: read file /usr/share/spamassassin/25_uribl.cf
debug: config: read file /usr/share/spamassassin/30_text_de.cf
debug: config: read file /usr/share/spamassassin/30_text_fr.cf
debug: config: read file /usr/share/spamassassin/30_text_nl.cf
debug: config: read file /usr/share/spamassassin/30_text_pl.cf
debug: config: read file /usr/share/spamassassin/50_scores.cf
debug: config: read file /usr/share/spamassassin/60_whitelist.cf
debug: using /etc/mail/spamassassin for site rules dir
debug: config: read file /etc/mail/spamassassin/misc.cf
debug: config: read file /etc/mail/spamassassin/settings.cf
debug: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
debug: plugin: registered Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83b4ba4)
debug: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
debug: plugin: registered Mail::SpamAssassin::Plugin::Hashcash=HASH(0x8e08a5c)
debug: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC
debug: plugin: 

Re: can't get SQL AWL working in 3.0.0

2004-09-26 Thread Michael Parker
On Sun, Sep 26, 2004 at 09:27:04PM +, Daniel M. Drucker wrote:
 
 I have the following /etc/mail/spamassassin/settings.cf:
 
 =
 user_scores_dsn DBI:mysql:spamassassin:localhost
 user_scores_sql_usernamemail
 user_scores_sql_passwordmypassword
 
 bayes_store_module  Mail::SpamAssassin::BayesStore::SQL
 bayes_sql_dsn   DBI:mysql:spamassassin:localhost
 bayes_sql_username  mail
 bayes_sql_password  mypassword
 
 user_awl_dsnDBI:mysql:spamassassin:localhost
 user_awl_sql_username   mail
 user_awl_sql_password   mypassword
 =
 
 SA 3.0.0 is picking up the user scores and bayes from SQL without any
 problems, but it seems to be ignoring the awl settings completely --
 it is still writing to /root/.spamassassin/auto-whitelist.

[ SNIP ]
 
 Can anyone tell me what I'm doing wrong?
 


Go back and read sql/README.awl, pay special attention to the second
paragraph.

Michael


Re: can't get SQL AWL working in 3.0.0

2004-09-26 Thread Daniel M. Drucker
On 2004-09-26, Michael Parker [EMAIL PROTECTED] wrote:
 Go back and read sql/README.awl, pay special attention to the second
 paragraph.

I bow my head in humble shame.

Thank you! 


-- 
Daniel Drucker / [EMAIL PROTECTED]



RE: can't get SQL AWL working in 3.0.0

2004-09-26 Thread Dallas L. Engelken
 
 Can anyone tell me what I'm doing wrong?
 

See the line

 debug: auto-whitelist (db-based):
[EMAIL PROTECTED]|ip=none scores 0/0

And then see the man...

   auto_whitelist_factory module (default:
Mail::SpamAssassin::DBBasedAddrList)
   Select alternative whitelist factory module.


My factory looks like this..

[EMAIL PROTECTED] spamassassin]# grep factory local.cf
auto_whitelist_factory  Mail::SpamAssassin::SQLBasedAddrList

D