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
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
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
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
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.
As for user purging, no, there is no user detection to process users
that are no longer in the system.
> --
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
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
32 matches
Mail list logo
