We don’t use encryption. I'm not sure what went wrong w/
the database. However, it was pretty large. That is part of
the reason why we purged those tables. CPU usage was 100%
from the mysql daemon. We had millions of records in most of
the tables that we purged (I've previously mentioned which
tables those were).
We currently process around 100,000 messages per day. I am
wondering whether maia scales well to this size, and whether
it can handle it. Any thoughts?? Others doing even more than
this??
Due to the problems that I've had with Maia, I'm seriously
considering outsourcing our filtering, or purchasing an
IronPort appliance. However, if we could actually prevent
some of the problems that we've had (like this one), then it
would be nice to keep it. Any thoughts from others on this
one??
Thanks in advance,
--
Doug Mortensen
Impala Networks
Network Consultant
-----Original Message-----
From: Administrator [mailto:admin cobatco.com]
Sent: Monday, October 22, 2007 2:56 PM
To: Douglas Mortensen
Cc: Jeffrey Schilperoord; maia-usersrenaissoft.com
Subject: Re: [Maia-users] Bayes database messed up after
purging some tables
delete from bayes_seen and bayes_tokens should reset your
bayes
database. The real question is what made it become
corrupted in the
first place. Do you use encryption in the database and have
you checked
your key permissions? This has happened to us in the past
on a SLES10
server when SuSEconfig's permission module runs.
Best
Douglas Mortensen wrote:
>
> Jeffrey,
>
>
>
> I really appreciate your help. Since I’ve disabled
the bayes scoring,
> things seem to be going ok for now, but I still want to
see if we can
> get this fixed, and turn the bayes back on. Since, it
seems that I’ve
> got some time here, I’m going to hold off on doing
anything yet, and
> wait to see if we get any other advice coming through
the mailing list.
>
>
>
> Thanks again,
>
> --
>
> *Doug Mortensen*
>
> Impala Networks
>
> Network Consultant
>
>
>
> *From Jeffrey
Schilperoord [mailto:jeffreyschilperoord.org]
> *Sent Monday,
October 22, 2007 2:41 PM
> *To Douglas
Mortensen; maia-usersrenaissoft.com
> *Subject RE:
[Maia-users] Bayes database messed up after purging
> some tables
>
>
>
> Hi Douglas,
>
>
>
> My First intention would be to flush the bayes_seen and
the
> bayes_token tables again. Considering the situation we
where in when
> we first flushed the tables maybe something went
completely wrong when
> it started filling those empty tables again after the
first
> flush(with mysql acting very weird and all). I would
also flush the
> maia_sa_rules table and after that run the
load-sa-rules.pl script
> just to make sure your rules in the database are ok too
(off course
> this has nothing to do with the scoring)
>
>
>
> In my opinion it’s ok to flush the bayes_seen and
bayes_token table if
> you want to train bayes from the beginning. Correct me
if I’m wrong
> someone?
>
>
>
> Greetings,
>
>
>
> Jeffrey Schilperoord
>
>
>
> *Van
maia-users-bouncesrenaissoft.com
> [mailto:maia-users-bouncesrenaissoft.com] *Namens
*Douglas Mortensen
> *Verzonden maandag 22
oktober 2007 18:11
> *Aan
maia-usersrenaissoft.com
> *Onderwerp
[Maia-users] Bayes database messed up after purging some
> tables
>
>
>
> I had a problem last week w/ my Maia database, and so I
purged some
> tables that I didn’t think were critical. After doing
so, my bayes
> filtering began blocking a bunch of messages that
shouldn’t be
> blocked. It is just scoring tons of messages with the
bayes_99 rule.
> In fact, it looks like every message is being scored by
that rule. So
> this is obviously a big problem. I have temporarily
disabled bayes
> filtering in spamassassin (use_bayes 0 in local.cf).
>
>
>
> The tables that were purged were:
>
>
>
> awl
>
> bayes_seen
>
> bayes_token
>
> maia_sa_rules_triggered
>
> maia_stats
>
>
>
> Can anyone tell me what is actually happening, as well
as the correct
> way to fix it?
>
>
>
> Thanks in advance for your help,
>
> __
>
> Douglas Mortensen
>
> Network Consultant^
>
> *Impala Networks*
>
> ^
>
> CCNA, MCP, MSSBS, A+, Linux+
>
>
>
>
------------------------------------------------------------
------------
>
> _______________________________________________
> Maia-users mailing list
> Maia-usersrenaissoft.com
> http://www.renaissoft.com/mailman/listinfo/maia-users
>
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
