Mark Martinec said the following on 5/19/2006 4:56 AM:
> I mistakenly pasted your 'ins_msg' instead of your 'ins_rcp'
> in my previous mail. That one that changed from 2.4.0-pre* to 2.4.0
> is 'ins_rcp'.
*nod* Gotcha!
> The defaults are in file amavisd, search for: %sql_clause = (...
> Seems like I forgot to update the amavisd.conf-default, which
> is perhaps what is bothering you, so the 'ins_rcp' and 'ins_quar'
> in amavisd.conf-default are wrong!
>
> The correct setting is the actual default setting as specified
> in file amavisd, and applies unless you modify %sql_clause explicitly
> in your amavisd.conf. So the correct relevant entries are:
*d'oh*! I hate when that happens! :-D
So, in theory, I can just comment out all those lines in my amavisd.conf
and be done with that.. gotcha!
> Depends on indexes present and the number of entries.
*blush* Um.. I've been running SQL lookups now for.. um.. about a year?
I'd never done those maintenance things.. and I host 20 virtual domains,
of which, one is a small-sized company that gets slammed with SPAM.
> Interestingly, moving the same logging database from MySQL to PostgreSQL
> reduced my weekly cleanup time from about 30 minutes to 30 seconds.
> Don't know why.
It's been my experience that Postgres can be better suited to certain
things. However, when I was setting up the server in 2001, everyone
tended to still code for MySQL, so I'd just gone that route out of
expedience.
However, I've no complaints, the system runs fine--lest we get into a
Postgres vs MySQL war.. ;-)
Anywho, thanks for all your help, Mark! The errors are gone.. :-D
Best,
--Glenn
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
~Benjamin Franklin, Historical Review of Pennsylvania, 1759
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
