Hope this helps:

# mysql -V
mysql Ver 14.12 Distrib 5.0.44, for pc-linux-gnu (i686) using readline 4.3

It would be nice if it was a mysql problem, those are usually easy
enough to fix, but I couldn't find any bugs related to what I'm seeing,
though I could certainly have missed something.

Leveau Stanislas wrote:
> what is your mysql version?
>
>> 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=/var/lib/mysql/mysql.sock
>> user_scores_sql_username spamassassin
>> user_scores_sql_password ***
>> # Using SpamAssassin Auto-Whitelists With An SQL Database
>> use_auto_whitelist 1
>> auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
>> user_awl_dsn
>> DBI:mysql:spamassassin:mysql_socket=/var/lib/mysql/mysql.sock
>> user_awl_sql_username spamassassin
>> user_awl_sql_password ***
>> user_awl_sql_table awl
>>
>> # Using A SQL Database for Bayesian Storage Module
>> use_bayes 1
>> use_bayes_rules 1
>> bayes_auto_learn 1
>> bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>> bayes_sql_dsn
>> DBI:mysql:spamassassin:mysql_socket=/var/lib/mysql/mysql.sock
>> bayes_sql_username spamassassin
>> bayes_sql_password ***
>> bayes_min_ham_num 100
>> bayes_min_spam_num 100
>> bayes_learn_during_report 1
>> bayes_expiry_max_db_size 180000
>> bayes_auto_expire 0
>> bayes_journal_max_size 102400
>> bayes_learn_to_journal 0
>> bayes_use_hapaxes 1
>> bayes_sql_override_username spamassassin
>>
>> add_header all BayesScore _BAYES_
>> add_header all TokenSummary _TOKENSUMMARY_
>> add_header all Bayestc _BAYESTC_
>> add_header all Bayestcleanred _BAYESTCLEARNED_
>> add_header all bayestcspammy _BAYESTCSPAMMY_
>> add_header all bayestchammy _BAYESTCHAMMY_
>> add_header all bayestop5hammytokens _HAMMYTOKENS(5)_
>> add_header all bayestop5spammytokens _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 CHARSET_FARAWAY 6.0
>> score CHARSET_FARAWAY_HEADER 6.0
>> # How many hits before a message is considered spam.
>> required_score 5.00
>> # Text to prepend to subject if rewrite_subject is used
>> rewrite_header Subject [SPAM]
>> # Encapsulate spam in an attachment
>> report_safe 0
>> # Enable or disable network checks
>> skip_rbl_checks 1
>> # Mail using locales used in these country codes will not be marked
>> # as being possibly spam in a foreign language.
>> ok_locales 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
>>>>> bayes_sql_override_username but I have
>>>>> "bayes_sql_override_username spamassassin " in my config, does
>>>>> 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
>>>>> short test, and took out the bayes_sql_override_username and it
>>>>> wasn't calling. When I did the use spamassassin; select * from
>>>>> bayes_vars; I did get a list of people, but they have very few
>>>>> tokens, in the order of 1 or 2 which looks to me like those
>>>>> tokens were created when I was tinkering and removed the
>>>>> sql_override_username, otherwise everything is put into the
>>>>> spamassassin user which has a few hundred thousand tokens in it
>>>>> 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 = 214240, nham = 138319
>>>> [21631] dbg: bayes: tok_get_all: token count: 21
>>>> [21631] dbg: bayes: score = 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 ======> got hit (1)
>>>> [21631] dbg: check:
>>>> tests=BAYES_00,MISSING_DATE,MISSING_HEADERS,MISSIN G_SUBJECT,NO_RECEIVED,NO_RELAYS
>>>> I am using Mysql as database.
>>>>
>>>> Tschau
>>>> Alex
>>>
>>>
>>>

>
>
>


--
--
Mitchell Hudson
Systems Administrator
Front Gate Solutions
1711 S Congress Ave
Austin, TX 78704
P: 512-674-9337
C: 512-587-0918
F: 512-499-0440
Mitchell@FrontGateSolutions.com