[AMaViS-user] Question about Amavisd-New and spam delivery/quarantining...
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; # triggers spam evasive actions $sa_dsn_cutoff_level = 30.0; Now, I know that, in Theory (that wonderful place where almost anything is possible, which is right next door to Practice!), doing the $sa_dsn_cutoff_level should drop any spam that scores over 30, yet I still get spam delivery for that spam that scores over 30 as well as it going into the nifty user-level quarantine that was set up with Squirrelmail's Amavisdnewsql plugin. So, right now, I currently have set the following (just bits pieces, unless someone really wants to see my whole .conf file..): $final_virus_destiny = D_DISCARD; $final_banned_destiny = D_BOUNCE; $final_spam_destiny = D_PASS; # subject to $sa_dsn_cutoff_level $final_bad_header_destiny = D_PASS; So, if I change $final_spam_destiny = D_DISCARD, does this mean that any spam that's scored from 1.0-29.9 will be delivered, or will it be dropped as well? If it's delivered, how do I make it so it *only* goes in the quarantine, and not delivered to the user's inbox? And, are these good levels to use? What do other people use or recommend? I guess what I'm roundabout-asking how to make sure I'm doing is: 1) Any email with a level of 5 or greater--have info headers added. 2) Any email with a level of 6.3 or higher--be tagged as spam. 3) Any email with a level of 6.4-29.9 be quarantined. 4) Any email with a level of 30.0 be discarded. #'s 1 and 2 are working. 3 and 4 are the ones I need some help with. Thanks in advance! 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 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Question about Amavisd-New and spam delivery/quarantining...
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 the SQM plugin didn't talk a whole heck of a lot about actually doing the SQL setup in Amavisd-New. I've asked on the squirrelmail-plugins list to see if someone can show me what they've got set, so I can compare. http://www200.pair.com/mecham/spam/amavisd-settings.html Thank you--this helped! :) And thanks for the rest of your reply--it's definitely given me things to mull over while reading over my config files. :) 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 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Question about Amavisd-New and spam delivery/quarantining...
Glenn wrote: 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 the SQM plugin didn't talk a whole heck of a lot about actually doing the SQL setup in Amavisd-New. I've asked on the squirrelmail-plugins list to see if someone can show me what they've got set, so I can compare. http://www200.pair.com/mecham/spam/amavisd-settings.html Thank you--this helped! :) And thanks for the rest of your reply--it's definitely given me things to mull over while reading over my config files. :) Best, --Glenn I did some testing where I configured a system to quarantine spam to SQL. I added and configured the spam_quarantine_cutoff_level field to the policy table and found the setting did control the level at which spam was no longer quarantined (as expected). I then removed that field and configured the $sa_quarantine_cutoff_level in amavisd.conf. This also worked. Gary V --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
[AMaViS-user] MySQL changes in amavisd-new from 2.2.0 to 2.3.3
Well, I'm trying to get some modification to work in 2.3.3 so I'm hoping someone familiar with amavisd-new and MySQL can assist. MySQL is not one of my strong points and I didn't do the original patches and the person who did isn't around to assist anymore. This is what I know original 2.2.0: $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr' . ' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)' . ' AND (mailaddr.email IN (%k))' . ' ORDER BY mailaddr.priority DESC'; modified 2.2.0: $sql_select_white_black_list = 'SELECT wblist.wb FROM wblist,mailaddr,users' . ' WHERE (users.id=?)' . ' AND (wblist.rid=users.amavisd_user_id)' . ' AND (wblist.sid=mailaddr.id)' . ' AND (mailaddr.email IN (%k))' . ' ORDER BY mailaddr.priority DESC'; In 2.3.3 the changes are different as shown from the original 2.2.0 so I guessed at it but it didn't work so I was wondering if someone could offer some help. original 2.3.3: $sql_select_white_black_list = 'SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id'. ' WHERE (wblist.rid=?)' . ' AND (mailaddr.email IN (%k))'. ' ORDER BY mailaddr.priority DESC'; modified 2.3.3: (guessed) $sql_select_white_black_list = 'SELECT wblist.wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id'. . ' WHERE (users.id=?)' . ' AND (wblist.rid=users.amavisd_user_id)' . ' AND (wblist.sid=mailaddr.id)' . ' AND (mailaddr.email IN (%k))' . ' ORDER BY mailaddr.priority DESC'; -- Dale --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnkkid=103432bid=230486dat=121642 ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/