SLQ Bayes

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

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

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