SLQ Bayes

[Dhawal Doshy]

    [ 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. ]

Thanks Steve for the excellent insight, i have amended the wiki accordingly.

Do have a look at the wiki entry if you can spare some time.
http://wiki.mailscanner.info/doku.php?id=documentation:anti_spam:spamassassin:bayes:sql

- dhawal

Pete Russell wrote:
> Thank you fixed it instantly. Working beautifully now.
> 
> Much appreciated.
> 
> Pete
> 
> Steve Freegard wrote:
> 
>> Hi Pete,
>>
>> You need to add the line: 'bayes_sql_override_username root' to
>> spam.assassin.pref.conf as SpamAssassin tracks bayes per user in the
>> same database (similar to having the bayes files in the users home
>> directory) so if you run sa-learn as postfix you'll get different
>> results - this will also cause problems if you try and learn anything
>> through MailWatch.
>>
>> You can manually 'see' which user you imported your files based bayes
>> data into by connecting to the database that you created and running:
>>
>> mysql> SELECT id, username, spam_count, ham_count, token_count FROM 
>> bayes_vars;
>> +----+----------+------------+-----------+-------------+
>> | id | username | spam_count | ham_count | token_count |
>> +----+----------+------------+-----------+-------------+
>> |  2 | root     |     190707 |    168166 |      124113 |
>> |  3 | apache   |          0 |         0 |           0 |
>> +----+----------+------------+-----------+-------------+
>> 2 rows in set (0.02 sec)
>>
>> It's probably worth putting this into the wiki - I would recommend 
>> setting the override _before_ the old data is imported as it saves 
>> hassle later.
>>
>> Hope this helps.
>>
>> Kind regards,
>> Steve.
>>
>>
>> On Thu, 2005-06-09 at 11:52 +1000, Peter Russell wrote:
>>
>>> Dhawal Doshy wrote:
>>>
>>>> Peter Russell wrote:
>>>>
>>>>
>>>>> 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 fr
>>>
>>>
>>> OM b1om Exchange and
>>>
>>>>> Domino.
>>>>>
>>>>> I still have the text dumps of the original bayes DBs.
>>>>>
>>>>> I will persevere with looking at MYSQL permissions.
>>>>>
>>>>> thanks
>>>>> Pete
>>>>>
>>>>
>>>> From sql/README.bayes: If you do not see the following lines 
>>>> something is likely to be misconfigured
>>>>
>>>> debug: bayes: Database connection established
>>>> debug: bayes: Using username: <username>
>>>>
>>>> This being your case using MailScanner
>>>> > debug: bayes: Database connection established
>>>> > debug: bayes: found bayes db version 3
>>>> > debug: bayes: Using userid: 4
>>>> > debug: bayes: Not available for scanning, only 36 spam(s) in Bayes 
>>>> DB < 200
>>>>
>>>> MailScanner doesn't seem to be using the BayesSQL as mentioned in 
>>>> the sa.prefs.conf, IS mysql (and associated perl dbi/dbd libraries) 
>>>> available to the user MS in running under?
>>>>
>>>
>>> Yeah when i run as root is works great when i log in as postfix (or 
>>> use the mailscanner debug) it doesnt work. I can connect to the 
>>> database using the credentials in the sa.prefs file sa_user and 
>>> localhost from the shell.

------------------------ 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!