Hi,
As I recall, this machine ran for a while without running
process-quarantine.pl.... I am thinking that you need to
process the
quarantine to remove LOTS of mail.... If it's offline, then
why not just
start up process-quarantine.pl and let it run for a while...
If you do not
run process-quarantine.pl --learn --report it will run
faster...
Also, there is a setting in /etc/maia.conf that limits
the
process-quarantine.pl to 5 messages at a go... If you become
the amavis
user and run process-quarantine.pl from the command line,
you should see
progress reporting where it is processing mail in batches of
5... Do you
see that? If so, then just let it run until it is done...
and then be
sure to add a line to the amavis user crontab like this:
0 * * * *
/var/amavisd/maia/scripts/process-quarantine.pl --learn
--report 1> /dev/null
Dave
************************************************************
*************
On Wed, 10 Oct 2007, Rick Zeman wrote:
> 2GB, it's not into the swap at all, and vmstat looks
good. 1.73ghz xeon
> with software raid 1 SATA drives.
>
> --
> Rick Zeman
> Manager of Information Technology
> Melwood Horticultural Training Center
> 301.599.4574 - HelpDesk
> 301.599.4560 - MyDesk
> http://www.melwood.org
>
> >>> David Sims <dpsims dpsims.com> 10/10/2007 12:34 PM >>>
> Hi,
>
> How much memory does the machine have?? At least 512
and probably 1 Gb
> would be good....
>
> Dave
>
************************************************************
*************
> On Wed, 10 Oct 2007, Rick Zeman wrote:
>
> > Well....yes and no. It cures the immediate
problem (the jacked high
> > utilization), but running quarantine.pl will still
never finish;
> mysqld
> > eventually grinds to a halt. The server isn't
even online now, so
> > nothing's being added to the maia.db. So, that
means that something
> is
> > fundamentally hosed outside of those tables. What
I'm not
> understanding
> > is what messages (at that point) the perl script
is actually
> processing
> > because the implication from you is that they get
dropped with the
> tables
> > (but remember, I'm not a dba).
> >
> > Anyone think of any other options besides nuking
the maia db and
> > reimporting its schema? I'd really hate to lose
the users and their
> links
> > (we have multiple domains, and some people have up
to 4 addresses they
> > receive on).
> >
> > Thanks!
> >
> > --
> > Rick Zeman
> > Manager of Information Technology
> > Melwood Horticultural Training Center
> > 301.599.4574 - HelpDesk
> > 301.599.4560 - MyDesk
> > http://www.melwood.org
> >
> > >>> Erik Weber <twiztar gmail.com> 10/4/2007 9:07 AM >>>
> > Rick Zeman wrote:
> > > Erik:
> > >
> > > Beautiful! Thank you so much. It was rather
interesting to be
> > entering
> > > the sql commands in one window and then
seeing the utilization
> plummet
> > in
> > > another.
> >
> > Does that mean it worked? If so, great!
> >
> > You should try to report a few messages, since
spamassassin won't use
> > bayes until it has 200 (of each type) tokens,
unless you tell it
> > otherwise.
> >
> > --
> > Erik Weber
> > _______________________________________________
> > Maia-users mailing list
> > Maia-users renaissoft.com
> > http://www.renaissoft.com/mailman/listinfo/maia-users
> > _______________________________________________
> > Maia-users mailing list
> > Maia-users renaissoft.com
> > http://www.renaissoft.com/mailman/listinfo/maia-users
> >
> _______________________________________________
> Maia-users mailing list
> Maia-users renaissoft.com
> http://www.renaissoft.com/mailman/listinfo/maia-users
>
_______________________________________________
Maia-users mailing list
Maia-users renaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|