[AMaViS-user] spamassassin, bayes and sql

This is a discussion on [AMaViS-user] spamassassin, bayes and sql within the Amavis User forums, part of the Anti-Spam and Anti-Virus Related Forums category; Hello, I've set up spamassasin with sql support for the bayes database. Through the webmail interface(squirrelmail) i've ...


Go Back   Usenet Forums > Anti-Spam and Anti-Virus Related Forums > Amavis User

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 11-16-2005
Alexandru Ionica
 
Posts: n/a
Default [AMaViS-user] spamassassin, bayes and sql

Hello,
I've set up spamassasin with sql support for the bayes database.
Through the webmail interface(squirrelmail) i've installed a plugin that
adds 2 buttons, so every user can mark a masses as spam or spam(if theese
were detected wrong). Those buttons do something like this: sa-learn
--spam (or ham) -u someuser@maildomain.org followed by the message.
If i would do something like: sa-learn -u amavis i'm afraid of malicious
users how will mark all ther spam as ham and all their ham as spam .. and
ruin the bayes system.

My question/problem is: how can i make amavisd-new(or spamassasin, think
the later is the one) read first the settings(spam & ham count, hashes,
etc. from the amavis user records in the sql db, and after that from the
users records(if he has any). Because now a malicious user will ruin only
bayes only for his mailbox.
As i see now, from amavisd debug-sa , sa is using userid 2 , wich is for
amavis in the sqldb(mysql> select * from bayes_vars where id=3D2; returns
the line with amavis).
I've read the spamassassasin docs and didn't see or noticed something to
help me.
Any ideeas ?

[8909] dbg: bayes: database connection established
[8909] dbg: bayes: found bayes db version 3
[8909] dbg: bayes: Using userid: 2
[8909] dbg: bayes: corpus size: nspam =3D 233, nham =3D 1738
[8909] dbg: bayes: tok_get_all: token count: 339
[8909] dbg: bayes: score =3D 0.993757103920321
[8909] dbg: bayes: DB expiry: tokens in DB: 68450, Expiry max size:
150000, Oldest atime: 1058995800, Newest atime: 1132131487, Last expire:
0, Current time: 1132131488
[8909] dbg: rules: ran eval rule BAYES_99 =3D=3D=3D=3D=3D=3D> got hit




-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
Register for a JBoss Training Course. Free Certification Exam
for All Training Attendees Through End of 2005. For more info visit:
http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:28 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0