Hi,
I've few question about the behavior of Bayes and SQL. Before the
questions, i've followed this tutorial
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html that
should be the same thing of this:
http://spamassassin.apache.org/full/3.0.x/dist/sql/README.bayes, my db
are
pm...@email.it wrote:
Hi,
I've few question about the behavior of Bayes and SQL. Before the
questions, i've followed this tutorial
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html that
should be the same thing of this:
pm...@email.it wrote:
Hi,
I've few question about the behavior of Bayes and SQL. Before the
questions, i've followed this tutorial
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html that
should be the same thing of this:
On Wed, July 22, 2009 04:18, Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
sa-learn
--
xpoint
Benny Pedersen wrote:
On Wed, July 22, 2009 04:18, Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
sa-learn
That's not exactly a web front-end Benny.
Benny Pedersen wrote:
On Wed, July 22, 2009 04:18, Luis Daniel Lucio Quiroz
wrote:
Is there a good frontend that letme to admin SQL Bayes?
sa-learn
That's not exactly a web front-end Benny.
But it leads the OP to the corrent path in his search.
OP does NOT want a GUI for SQL
On Wed, July 22, 2009 14:20, Matt Kettler wrote:
Benny Pedersen wrote:
On Wed, July 22, 2009 04:18, Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
sa-learn
That's not exactly a web front-end Benny.
so ?
http://www.directadmin.com/forum
Le mercredi 22 juillet 2009 07:40:28, Benny Pedersen a écrit :
On Wed, July 22, 2009 14:20, Matt Kettler wrote:
Benny Pedersen wrote:
On Wed, July 22, 2009 04:18, Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
sa-learn
That's not exactly
On Wed, July 22, 2009 16:00, Luis Daniel Lucio Quiroz wrote:
The if that BAYES is a probabilistic method, therefore it does not matter who
uses, it will work. Pitagoras wont mistake jejeje
google dovecot antispam, then in imap one can move spam to a spam folder and
dovecot then call sa-learn
Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
mysql-admin?
What are you looking to do as far as administering bayes? (particularly
what would you be doing more than once every 2-3 years)
Le mardi 21 juillet 2009 22:11:39, Matt Kettler a écrit :
Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
mysql-admin?
What are you looking to do as far as administering bayes? (particularly
what would you be doing more than once every 2-3 years
Luis Daniel Lucio Quiroz wrote:
Le mardi 21 juillet 2009 22:11:39, Matt Kettler a écrit :
Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
mysql-admin?
What are you looking to do as far as administering bayes? (particularly
what would
Matt Kettler wrote:
Luis Daniel Lucio Quiroz wrote:
Le mardi 21 juillet 2009 22:11:39, Matt Kettler a écrit :
Luis Daniel Lucio Quiroz wrote:
Is there a good frontend that letme to admin SQL Bayes?
mysql-admin?
What are you looking to do as far as administering bayes
Tom Allison wrote:
I'm trying to initialize a database for Bayes from perl (DIY).
I took the advice of others and removed much of this approach and just decide to
try running Mail::SpamAssassin as is and let it create the database entry for
the specified user.
It simply will not create an
Tom Allison writes:
Additionally, when I first run spamd -q -D there is something a little
strange. It actually tries to score one email. There aren't any. It's
not connected to anything. It also tries to score it as the user I'm
starting as. Is this a normal startup process to just dummy
I'm trying to initialize a database for Bayes from perl (DIY).
Using Test::More as a start I tried:
can_ok('Mail::SpamAssassin::BayesStore', ('tie_db_readonly'));
my $to = 'tom';
my $spamtest = Mail::SpamAssassin-new( {username = $to, debug='all'} );
isa_ok($spamtest, 'Mail::SpamAssassin');
SA-3.1.5
I recently moved from individual incoming machine Bayes DBs
to a central MySql Bayes that all incoming servers connect
to. I noticed that running 'sa-learn --force-expire'
on the DB server worked the first time but has done nothing
in the last few weeks. A --dump magic shows the
On Fri, 22 Sep 2006, Tim Rosmus wrote:
|# I then did a 'sa-learn --dump magic' on the DB server and
|# also on one of the incoming servers. Why the different
|# numbers? (I use bayes_sql_override_username on all)
|#
Disregard, found the problem. A slight spelling error for
the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greetings...
On the Maia Mailguard mailing list, we have encountered a number of folks
(myself included) that are seeing some slow performance in the bayes storage
when using mysql (innodb engine), taking anywhere from .5 to 10 seconds to
(memory, etc), and any other good information that might help
make a better guess.
Gary Wayne Smith
-Original Message-
From: David Morton [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 2:28 PM
To: users@spamassassin.apache.org
Subject: slow sql bayes store
-BEGIN PGP
]
Sent: Thursday, August 10, 2006 2:28 PM
To: users@spamassassin.apache.org
Subject: slow sql bayes store
Greetings...
On the Maia Mailguard mailing list, we have encountered a number of
folks
(myself included) that are seeing some slow performance in the bayes
storage
when using mysql (innodb
as well.
-Original Message-
From: David Morton [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 7:39 PM
To: Gary W. Smith
Cc: users@spamassassin.apache.org
Subject: Re: slow sql bayes store
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This has been seen on a variety of systems
Michael Monnerie writes:
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
So my DSN had to contain dbname= and host=, separated via
semicolon.
Nobody of the devs got anything to say on that? I'm not sure if I did
everything correct (at least it works now), at least the
On Donnerstag, 22. Juni 2006 02:35 Mark Martinec wrote:
On Thursday June 22 2006 01:25, Michael Monnerie wrote:
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
So my DSN had to contain dbname= and host=, separated via
semicolon.
Nobody of the devs got anything to say on that?
Michael Monnerie wrote:
On Donnerstag, 22. Juni 2006 02:35 Mark Martinec wrote:
On Thursday June 22 2006 01:25, Michael Monnerie wrote:
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
So my DSN had to contain dbname= and host=, separated via
semicolon.
Nobody of the devs got anything
On Donnerstag, 22. Juni 2006 15:15 Michael Parker wrote:
Actually, please re-read the sql/README.bayes file, it specifies
where to find the connection string stuff for Pg.
Yes I did. It reads:
bayes_sql_dsn DBI:driver:database:hostname[:port]
bayes_sql_username
Michael Monnerie wrote:
I would say the docs are not correct, at least to one who is not
specialist in configuring DBI. I found the info on the DBI man page,
but still the docs here are wrong.
You are not reading completely, especially the part that says:
For an example of connection to
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
So my DSN had to contain dbname= and host=, separated via
semicolon.
Nobody of the devs got anything to say on that? I'm not sure if I did
everything correct (at least it works now), at least the documentation
is not
On Thursday June 22 2006 01:25, Michael Monnerie wrote:
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
So my DSN had to contain dbname= and host=, separated via
semicolon.
Nobody of the devs got anything to say on that? I'm not sure if I did
everything correct (at least it works
Hello, I'm wondering why I need different settings than written anywhere
in the documentation. For the first time I tried to use bayes via SQL,
and read the README and the wiki. They suggest this in local.cf:
bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
bayes_sql_dsn
On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote:
Hello, I'm wondering why I need different settings than written
anywhere in the documentation. For the first time I tried to use
bayes via SQL, and read the README and the wiki. They suggest this in
local.cf:
bayes_store_module
On 3/21/06, Duane Hill [EMAIL PROTECTED] wrote:
Dell PowerEdge 2550, Dual P4 2.4 ghz, 2 gig ram, hardware raid5, 4x74
gig 10,000 rpm scsi III drives from Seagate. Hopefully I can get the
ram upgraded to 4 gig eventually.
I'm not using anything quite as powerful, but innodb has made a
Peraps a better option would be to have a users table and setup
referential integrity. Of course that would do no good for MyISAM, but
using that isn't really any better than using BDB, so...
On Tue, Mar 21, 2006 at 09:26:30AM -0800, [EMAIL PROTECTED] wrote:
Duane Hill wrote:
delete from
On 3/21/06, Andrew Donkin [EMAIL PROTECTED] wrote:
Jason, if you haven't moved to innodb already, try SHOW PROCESSLIST
in mysql. Do you have many threads locked on SELECT FROM
bayes_token and INSERT INTO bayes_token?
Yep, that's it completely.
I had about 100 threads locked, so I am
.
-Original Message-
From: Jason Frisvold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 6:54 AM
To: users@spamassassin.apache.org
Subject: SQL Bayes
Greetings,
I'm looking for some fine tuning help. It seems that we are currently
I/O limited due to the massive load
Greetings,
I'm looking for some fine tuning help. It seems that we are currently
I/O limited due to the massive load spamassassin puts on the bayes
database. The database is currently about 3.5 Gig, including indices.
I have a few questions regarding the operation of Bayes.
1) How effective
Jason Frisvold wrote:
1) How effective is it really? Will users likely notice a huge change
if bayes was disabled?
We use a site wide bayes DB, and it's very effective for us. As an
example, last week our bayes DB got corrupted and we lost that aspect of
scoring for about 3 hours. Our help
On 3/21/06, Gary W. Smith [EMAIL PROTECTED] wrote:
It appears that you are user per user bayes. If you have a large number
of users and performance is becoming an issue you might want to change
over to site wide bayes and disable per user.
How are you training Bayes? Do you allow the users
On Tuesday, March 21, 2006 at 2:54:19 PM, [EMAIL PROTECTED] confabulated:
Greetings,
I'm looking for some fine tuning help. It seems that we are currently
I/O limited due to the massive load spamassassin puts on the bayes
database. The database is currently about 3.5 Gig, including
Duane Hill wrote:
delete from bayes_token where id = (select id from bayes_vars
where username = '[EMAIL PROTECTED]');
...
delete from bayes_seen where id = (select id from bayes_vars where
username = '[EMAIL PROTECTED]');
delete from bayes_expire where id = (select id
On Tuesday, March 21, 2006 at 5:26:30 PM, [EMAIL PROTECTED] confabulated:
Duane Hill wrote:
delete from bayes_token where id = (select id from bayes_vars
where username = '[EMAIL PROTECTED]');
...
delete from bayes_seen where id = (select id from bayes_vars where
username =
Duane Hill wrote:
Matthew.van.Eerde wrote:
delete from bayes_(token|seen|expire) where id in
(select id from bayes_vars where username = '[EMAIL PROTECTED]');
Cool! I haven't gotten too deep yet into MySQL. I knew there was a
shorter way of doing this. Thanks for the tip!
On Tuesday, March 21, 2006 at 5:34:31 PM, [EMAIL PROTECTED] confabulated:
Duane Hill wrote:
Matthew.van.Eerde wrote:
delete from bayes_(token|seen|expire) where id in
(select id from bayes_vars where username = '[EMAIL PROTECTED]');
Cool! I haven't gotten too deep yet into MySQL. I knew
The absolute best way to remove users DB entries is this way:
sa-learn -u [EMAIL PROTECTED] --clear
Michael
On Tuesday, March 21, 2006 at 6:03:57 PM, [EMAIL PROTECTED] confabulated:
The absolute best way to remove users DB entries is this way:
sa-learn -u [EMAIL PROTECTED] --clear
Thanks. I never gave it a thought before now.
--
This message is made of 100% recycled electrons.
On 3/21/06, Duane Hill [EMAIL PROTECTED] wrote:
I am using a per-user configuration here and my DB size currently is
sitting at just over 10 gig. All of the tables within the MySQL schema
are using the InnoDB storage instead of the MyISAM. I am also using
the SA plugin for caching
On Tuesday, March 21, 2006 at 8:51:09 PM, [EMAIL PROTECTED] confabulated:
On 3/21/06, Duane Hill [EMAIL PROTECTED] wrote:
I am using a per-user configuration here and my DB size currently is
sitting at just over 10 gig. All of the tables within the MySQL schema
are using the InnoDB
Duane Hill has:
per-user [...] just over 10 gig [...] InnoDB [...]
http://wiki.apache.org/spamassassin/DBIPlugin [...] bayes_vars table
has 14,102 rows
Jason Frisvold:
I'll have to give innodb a try.. :) Thanks for the tip...
Jason, if you haven't moved to innodb already, try SHOW
Hi,
I'm looking for how to tell sa-learn to learn against a per-user Bayes
database (in MySQL) instead of learning sitewide.
I swear I saw this was going to be in 3.0.2; some kind of change to
sa-learn... but a couple hours searching around didn't turn up anything
helpful. If I missed
email builder wrote:
Hi,
I'm looking for how to tell sa-learn to learn against a per-user Bayes
database (in MySQL) instead of learning sitewide.
I swear I saw this was going to be in 3.0.2; some kind of change to
sa-learn... but a couple hours searching around didn't turn up anything
helpful.
that user's sql-bayes stuff.
Looking at the POD docs on the SA website does not show this option, but I do
see it in the tarball. I thought the docs on the site would be the most up
to date guess not. Thanks much!
__
Do You Yahoo!?
Tired
I'm looking for how to tell sa-learn to learn against a per-user Bayes
database (in MySQL) instead of learning sitewide.
As in manually training the database?
sa-learn -u username
Can anyone tell me how to verify that a message was learnt correctly for the
right user? Running with
Now that I got SQL Bayes storage running with MySQL, I thought I'd do a
quick and dirty performance comparison on sa-learn.
I restored backups of 100,512 spam, and 61,653 ham from my current bayes
database, then tried sa-learn --spam --mbox of 72 recent spams from my
spam folder.
Here
On Tue, Jan 25, 2005 at 08:50:41AM -0800, Morris Jones wrote:
Now that I got SQL Bayes storage running with MySQL, I thought I'd do a
quick and dirty performance comparison on sa-learn.
http://wiki.apache.org/spamassassin/BayesBenchmark
Michael
pgpLYtApUp2qA.pgp
Description: PGP signature
On Sun, Nov 28, 2004 at 11:59:26PM -0400, Marc G. Fournier wrote:
My local.cf has the following setup:
user_scores_dsn
dbi:Pg:dbname=centraldb;host=maildb.hub.org;port=5432
user_scores_sql_usernamepgsql
user_scores_sql_table userpref
bayes_sql_dsn
d'oh ... I searched through the man page looking for 'sql' settings for
both, and found the dns/username stuff, but missed the others :( working
now, thanks ...
On Sun, 28 Nov 2004, Michael Parker wrote:
On Sun, Nov 28, 2004 at 11:59:26PM -0400, Marc G. Fournier wrote:
My local.cf has the
While I can see the advantage of keeping awl and prefs in a sql
database, I can't see an advantage to keeping bayes data in a sql db.
Can someone point out an advantage? Would there be any disadvantage in
keeping everything except bayese in sql?
--
Robin Lynn Frank
Director of Operations
On Thursday 30 September 2004 18:05, Robin Lynn Frank wrote:
While I can see the advantage of keeping awl and prefs in a sql
database, I can't see an advantage to keeping bayes data in a sql db.
Can someone point out an advantage? Would there be any disadvantage in
keeping everything except
58 matches
Mail list logo