SpamAssassin/Amavis/MySQL... was: Re: [AMaViS-user] Too memory hungry!

2006-01-09 Thread Glenn Sieb
Martin Svensson said the following on 1/9/2006 5:44 AM: Remove the big evil rules and move the Bayes DB to a Mysql database and amavisd/SA will really perform! :) Some questions... I've been running Postfix+Procmail+Amavisd-new+SA for a while now... Since setting up the server, I've set up

Re: [AMaViS-user] SpamAssassin/Amavis/MySQL Cont'd--the SPF/NJABL/SORBS debacle..

2006-01-12 Thread Glenn Sieb
Clifton Royston said the following on 1/12/2006 2:52 PM: How are you submitting mail? Via SMTP, how else (grin). Seriously, though--via Thunderbird on my desktop, which is not the server in question (that sits in a basement about 40 minutes away in a bandwidth collective where it's lived

[AMaViS-user] Question about Amavisd-New and spam delivery/quarantining...

2006-01-22 Thread Glenn Sieb
Ok. I'm running Amavisd-New 2.3.3.. just upgraded to SQL lookups all the good nifty stuff. $sa_tag_level_deflt = 5.0; # add spam info headers if at, or above that level $sa_tag2_level_deflt = 6.3; # add 'spam detected' headers at that level $sa_kill_level_deflt = $sa_tag2_level_deflt; #

Re: [AMaViS-user] Question about Amavisd-New and spam delivery/quarantining...

2006-01-22 Thread Glenn Sieb
Gary V said the following on 1/22/2006 6:10 PM: Glenn wrote: If you are using SQL, these default settings will only be used for recipients you have not yet added to SQL, or for those assigned a policy where the corresponding SQL fields are NULL. Ok. Thanks, Gary--unfortunately, the setup in

Re: [AMaViS-user] 8 bind variables when 9 are needed?

2006-05-18 Thread Glenn Sieb
Mark Martinec said the following on 5/18/2006 9:00 PM: Actually, line 153 within package Amavis::Out::SQL::Log is: (much snippage of helpful stuff) Thanks for your help, Mark.. so if I read this correctly, I have to change ins_rcp and ins_msg to be: 'ins_msg' = 'INSERT INTO msgs

Re: [AMaViS-user] 8 bind variables when 9 are needed?

2006-05-18 Thread Glenn Sieb
Mark Martinec said the following on 5/18/2006 8:52 PM: ALTER TABLE msgs ADD quar_loc varchar(255) DEFAULT ''; The following clause should preferably be executed to take advantage of the ON DELETE CASCADE: ALTER TABLE msgrcpt ADD FOREIGN KEY (mail_id) REFERENCES

Re: [AMaViS-user] 8 bind variables when 9 are needed?

2006-05-19 Thread Glenn Sieb
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

Re: [AMaViS-user] Plus addressing headache...

2006-08-30 Thread Glenn Sieb
Anders Norrbring said the following on 8/30/2006 4:34 AM: I saw the new feature of plus addressing and of course got a bit excited. For a little while, at least. Hey Anders... Just curious, but do you have: recipient_delimiter = + present in your postfix main.cf file? If not, you'd need to

[AMaViS-user] Please help--Amavis is stuck :-/

2008-08-05 Thread Glenn Sieb
Hello! I have about 2000 emails in queue, all saying: (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=37705-01-2, sql-enter FAILED: sql exec: err=16, S1000, DBD::mysql::st bind_param failed: Illegal parameter number at (eval 99) line 164, GEN18 line 24. (in reply to end of

Re: [AMaViS-user] swap_pager_getswapspace failed.

2009-07-07 Thread Glenn Sieb
Michael Scheidell said the following on 7/2/09 9:56 AM: Something borked in your installation. If these pid's are amavisd pid's, something wrong. You running the official spam assassin ports of everything? Sa, dependencies? amavisd? Dependencies? Or did you do a CPAN thing? Looks like

[AMaViS-user] Whitelisting/Blacklisting?

2010-12-04 Thread Glenn Sieb
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello! Running: FreeBSD-8.0-RELEASE amavisd-new-2.6.4_8,1 squirrelmail-1.4.21 amavisnewsql-0.8 So, I've been running this for a while. There were some minor bugs in the amavisnewsql plugin for SM that I fixed (involving extracting the spam score

Re: [AMaViS-user] Whitelisting/Blacklisting?

2010-12-17 Thread Glenn Sieb
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/15/10 7:31 PM, Mark Martinec wrote: The USER_IN_WHITELIST comes from SpamAssassin. It has nothing to do with amavisd black/whitelisting mechanism. *nod* Gotcha. :) Thanks for the log and the database (sent offlist). This explains. Thank