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:
> http://spamassassin.apache.org/full/3.0.x/dist/sql
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:
http://spamassassin.apache.org/full/3.0.x/dist/sql/README
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 upda
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-lear
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
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 ?
> 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 Benn
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.
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
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?
>>>>
&
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?
>>
>> Wh
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
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)
Is there a good frontend that letme to admin SQL Bayes?
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 du
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
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');
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 bayes_sql_over
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 sa
re with ours 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 var
gt; 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
>>
> Greetings...
>
> On the Maia Mail
(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
-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
store/update
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
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:
> 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 t
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
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 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
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 correct/mislead
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
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 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
ma
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
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 P
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 Inno
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 cachin
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."
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 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 MySQ
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!
bayes_(tok
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
>> us
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
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 indi
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 use
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 d
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 is
.
> -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'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? Runni
spamd does with the
username to work against 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!
_
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.
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 someth
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
De
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 fo
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 follo
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
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
dbi:Pg:dbname=centraldb;host=maildb.hub.org;port=5432
bayes_sql
On Thu, 30 Sep 2004 18:42:59 +0200
Sune Kloppenborg Jeppesen <[EMAIL PROTECTED]> wrote:
> 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.
>
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 exc
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
Paradi
61 matches
Mail list logo
