On Tue, 2006-10-31 at 23:41 +0100, Casper Pedersen wrote:
> Silly question, have you made sure that the
username/password have the
> right rights to do what is required?
If that were the problem, then amavisd wouldn't work at all
with or
without bayes enabled (unfortunately I know that because I
have dealt
with that before )-:
> >
> You have 661165 rows in the table!! - Mine was fine
with +1mill rows
> (did some house cleaning and got it below 100.000), but
I've see that
> MySQL sometimes choke (don't ask me why), make a backup
and clear out
> the table, and then see - just an idea, not sure if it
would work.
I might have to resort to trying that. I just wish I could
be sure it
would work before I throw away all the work that my users
have done (of
course I won't tell them if I do 
This also begs the question of why I never see a problem
when I run
SpamAssassin directly. It only happens when it is run via
amavisd.
>
> I followed this
> http://www200.pair.com/mecham/spam/fc4-spamassassin-
sql.html when I
> fixed my installation (way to many false positives) -
there might be a
> hint or two.
Thanks for the pointer, I'll check it out.
> monitor the box to see what it is which takes
> so long time....
Good idea, I'm just not sure how to accomplish it. During
the hangs,
there is really very little resource consumption on the
system as shown
by things like "top", so I'm pretty sure the
problem is on the database
side, not the scanner side.
--Greg
_______________________________________________
Maia-users mailing list
Maia-users renaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|