This message is in MIME format.

--=_6or1d7rrsphc
Content-Type: text/plain;
charset=ISO-8859-1;
DelSp="Yes";
format="flowed"
Content-Description: Version texte brut du message
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable


My conf for an old mysql version

bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStore=
::SQL
bayes_sql_dsn=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0DBI:mysql:spam:localhost

for a recent mysql version

bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStore=
::MYSQL
bayes_sql_dsn=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0DBI:mysql:spam:localhost

> Sure, I'll repaste the bayes portion, and include the rest of the file
> for good measure. Thanks again!
>
> # SpamAssassin config file for version 3.2x
> # Loading SpamAssassin User Preferences From An SQL Database
> user_scores_dsn
> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock
> user_scores_sql_username=A0 =A0 =A0 spamassassin
> user_scores_sql_password=A0 =A0 =A0 ***
> # Using SpamAssassin Auto-Whitelists With An SQL Database
> use_auto_whitelist=A0 =A0 =A0 =A0 =A0 =A0 1
> auto_whitelist_factory=A0 =A0 =A0 =A0 Mail::SpamAssassin::SQLBasedAddrList
> user_awl_dsn
> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock
> user_awl_sql_username=A0 =A0 =A0 =A0 =A0spamassassin
> user_awl_sql_password=A0 =A0 =A0 =A0 =A0***
> user_awl_sql_table=A0 =A0 =A0 =A0 =A0 =A0 awl
>
> # Using A SQL Database for Bayesian Storage Module
> use_bayes=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01
> use_bayes_rules=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01
> bayes_auto_learn=A0 =A0 =A0 =A0 =A0 =A0 =A0 1
> bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStore::=

SQL
> bayes_sql_dsn
> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock
> bayes_sql_username=A0 =A0 =A0 =A0 =A0 =A0 spamassassin
> bayes_sql_password=A0 =A0 =A0 =A0 =A0 =A0 ***
> bayes_min_ham_num=A0 =A0 =A0 =A0 =A0 =A0 =A0100
> bayes_min_spam_num=A0 =A0 =A0 =A0 =A0 =A0 100
> bayes_learn_during_report=A0 =A0 =A01
> bayes_expiry_max_db_size=A0 =A0 =A0 180000
> bayes_auto_expire=A0 =A0 =A0 =A0 =A0 =A0 =A00
> bayes_journal_max_size=A0 =A0 =A0 =A0 102400
> bayes_learn_to_journal=A0 =A0 =A0 =A0 0
> bayes_use_hapaxes=A0 =A0 =A0 =A0 =A0 =A0 =A01
> bayes_sql_override_username=A0 spamassassin
>
> add_header all BayesScore _BAYES_
> add_header all TokenSummary _TOKENSUMMARY_
> add_header all Bayestc _BAYESTC_
> add_header all Bayestcleanred=A0 _BAYESTCLEARNED_
> add_header all bayestcspammy _BAYESTCSPAMMY_
> add_header all bayestchammy=A0 _BAYESTCHAMMY_
> add_header all bayestop5hammytokens=A0 _HAMMYTOKENS(5)_
> add_header all bayestop5spammytokens=A0 _SPAMMYTOKENS(5)_
> score BODY_ENHANCEMENT 5.0
> score BODY_ENHANCEMENT2 5.0
> score DRUGS_ERECTILE 20.0
> score FB_CIALIS_LEO3 5.0
> score FRT_LEVITRA 5.0
> score FUZZY_CPILL 5.0
> score FUZZY_VPILL 5.0
> score SARE_ADULT2 5.0
> score SARE_SXLIFE 5.0
> score SARE_WEOFFER 5.0
> score FB_ADD_INCHES 5.0
> #score RCVD_IN_NJABL_DUL 2.9
> #score RAZOR2_CF_RANGE_51_100 1.5
> score DATE_IN_FUTURE_03_06 3.5
> score DATE_IN_FUTURE_06_12 2.5
> score=A0 CHARSET_FARAWAY 6.0
> score=A0 CHARSET_FARAWAY_HEADER 6.0
> # How many hits before a message is considered spam.
> required_score=A0 5.00
> # Text to prepend to subject if rewrite_subject is used
> rewrite_header Subject=A0 [SPAM]
> # Encapsulate spam in an attachment
> report_safe=A0 =A0 =A00
> # Enable or disable network checks
> skip_rbl_checks=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01
> # Mail using locales used in these country codes will not be marked
> # as being possibly spam in a foreign language.
> ok_locales=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all
> # All cusom directives may be added to
> /hsphere/local/config/mail/spamassassin/custom.cf
> include /hsphere/local/config/mail/spamassassin/custom.cf
>
>
> -- Mitch
>
>
>
> Leveau Stanislas wrote:
>> Hi
>>
>> Can you show us your spamassassin configuration : local.cf
>>
>> Thanks
>>
>>> Mitchell Hudson schrieb am 19.03.2008 18:18:
>>>
>>>> I have a few questions though, you said I am not using=A0 =A0
>>>> bayes_sql_override_username=A0 but I have=A0 =A0
>>>> "bayes_sql_override_username=A0 spamassassin " in my config, does=A0 =

=A0
>>>> that not count?
>>>
>>> I'm sorry, I overlooked that. Yes, in the configuration that you posted
>>> it was set. And I also told rubbish by claiming that you ran under the
>>> username root. SA reported the internal userid from the sql table, and
>>> that was probably the user 'spamassassin'.
>>>
>>>> As well I tried setting the min_ham and min_spam to 1 just for a=A0 =A0
>>>> short test, and took out the bayes_sql_override_username=A0 and it=A0 =

=A0
>>>> wasn't calling. When I did the use spamassassin; select * from=A0 =A0
>>>> bayes_vars; I did get a list of people, but they have very few=A0 =A0
>>>> tokens, in the order of 1 or 2 which looks to me like those=A0 =20
>>>> tokens=A0 were created when I was tinkering and removed the=A0 =A0
>>>> sql_override_username, otherwise everything is put into the=A0 =A0
>>>> spamassassin user which has a few hundred thousand tokens in it=A0 =A0
>>>> currently.
>>>
>>> Yes, that's a valid explanation. Sorry for the confusion from my part.
>>> But that leads us back to your question: "why it is not scoring?". Did
>>> you really found all bayes-related output from --lint? If I run a
>>> "spamassassin --lint -D 2>&1|grep -i bayes", I get more bayes-related
>>> output:
>>>
>>> [21631] dbg: plugin: loading Mail::SpamAssassin::Plugin::Bayes from @INC
>>> [21631] dbg: config: fixed relative path:
>>> /var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf
>>> [21631] dbg: config: using
>>> "/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf"
>>> for included file
>>> [21631] dbg: config: read file
>>> /var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf
>>> [21631] dbg: bayes: using username: mail
>>> [21631] dbg: bayes: database connection established
>>> [21631] dbg: bayes: found bayes db version 3
>>> [21631] dbg: bayes: Using userid: 2
>>> [21631] dbg: bayes: corpus size: nspam =3D 214240, nham =3D 138319
>>> [21631] dbg: bayes: tok_get_all: token count: 21
>>> [21631] dbg: bayes: score =3D 0.0020110638266459
>>> [21631] dbg: bayes: DB expiry: tokens in DB: 461680, Expiry max size:
>>> 500000, Oldest atime: 1203126859, Newest atime: 1205950517, Last
>>> expire: 1205444421, Current time: 1205950517
>>> [21631] dbg: rules: ran eval rule BAYES_00 =3D=3D=3D=3D=3D=3D> got hit (=

1)
>>> [21631] dbg: check:
>>> tests=3DBAYES_00,MISSING_DATE,MISSING_HEADERS,MISS ING_SUBJECT,NO_RECEIVE=

D,NO_RELAYS I am using Mysql as=A0 =20
>>> database.
>>>
>>> Tschau
>>> Alex

>>
>>
>>




--=_6or1d7rrsphc
Content-Type: text/html;
charset=ISO-8859-1
Content-Description: Version HTML du message
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable




My conf for an old mysql version



bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStore=
::SQL

bayes_sql_dsn=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0DBI:mysql:spam:localhost=




for a recent mysql version



bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStore=
::MySQL />
bayes_sql_dsn=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0DBI:mysql:spam:localhost=






> Sure, I'll repaste the bayes portion, and include the rest of the file<=
br
/>
> for good measure. Thanks again!

>

> # SpamAssassin config file for version 3.2x

> # Loading SpamAssassin User Preferences From An SQL Database

> user_scores_dsn

> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock

> user_scores_sql_username=A0 =A0 =A0 spamassassin

> user_scores_sql_password=A0 =A0 =A0 ***

> # Using SpamAssassin Auto-Whitelists With An SQL Database

> use_auto_whitelist=A0 =A0 =A0 =A0 =A0 =A0 1

> auto_whitelist_factory=A0 =A0 =A0 =A0 Mail::SpamAssassin::SQLBasedAddrL=
ist

> user_awl_dsn

> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock

> user_awl_sql_username=A0 =A0 =A0 =A0 =A0spamassassin

> user_awl_sql_password=A0 =A0 =A0 =A0 =A0***

> user_awl_sql_table=A0 =A0 =A0 =A0 =A0 =A0 awl

>

> # Using A SQL Database for Bayesian Storage Module

> use_bayes=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01

> use_bayes_rules=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01

> bayes_auto_learn=A0 =A0 =A0 =A0 =A0 =A0 =A0 1

> bayes_store_module=A0 =A0 =A0 =A0 =A0 =A0 Mail::SpamAssassin::BayesStor=
e::SQL

> bayes_sql_dsn

> DBI:mysql:spamassassin:mysql_socket=3D/var/lib/mysql/mysql.sock

> bayes_sql_username=A0 =A0 =A0 =A0 =A0 =A0 spamassassin

> bayes_sql_password=A0 =A0 =A0 =A0 =A0 =A0 ***

> bayes_min_ham_num=A0 =A0 =A0 =A0 =A0 =A0 =A0100

> bayes_min_spam_num=A0 =A0 =A0 =A0 =A0 =A0 100

> bayes_learn_during_report=A0 =A0 =A01

> bayes_expiry_max_db_size=A0 =A0 =A0 180000

> bayes_auto_expire=A0 =A0 =A0 =A0 =A0 =A0 =A00

> bayes_journal_max_size=A0 =A0 =A0 =A0 102400

> bayes_learn_to_journal=A0 =A0 =A0 =A0 0

> bayes_use_hapaxes=A0 =A0 =A0 =A0 =A0 =A0 =A01

> bayes_sql_override_username=A0 spamassassin

>

> add_header all BayesScore _BAYES_

> add_header all TokenSummary _TOKENSUMMARY_

> add_header all Bayestc _BAYESTC_

> add_header all Bayestcleanred=A0 _BAYESTCLEARNED_

> add_header all bayestcspammy _BAYESTCSPAMMY_

> add_header all bayestchammy=A0 _BAYESTCHAMMY_

> add_header all bayestop5hammytokens=A0 _HAMMYTOKENS(5)_

> add_header all bayestop5spammytokens=A0 _SPAMMYTOKENS(5)_

> score BODY_ENHANCEMENT 5.0

> score BODY_ENHANCEMENT2 5.0

> score DRUGS_ERECTILE 20.0

> score FB_CIALIS_LEO3 5.0

> score FRT_LEVITRA 5.0

> score FUZZY_CPILL 5.0

> score FUZZY_VPILL 5.0

> score SARE_ADULT2 5.0

> score SARE_SXLIFE 5.0

> score SARE_WEOFFER 5.0

> score FB_ADD_INCHES 5.0

> #score RCVD_IN_NJABL_DUL 2.9

> #score RAZOR2_CF_RANGE_51_100 1.5

> score DATE_IN_FUTURE_03_06 3.5

> score DATE_IN_FUTURE_06_12 2.5

> score=A0 CHARSET_FARAWAY 6.0

> score=A0 CHARSET_FARAWAY_HEADER 6.0

> # How many hits before a message is considered spam.

> required_score=A0 5.00

> # Text to prepend to subject if rewrite_subject is used

> rewrite_header Subject=A0 [SPAM]

> # Encapsulate spam in an attachment

> report_safe=A0 =A0 =A00

> # Enable or disable network checks

> skip_rbl_checks=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01

> # Mail using locales used in these country codes will not be marked
/>
> # as being possibly spam in a foreign language.

> ok_locales=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all

> # All cusom directives may be added to

> /hsphere/local/config/mail/spamassassin/custom.cf

> include /hsphere/local/config/mail/spamassassin/custom.cf

>

>

> -- Mitch

>

>

>

> Leveau Stanislas wrote:

>> Hi

>>

>> Can you show us your spamassassin configuration : local.cf

>>

>> Thanks

>>

>>> Mitchell Hudson schrieb am 19.03.2008 18:18:

>>>

>>>> I have a few questions though, you said I am not using=A0 =
=A0

>>>> bayes_sql_override_username=A0 but I have=A0 =A0

>>>> "bayes_sql_override_username=A0 spamassassin " in=
my
config, does=A0 =A0

>>>> that not count?

>>>

>>> I'm sorry, I overlooked that. Yes, in the configuration that yo=
u
posted

>>> it was set. And I also told rubbish by claiming that you ran un=
der
the

>>> username root. SA reported the internal userid from the sql tab=
le,
and

>>> that was probably the user 'spamassassin'.

>>>

>>>> As well I tried setting the min_ham and min_spam to 1 just =
for
a=A0 =A0

>>>> short test, and took out the bayes_sql_override_username=A0=
and
it=A0 =A0

>>>> wasn't calling. When I did the use spamassassin; select * f=
rom=A0
=A0

>>>> bayes_vars; I did get a list of people, but they have very =
few=A0
=A0

>>>> tokens, in the order of 1 or 2 which looks to me like those=
=A0


>>>> tokens=A0 were created when I was tinkering and removed the=
=A0 =A0 />
>>>> sql_override_username, otherwise everything is put into the=
=A0
=A0

>>>> spamassassin user which has a few hundred thousand tokens i=
n
it=A0 =A0

>>>> currently.

>>>

>>> Yes, that's a valid explanation. Sorry for the confusion from m=
y
part.

>>> But that leads us back to your question: "why it is not
scoring?". Did

>>> you really found all bayes-related output from --lint? If I run
a

>>> "spamassassin --lint -D 2>&1|grep -i bayes", I=
get
more bayes-related

>>> output:

>>>

>>> [21631] dbg: plugin: loading Mail::SpamAssassin::Plugin::Bayes =
from
@INC

>>> [21631] dbg: config: fixed relative path:

>>>
/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf

>>> [21631] dbg: config: using

>>>
"/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf&qu=
ot; />
>>> for included file

>>> [21631] dbg: config: read file

>>>
/var/lib/spamassassin/3.002004/updates_spamassassin_org/23_bayes.cf

>>> [21631] dbg: bayes: using username: mail

>>> [21631] dbg: bayes: database connection established

>>> [21631] dbg: bayes: found bayes db version 3

>>> [21631] dbg: bayes: Using userid: 2

>>> [21631] dbg: bayes: corpus size: nspam =3D 214240, nham =3D 138=
319 />
>>> [21631] dbg: bayes: tok_get_all: token count: 21

>>> [21631] dbg: bayes: score =3D 0.0020110638266459

>>> [21631] dbg: bayes: DB expiry: tokens in DB: 461680, Expiry max
size:

>>> 500000, Oldest atime: 1203126859, Newest atime: 1205950517, Las=
t />
>>> expire: 1205444421, Current time: 1205950517

>>> [21631] dbg: rules: ran eval rule BAYES_00 =3D=3D=3D=3D=3D=3D&g=
t; got hit
(1)

>>> [21631] dbg: check:

>>>
tests=3DBAYES_00,MISSING_DATE,MISSING_HEADERS,MISS ING_SUBJECT,NO_RECEIVED,NO=
_RELAYS
I am using Mysql as=A0

>>> database.

>>>

>>> Tschau

>>> Alex

>>

>>

>>




--=_6or1d7rrsphc--