SQL settings & Deprecated rulesets?

[Codger <li...@pmbx.net>]

OK, I've successfully transitioned from 2.63 to 3.0.2 but I have two 
questions:

1. The sql users database doesn't seem to be used though it was working 
fine in 2.63. I have the following configuration in local.cf. Is there 
a plugin or other setting that I need to make this work? (I'm using 
CGSPA and not spamd by the way in CommuniGate Pro if that helps. Don't 
think it should make any difference.)

allow_user_rules 1
user_scores_dsn DBI:mysql:spamassassin:localhost:3306
user_scores_sql_username _mysqlusername_
user_scores_sql_password _mysqlpass_

2. I have these old rulesets but I can't find the previous download 
page a comprehensive list anywhere of the ones that are deprecated by 
version 3.0.2 and I want to eliminate duplication. Which are absolutely 
deprecated and which are recommended for continued use? (The asterisks 
are the ones that I understand shouldn't be used with 3.0.2.)

70_SARE_Adult.cf.bak
70_SARE_Genlsubj0.cf.bak
70_SARE_Header0.cf.bak
70_SARE_Random.cf.bak
70_SARE_SPOOF.cf.bak
71_SARE_Redirect_pre3.cf.bak
72_SARE_BML.cf.bak
99_FVGT_Tripwire.cf.bak
99_OBFU_drugs.cf.bak
99_SARE_Fraud.cf.bak
  99_SARE_OEM.cf
* antidrug.cf.bak
backhair.cf.bak
* bigevil.cf.bak
bogus-virus-warnings.cf.bak
* chickenpox.cf.bak
evilnumbers.cf.bak
ratware.cf.bak
useless.cf.bak
weeds.cf.bak

Re: SQL settings & Deprecated rulesets?

[Robert Menschel <Ro...@Menschel.net>]

Hello Codger,

Sunday, February 27, 2005, 7:30:47 AM, you wrote:

C> 2. I have these old rulesets but I can't find the previous download
C> page a comprehensive list anywhere of the ones that are deprecated by
C> version 3.0.2 and I want to eliminate duplication. Which are absolutely
C> deprecated and which are recommended for continued use? (The asterisks
C> are the ones that I understand shouldn't be used with 3.0.2.)

C> 70_SARE_Adult.cf.bak
C> 70_SARE_Genlsubj0.cf.bak
C> 70_SARE_Header0.cf.bak
If you have those two you probably also want html0 and uri0.
C> 70_SARE_Random.cf.bak
C> 70_SARE_SPOOF.cf.bak
C> 71_SARE_Redirect_pre3.cf.bak
If you're now on 3.0, you want 72_sare_redirect_post3.0.0.cf
C> 72_SARE_BML.cf.bak
Incomplete name -- that's 72_sare_bml_post25x.cf.
C> 99_FVGT_Tripwire.cf.bak
Better: 88_FVGT_Tripwire.cf
C> 99_OBFU_drugs.cf.bak
Discontinue.
C> 99_SARE_Fraud.cf.bak
99_sare_fraud_post25x.cf?
C>   99_SARE_OEM.cf
Replace with 70_sare_oem.cf
C> * antidrug.cf.bak
C> backhair.cf.bak
C> * bigevil.cf.bak
C> bogus-virus-warnings.cf.bak
C> * chickenpox.cf.bak
C> evilnumbers.cf.bak
C> ratware.cf.bak
Discontinued. Incorporated into header/html/uri files.
C> useless.cf.bak
Discontinued -- incorporated into the HTML family
C> weeds.cf.bak

Bob Menschel



-- 
Best regards,
 Robert                            mailto:Robert@Menschel.net

Re[2]: SQL settings & Deprecated rulesets?

[Robert Menschel <Ro...@Menschel.net>]

Hello Loren,

Sunday, February 27, 2005, 7:37:58 PM, you wrote:

LW> Also, you show header0 and gensubj0.  Almost always you would also
LW> want the "1" version of these rulesets.  The "0" version mostly
LW> just sets up stuff used by the other sets, I believe.

Not quite.  genlsubj0, header0, html0, uri0 all contain rules that hit
spam (10 or more in a single mass-check) and do not hit any ham.

Their matching files 1 (genlsubj1, header1, etc) contain rules that
either hit fewer spam (ie: might not be worth the resources) or hit
some ham (but with S/O better than 90%).

Bob Menschel

Re: SQL settings & Deprecated rulesets?

[Loren Wilton <lw...@earthlink.net>]

Check the SARE page for the various rulesets to see if any have been
depreciated for 3.0.  I don't believe any of the ones you have listed have
been, but it is worht a check.

That said: you have some ANCIENT rulesets there that have been updated
several times and have new names.  I don't believe that we have any rulesets
now with numbers above 70.

Also, you show header0 and gensubj0.  Almost always you would also want the
"1" version of these rulesets.  The "0" version mostly just sets up stuff
used by the other sets, I believe.

> 70_SARE_Adult.cf.bak
> 70_SARE_Genlsubj0.cf.bak
> 70_SARE_Header0.cf.bak
> 70_SARE_Random.cf.bak
> 70_SARE_SPOOF.cf.bak
> 71_SARE_Redirect_pre3.cf.bak
> 72_SARE_BML.cf.bak
> 99_FVGT_Tripwire.cf.bak
> 99_OBFU_drugs.cf.bak
> 99_SARE_Fraud.cf.bak
>   99_SARE_OEM.cf

Antidrug is in 3.0

> * antidrug.cf.bak
> backhair.cf.bak

Dump bigevil!  Turn on the net rules instead.

> * bigevil.cf.bak
> bogus-virus-warnings.cf.bak
> * chickenpox.cf.bak

Evilnumbers can be useful if you don't have net rules running, but the net
tests will generally do better.

> evilnumbers.cf.bak

Some of the ratware stuff is probably in 3.0.  Also, there is some in SARE
rulesets, such as Random and Specific.

I think (though I'm not positive) that random and useless are old
depreciated rulesets.

> ratware.cf.bak
> useless.cf.bak
> weeds.cf.bak

Backhair, bogus-virus-warnings (which may have been updated since your
version), chickenpox, tripwire, and weeds can all still be useful rulesets,
even they haven't been updated in ages.

        Loren