On 7/26/10 5:40 PM, Paul Hirose wrote:
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=5998
I just added a comment.
Hmm, I'm still on 5.0.77 (the basic RHEL5 repository version.) Do you know
which plugin?
the innodb plugin for mysql. supports compression on innodb databases, e
>> RHEL5.5, MySQL GA 5.0.77, MySQL Cluster 7.1.4b, 64bit, SpamAssassin 3.2.5
>> (but hoping to go to 3.3.1 soon.)
>> In short, I stumbled across:
>> http://www.clusterdb.com/mysql-cluster/how-can-a-database-be-in-memory-and-durable-at-the-same-time/
>> which
>> essentially shows how to create a
On 7/26/10 5:02 PM, Paul Hirose wrote:
RHEL5.5, MySQL GA 5.0.77, MySQL Cluster 7.1.4b, 64bit, SpamAssassin 3.2.5 (but
hoping to go to 3.3.1 soon.)
In short, I stumbled across:
http://www.clusterdb.com/mysql-cluster/how-can-a-database-be-in-memory-and-durable-at-the-same-time/
which essential
Hi,
>> Well, what's the missing 120 MB? The journal? Do a complete sync and
>> then delete it.
>
> Probably the signatures in bayes_seen - there's no mechanism for ageing
> them out.
And I assume that isn't a problem then?
>> "too big" is not an absolute figure. If you store 1-occurence tokens
>
On Mon, 29 Mar 2010 13:03:59 +0200
Kai Schaetzl wrote:
> Alex wrote on Sun, 28 Mar 2010 13:38:25 -0400:
>
> > I have a bayes db that's about 160MB with a 40MB token db on a
> > system with about 100k messages per day.
>
> Well, what's the missing 120 MB? The journal? Do a complete sync and
> th
Alex wrote on Sun, 28 Mar 2010 13:38:25 -0400:
> I have a bayes db that's about 160MB with a 40MB token db on a system
> with about 100k messages per day.
Well, what's the missing 120 MB? The journal? Do a complete sync and then
delete it.
I've just raised the max_db_size set
> to 1.1M tokens (
On Apr 21, 2008, at 8:40 AM, Chris St. Pierre wrote:
On Mon, 21 Apr 2008, Michael Parker wrote:
select * from bayes_vars;
...
2289 rows in set (0.00 sec)
What user do you run bayes under on your MXs?
I think you've found the issue. We run as spamd.
# sa-learn -u spamd --dump magic
0.00
On Mon, 21 Apr 2008, Michael Parker wrote:
select * from bayes_vars;
...
2289 rows in set (0.00 sec)
What user do you run bayes under on your MXs?
I think you've found the issue. We run as spamd.
# sa-learn -u spamd --dump magic
0.000 0 3 0 non-token data: bay
On Apr 21, 2008, at 8:17 AM, Chris St. Pierre wrote:
Consequently, my database is growing, apparently without bound.
Any ideas how I can get expiry to work properly again? (Hopefully
without completely dumping the database?)
select * from bayes_vars;
What user do you run bayes under on yo
got2go wrote:
> Hello all,
>
> I am trying to get Bayes working on CentoS 4.3 with Postfix, MailScanner,
> IMP (with Spam reporting feature).
>
Check your /etc/mail/spamassassin/mailscanner.cf. (if you don't have
one, your MailScanner is ancient)
If you've got this line:
bayes_path /var/spo
Ok it looks like using sa-learn created the databases fine even with
only 1 ham/spam...
I didn't even realize my reply's were not being sent to the thread I started...
Sorry!
Daniel Aquino wrote:
> > run these commands as the defang user.
>
> Would it be bad to use "root" because defang is not a real user..
"spamd" will not run as root. If you try it, it will switch to
"nobody".
You can deal with this two ways:
If your mail accounts are owned by real users on the s
Daniel Aquino wrote:
> I really don't know if I can extract emails from Outlook 2003 into a
> standard mbox format...
Maildir is the preferred format. You can extract emails from Outlook,
but Outlook and Exchange tend to rewrite portions of the message which
makes this less than ideal for SA's pu
Daniel Aquino wrote:
> > 1) What (exactly) did you do?
>
> # local.cf config file at this url
> http://pastie.caboo.se/60756
>
> > What user is SA running as? What are the permissions on the bayes
> > directory?
>
> drwx-- 2 defang defang 4096 2007-05-11 10:48
> /var/spool/MD-Databases/
Luis Hernán Otegui wrote:
> First, RTFM.
> Second, Google.
> Third, oh, well... You NEED to feed Bayes a significant amount of
> data, so it knows what is spam and waht is ham, due to the fact that
> the kind of spam and ham you receive is different from the ones I get
> on my servers. Then it will
First, RTFM.
Second, Google.
Third, oh, well... You NEED to feed Bayes a significant amount of
data, so it knows what is spam and waht is ham, due to the fact that
the kind of spam and ham you receive is different from the ones I get
on my servers. Then it will start auto learning on that basis. B
Daniel Aquino wrote:
> I setup Bayes and whitelist db paths in my local.cf
> The whitelist db created succesfully but the bayes_* db's did not...
More information please... Just saying that it doesn't work isn't very
helpful.
Before we can help you, we need the two basic pieces of information:
Have you trained the bayes database? Is this a fresh install? It needs
at least 200 spam and 200 ham messages to get it going. However, the
more ham and spam you can feed it, the better it will perform...
Luix
2007/5/11, Daniel Aquino <[EMAIL PROTECTED]>:
I setup Bayes and whitelist db paths i
- Original Message -
From: "Dave Koontz" <[EMAIL PROTECTED]>
To: "'spam mailling list'"
Sent: Saturday, February 17, 2007 9:30 AM
Subject: Re: Bayes db size
Is there a consensus on this need? I deal with the seen db issue by
scheduled deletio
Is there a consensus on this need? I deal with the seen db issue by
scheduled deletion of that file. That said, with SA becoming more and
more prominent all the time, I suspect the Average Joe will miss this
oddity until they wind up with a sluggish system, out of drive space or
other related is
ary 16, 2007 7:19 PM
> To: spam mailling list
> Subject: Re: Bayes db size
>
> On Fri, Feb 16, 2007 at 06:17:36PM -0600, Robert Nicholson wrote:
>> So you're saying that right now seen isn't capped like tokens right?
>
> seen has no max size nor expiry features.
&g
file gets large
very fast. I'd vote for auto expiry and maintenance on seen as well as AWL.
-Original Message-
From: Theo Van Dinter [mailto:[EMAIL PROTECTED]
Sent: Friday, February 16, 2007 7:19 PM
To: spam mailling list
Subject: Re: Bayes db size
On Fri, Feb 16, 2007 at 0
On Fri, Feb 16, 2007 at 06:45:51PM -0600, Robert Nicholson wrote:
> Well then I only care about tokens and not repeated emails can I
> disable seen?
You can't disable it, but you can delete it, as previously stated.
--
Randomly Selected Tagline:
54% of all statistics are made up. No, make tha
Well then I only care about tokens and not repeated emails can I
disable seen?
On Feb 16, 2007, at 6:19 PM, Theo Van Dinter wrote:
On Fri, Feb 16, 2007 at 06:17:36PM -0600, Robert Nicholson wrote:
So you're saying that right now seen isn't capped like tokens right?
seen has no max size nor
On Fri, Feb 16, 2007 at 06:17:36PM -0600, Robert Nicholson wrote:
> So you're saying that right now seen isn't capped like tokens right?
seen has no max size nor expiry features.
--
Randomly Selected Tagline:
"Like any French restaurant in America, it was overpriced, noisy, moody,
and would put
So you're saying that right now seen isn't capped like tokens right?
On Feb 16, 2007, at 5:45 PM, Theo Van Dinter wrote:
On Fri, Feb 16, 2007 at 05:42:13PM -0600, Robert Nicholson wrote:
Why then is my Bayes DB 20MEG in size right now if
=item bayes_expiry_max_db_size (default: 15
On Fri, Feb 16, 2007 at 05:42:13PM -0600, Robert Nicholson wrote:
> Why then is my Bayes DB 20MEG in size right now if
> =item bayes_expiry_max_db_size (default: 15)
That's in number of tokens, not physical size in bytes.
> 100,000 tokens, whichever has a larger value. 150,000 token
At 2007. january 14. 20.32 Theo Van Dinter wrote:
> http://issues.apache.org/SpamAssassin/show_bug.cgi?id=3563
well, afaik all my sa-learn instances run through procmail, having correctly
locked:
:0cw:/tmp/some.lock
|sa-learn --spam --no-sync --single
however this was happened, when procmail revei
On Sun, Jan 14, 2007 at 11:29:38AM +0100, Péntek Imre wrote:
> this output was generated by sa-learn:
> bayes: bayes db version 0 is not able to be used, aborting!
[...]
> So far this is the first and only time I saw this warning, and since no
> warnings like this displayed.
Sounds like:
http:/
On Sat, Dec 09, 2006 at 01:48:51PM +0100, Alex Handle wrote:
> I could disable the spamchecks in amavisd-new and invoke sa through
> maildrop.
> But i don't know if a per-user database would scale for 100,000 mailboxes?
IMO, Bayes will likely be ok if you use SQL (though your DB will be quite
a bi
Theo Van Dinter schrieb:
On Fri, Dec 08, 2006 at 09:44:04PM +0100, Alex Handle wrote:
postfix/mysql/nfs/amavisd-new/spamassassin and now we
Is it a bad idea to use a site wide bayes database or is it better
to use a per user database in this scenario?
Per user DBs will give you better results
On Fri, Dec 08, 2006 at 09:44:04PM +0100, Alex Handle wrote:
> postfix/mysql/nfs/amavisd-new/spamassassin and now we
>
> Is it a bad idea to use a site wide bayes database or is it better
> to use a per user database in this scenario?
Per user DBs will give you better results, but since you're ru
swap
out two of my 4 other 3.1.3 and upgrade those in a couple days after it
has ran for a while.
Gary Wayne Smith
> -Original Message-
> From: Nigel Frankcom [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 08, 2006 7:03 PM
> To: Gary W. Smith
> Subject: Re: RE: Bayes DB
om: Gary W. Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 2:23 PM
To: users@spamassassin.apache.org
Subject: RE: Bayes DB version issue 3.1.3 => 3.1.4
Okay, I have a little more information now. I run the same command that
sql.pm would run. It appears to be a collation issue.
th
-Original Message-
From: Gary W. Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 8:06 AM
To: Daryl C. W. O'Shea
Cc: users@spamassassin.apache.org
Subject: RE: Bayes DB version issue 3.1.3 => 3.1.4
Daryl,
Thanks for the info. I will update the .8. As for the
+---+
| variable | value |
+--+---+
| VERSION | 3 |
+--+---+
1 row in set (0.00 sec)
mysql>
-Original Message-
From: Daryl C. W. O'Shea [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 12:38 AM
To: Gary W. Smith
Cc: users@spamassassin.apache.o
On 8/8/2006 3:29 AM, Gary W. Smith wrote:
Hello,
I can’t remember smoking crack when copying the config files over but
anything’s possible.
I built out a new machine today and installed SA. We have a list of
CPAN modules that were installed (same list as from the 3.1.3 servers).
I copied
On Tue, Jun 27, 2006 at 10:50:03AM -0500, Larry Starr wrote:
> I don't believe that it is referring to the Spamassassin Version, but rather
> the version of "Berekly DB". Have you updated any packages lately?
Actually it is the SA DB version being referred to. v2 is for databases
in SA 2.6x, v
I don't believe that it is referring to the Spamassassin Version, but rather
the version of "Berekly DB". Have you updated any packages lately?
On Tuesday 27 June 2006 10:45, Bobby Johnson wrote:
> When I run sa-learn --dump or --sync, it tells me the database is
> version 2. This machine neve
I recently switched to using mysql bayes. I am getting a [1135] dbg:
bayes: unable to initialize database for root user, aborting! When I do
spamassassin -d --lint any idea what I need to change?
Best regards,
JD Smith
You possibly have not learned a message as root yet. As root, try this:
JD Smith wrote:
> I recently switched to using mysql bayes. I am getting a [1135] dbg:
> bayes: unable to initialize database for root user, aborting! When I do
> spamassassin -d --lint any idea what I need to change?
>
Its kind of a bad warning message. Bayes will not attempt to initialize
JD Smith writes:
I recently switched to using mysql bayes. I am getting a [1135] dbg:
bayes: unable to initialize database for root user, aborting! When I do
spamassassin -d --lint any idea what I need to change?
Try a "select id,username,spam_count,ham_count from bayes_vars" on your
bate
Roman Serbski wrote on Mon, 20 Jun 2005 14:55:56 +0600:
> 1. sa-learn --backup > db.txt (on old server)
since you transferred the complete db I don't see a reason to import and
export the data. This is like backing up your notebook at home, take the
notebook and backup with you in the car to wo
I suspect you wanted to perform a "sa-learn --sync" first. But I do not
know for sure.
{^_^}
- Original Message -
From: "Roman Serbski" <[EMAIL PROTECTED]>
Dear colleagues,
Could you please share the correct procedure for moving bayes database
from the server powered by SA 3.0.2 to anot
Asif Iqbal wrote:
> Hi All
>
> I see notes on using MySQL/PgSQL and other SQL database and migration
> from Berkeley DB to MySQL. I was wondering if anyone knows how to
> migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB)
> as the
> bayes DB.
>
> Thanks for any help/sug
Rick Macdougall wrote:
Asif Iqbal wrote:
Hi All
I see notes on using MySQL/PgSQL and other SQL database and migration
from Berkeley DB to MySQL. I was wondering if anyone knows how to
migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use
that (CDB) as the
bayes DB.
Thanks f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Asif Iqbal wrote:
> Hi All
>
> I see notes on using MySQL/PgSQL and other SQL database and
> migration from Berkeley DB to MySQL. I was wondering if anyone
> knows how to migrate to DAN's CDB from Berkeley DB for bayes DB. I
> like to use that (CDB) a
Asif Iqbal wrote:
Hi All
I see notes on using MySQL/PgSQL and other SQL database and migration
from Berkeley DB to MySQL. I was wondering if anyone knows how to
migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) as
the
bayes DB.
Thanks for any help/suggestion/tip
On Mon, May 30, 2005 at 07:18:31PM -0400, Asif Iqbal wrote:
> from Berkeley DB to MySQL. I was wondering if anyone knows how to
> migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB)
> as the
> bayes DB.
There's no native support for CDB, so you'd have to do up your own
Ba
Craig
best to install Spamassassin from source or CPAN. I've seen lots of
problems with the RPM based install. No specifically bayes but
--
Martin Hepworth
Snr Systems Administrator
Solid State Logic
Tel: +44 (0)1865 842300
Craig White wrote:
CentOS 3.4
# rpm -qa spamassassin
spamassassin-3.0
From: "Kai Schaetzl" <[EMAIL PROTECTED]>
> > in a degree I have set my SA score to be more or less equal with the
> > BAYES_99 score (around 8).
>
> Your BAYES_99 score is 8? I would never do this. General rule is that no
single
> rule should be able to mark a message as ham or spam. That cries fo
GRP Productions wrote on Fri, 18 Mar 2005 10:38:29 +0200:
> It seems SURBL is now enabled by default. It has also changed its name to
> URIDNSBL :-)
SURBL refers generally to those xx_SURBL rules and to URIDNSBL since the only
other distributed rules is SBL and SURBL started it all.
I do not
Thanks for the offer. You can send it to the email address I use for this
list,
or you could just send me an FTP URL for retrieval.
Sorry I did not find the time to do this, but I will try to send it during
the weekend.
Oh, yes. You need to have SURBL switched on via the init.pre (I think it's
GRP Productions wrote on Tue, 15 Mar 2005 01:12:53 +0200:
> >I have been trying to get something from CVS for several days now, no luck.
>
> Send me your email in private ([EMAIL PROTECTED]) to send it to you.
Thanks for the offer. You can send it to the email address I use for this list,
or
I have been trying to get something from CVS for several days now, no luck.
Send me your email in private ([EMAIL PROTECTED]) to send it to you.
Bayes needs constant training, but this doesn't mean it needs any manual
training. Once it's up and running and "well-greased" it should take care
of
its
GRP Productions wrote on Mon, 14 Mar 2005 03:41:40 +0200:
> Indeed, this is the CVS version :-)
I have been trying to get something from CVS for several days now, no luck.
> This is perhaps because I have been using only 'mistake-based' training (ie
> training only when false classificaiton ha
That's okay, the problem just is one cannot be sure how accurate it is.
Knowing
that you use MS would have been useful, anyway :-)
(BTW: my version of Mailwatch can't show this, do you use a CVS version?)
Indeed, this is the CVS version :-)
See the number of tokens, we have ten times yours with le
GRP Productions wrote on Mon, 14 Mar 2005 00:32:42 +0200:
> You are right, I am using MailWatch. I just posted this output to be easy
> for one to see the actual dates without having to convert.
That's okay, the problem just is one cannot be sure how accurate it is. Knowing
that you use MS woul
That is the output of --dump magic? I haven't ever seen it formatted that
nicely. I assume you skipped the first line, but there's also missing the
expire atime delta. So, where do you got this from? Not directly from
sa-learn
--dump magic I'd say. You are running SA thru some interface? You shoul
GRP Productions wrote on Sun, 13 Mar 2005 22:54:22 +0200:
> Perhaps I have not been clear enough. It's not only that the files' size is
> constant. I am pasting the output of dump magic,
That is the output of --dump magic? I haven't ever seen it formatted that
nicely. I assume you skipped the f
This doesn't prove anything. sa-learn --dump magic shows you what's inside.
Also, Bayes is not a checksum system like Razor, that's its strength. If
you
learn something to it that means that it extracts tokens (short pieces)
from
the message and adjusts its internal probability for them being ham
GRP Productions wrote on Sun, 13 Mar 2005 11:21:12 +0200:
> for some days now my bayesian DB does not seem to grow. Its size remains
> stable. It is read with no problems by SA 3.0.2, but nothing new is written.
> I send an email to me, it is classified as BAYES_50. I sa-learn it as spam,
> sen
Michael Parker wrote:
On Tue, Feb 08, 2005 at 05:28:51PM -0300, Matias Lopez Bergero wrote:
2) Throttle the calls to spamd to reduce lock contention.
Sorry to ask this again, but I'm not native English speaker :-P
Did you mean to increase the number of spamd children processes, like
spamd -m x? I
On Tue, Feb 08, 2005 at 05:28:51PM -0300, Matias Lopez Bergero wrote:
>
> >2) Throttle the calls to spamd to reduce lock contention.
>
> Sorry to ask this again, but I'm not native English speaker :-P
> Did you mean to increase the number of spamd children processes, like
> spamd -m x? I have cu
Michael Parker wrote:
On Tue, Feb 08, 2005 at 04:37:50PM -0300, Matias Lopez Bergero wrote:
I'm seeing a lot of messages about and version error in the bayes db in
my log file:
spamd[6562]: bayes: bayes db version 0 is not able to be used, aborting!
at /usr/lib/perl5/site_perl/5.8.0/Mail/SpamAss
On Tue, Feb 08, 2005 at 04:37:50PM -0300, Matias Lopez Bergero wrote:
> I'm seeing a lot of messages about and version error in the bayes db in
> my log file:
>
> spamd[6562]: bayes: bayes db version 0 is not able to be used, aborting!
> at /usr/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/BayesS
On Fri, 28 Jan 2005, Justin Mason stated:
> Rodney Green writes:
>> I'd like to copy the bayes db to the temporary mail server so it can
>> continue to be used and continue learning.
>>
>> Will I need to do some special export/import procedure or will I be
>> able to just copy the db files into th
On Fri, 28 Jan 2005 11:48:32 -0800, Justin Mason <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Rodney Green writes:
> > Hello,
> >
> > I'm setting up a temporary mail server so I can do some work on the
> > regular production machine, without interrupting serv
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rodney Green writes:
> Hello,
>
> I'm setting up a temporary mail server so I can do some work on the
> regular production machine, without interrupting service.
>
> I'd like to copy the bayes db to the temporary mail server so it can
> continue to
Hi Tim,
The script I sent you dumps the tokens out to a text file because SA
stores them in a Berkeley DB format. If you want to do it in place then
just have a look at the script and edit the appropriate values. If you
get really desperate then the two processes (encoding and decoding) are
essent
You sent three messages to the list in a row without indicating
if the earlier problems are solved or if the three are actually
connected. Don't you think that your problems are connected
somehow? You seem to have upgraded from SA 2.6x to 3.0. I assume
you either have a mixed setup now or you n
On Sat, Sep 25, 2004 at 12:59:57PM -0500, Jeremy M. Dolan wrote:
> Hi all. Hoping someone might be able to help me out here. Just
> upgraded from 2.6x to 3.0.0 this morning, and, though I followed the
> Bayes DB upgrade steps in the UPGRADE file to a T, my token names all
> seem to be garbage now.
m root to the
postfix user, but that's probably just something on my setup.
> -Original Message-
> From: Nichols, William [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 22, 2004 11:18 AM
> To: users@spamassassin.apache.org
> Subject: RE: bayes db problem
rg
Subject: Re: bayes db problem upgrade from 2.63 --> 3.0
Nichols, William wrote:
> Tried that as well before mailing the list - I am having a problem
with
> install DB_File
>
> version.c:30:16: db.h: No such file or directory
> make: *** [version.o] Error 1
> /usr/bin/make
rom: Nichols, William ci.redding.ca.us>
> Subject: RE: bayes db problem upgrade from 2.63 --> 3.0
> Newsgroups: gmane.mail.spam.spamassassin.general
> Date: Wed, 22 Sep 2004 10:39:40 +
>
> Tried that as well before mailing the list - I am having a problem
with
> install DB_Fil
Nichols, William wrote:
Tried that as well before mailing the list - I am having a problem with
install DB_File
version.c:30:16: db.h: No such file or directory
make: *** [version.o] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
ma
d bad status, install seems impossible
hmmm - any help?
-Original Message-
From: Rick Macdougall [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 10:35 AM
To: Nichols, William
Cc: users@spamassassin.apache.org
Subject: Re: bayes db problem upgrade from 2.63 --> 3.0
Nichols,
Nichols, William wrote:
I installed spamassassin (test box) from cpan over my existing SA 2.63
When I try to sa-learn –sync I get the following “bayes db version 2 is
not able to be used, aborting! at
/usr/lib/perl5/site_perl/5.8.3/Mail/SpamAssassin/BayesStore/DBM.pm line 160”
Same problem till
79 matches
Mail list logo
