SLQ Bayes

[Peter Russell]

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

OK Thanks. But note. That the exact same Database produces a different 
results about the amount fo ham or spam depending on where you launch 
the lint from.

IN MailScanner debug or mailwatch debug it says 36 nspams from shell 
account as root it shows 19000 nspam.

We store no mail on the gateway, this is a agteway from Exchange and Domino.

I still have the text dumps of the original bayes DBs.

I will persevere with looking at MYSQL permissions.

thanks
Pete

Dhawal Doshy wrote:
> Peter Russell wrote:
> 
>>>>
>>>
>>> Here 'localhost' ought to be changed to the server_name that is 
>>> hosting your database (make sure the server_name is resolvable either 
>>> via dns or /etc/hosts), unless the database and SA are on the same 
>>> server.
>>>
>>> bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>>> bayes_sql_dsn DBI:mysql:sa_bayes:localhost <== change this parameter
>>> bayes_sql_username sa_user
>>> bayes_sql_password sa_password
>>>
>>> Also what does a MailScanner debug for SA have to report?
>>>
>>> - dhawal
>>
>>
>>
>> That output is from DB and MailScanner on the same machine. I had 
>> already tried using the machine name and the fqdn.
>>
>>  From MaiLScanner debug i get the following.
>>
>> debug: bayes: Database connection established
>> debug: bayes: found bayes db version 3
>> debug: bayes: Using userid: 4
> 
> 
> ** This is the likely problem **
> 
>> debug: bayes: Not available for scanning, only 36 spam(s) in Bayes DB 
>> < 200
> 
> ****
> 
>>
>> When using the root from the shell i get I am using the same 
>> spam.assassin.prefs.conf because i have 
>> /etc/mail/spamassassin/local.cf symlinked to 
>> /etc/MailScanner/spam.assassin.prefs.conf
>>
>>
>> debug: bayes: Using username: root
>> debug: bayes: Database connection established
>> debug: bayes: found bayes db version 3
>> debug: bayes: Using userid: 6
>> <snip>
>>
>> debug: running uri tests; score so far=0.126
>> debug: bayes corpus size: nspam = 19137, nham = 35279
>>
> 
> You could probably try the backup / restore once again OR your next 
> option is sa-learn..
> 
> Take all your ham (regular non-spam mail)
> sa-learn --ham -p /path/to/spam.assassin.prefs.conf --mbox ham.mbox
> 
> Take all your spam
> sa-learn --spam -p /path/to/spam.assassin.prefs.conf --mbox spam.mbox
> 
> The above commands vary slightly if you are using Maildirs
> 
> - dhawal
> 
> ------------------------ MailScanner list ------------------------
> To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> 'leave mailscanner' in the body of the email.
> Before posting, read the Wiki (http://wiki.mailscanner.info/) and
> the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
> 
> Support MailScanner development - buy the book off the website!
> 
> 
> 

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!