SLQ Bayes

[Steve Freegard]

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!