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! :)
I've been running Postfix+Procmail+Amavisd-new+SA for a while now...
Since setting up the server, I've set up
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
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
$sa_tag2_level_deflt = 6.3; # add 'spam detected' headers at that level
$sa_kill_level_deflt = $sa_tag2_level_deflt; #
Gary V said the following on 1/22/2006 6:10 PM:
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
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:
'INSERT INTO msgs
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
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
The defaults are in file amavisd, search for: %sql_clause = (...
Seems like I
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
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
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?
-BEGIN PGP SIGNED MESSAGE-
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
-BEGIN PGP SIGNED MESSAGE-
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).
Mail list logo