Re: [AMaViS-user] Plus addressing headache...
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 turn that on, and then reload postfix. If it is on, do you have more than one postfix server that these mails are traveling through? Best, --Glenn - 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 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] Please help--Amavis is stuck :-/
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, line 24. (in reply to end of DATA command)) I can send a (sanitized) amavisd.conf if that helps. I've gone through the mysql tweaks that RELEASE_NOTES said.. :-/ I'm going to try sending this from my real account, but since incoming mail is bottlenecked, please cc me at rainbear at gmail dot com Thank you! Running: Amavisd-New 2.6.1,1 on FreeBSD 7.0 with Postfix 2.5.1_2,1 Best, --Glenn -- ...destination is merely a byproduct of the journey --Eric Hansen - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ ___ 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] swap_pager_getswapspace failed.
Running AMaViSd-new 2.6.3 (it was 2.6.1 until today--upgrading to 2.6.3 did not fix the issue), FreeBSD 7.0-RELEASE, perl 5.8.8. Yesterday, my machine up and started having these issues (copied latest crash): (The getswapspace error repeats oh.. 6703 times total. I am cutting 6702 of them to save space:) Jul 1 20:51:01 caduceus kernel: swap_pager_getswapspace(12): failed (It always ends with this line (varying PIDs of course:) Jul 1 20:51:01 caduceus kernel: pid 36486 (perl), uid 2020, was killed: out of swap space Now... I have a machine with 4G of RAM, and 12G of swap space. (output of freecolor:) total used free sharedbuffers cached Mem: 4086 3737348 0 0 8 Swap:12288 11014 1273 Total: 16374 = ( 14752 (used) + 1630 (free)) Here's the output of top when it gets ready to crash: Last pid: 49047; load averages: 0.39, 0.44, 0.40up 0+05:01:13 21:03:12 251 processes: 2 running, 239 sleeping, 1 zombie, 9 waiting CPU states: 3.9% user, 0.0% nice, 1.9% system, 0.2% interrupt, 94.0% idle Mem: 3240M Active, 343M Inact, 326M Wired, 8984K Cache, 214M Buf, 6844K Free Swap: 12G Total, 12G Used, 161M Free, 98% Inuse, 224K In, 3008K Out PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND 36489 vscan1 760 5838M 688M pfault 1 0:49 18.07% perl 36487 vscan1 760 9935M 695M pfault 1 1:07 0.00% perl 36420 vscan1 440 647M 0K WAIT 1 0:40 0.00% 36485 vscan1 760 647M 76428K pfault 1 0:18 0.00% perl 36488 vscan1 760 647M 75164K pfault 1 0:18 0.00% perl 38628 vscan1 760 647M 75012K pfault 0 0:08 0.00% perl I don't understand why would this suddenly start happening, after *years* of running AMaViSd-new. When the daemon crashes and respawns, the machine is taken almost to the point of unusability. Has anyone else noticed this? Is there any kind of workaround? :-/ I'm supposed to be leaving for a road trip in the AM and I guess the Critical Circuit decided to trip. ;-) Thanks in advance, everyone... Best, --Glenn -- ...destination is merely a byproduct of the journey --Eric Hansen -- ___ 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] swap_pager_getswapspace failed.
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 ClamAV and p5-Mail-ClamAV were the issues. > Cancel your road trip. > T'wasn't an option. :) While I was gone, I had disabled amavisd-new, and just had postgrey running. Luckily postgrey does handle most spammy activity, so the spam wasn't *terrible* when I got back. Best, --Glenn -- ...destination is merely a byproduct of the journey --Eric Hansen -- Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/blackberry ___ 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/
SpamAssassin/Amavis/MySQL... was: Re: [AMaViS-user] Too memory hungry!
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 PostfixAdmin and a couple of virtual domains (for myself and friends). Right now I'm running SA through procmail (spamd/c), and I'd like to switch over to running through Amavisd-new with a MySQL backend. Searching for HOWTOs has been disheartening and the HOWTOs seem to very lamely go "Oh I just loaded Spamassassin..." instead of any real *meat* to the article. So my questions are: 1) How many nights/weekends am I going to sacrifice trying to get SA to work with a MySQL backend along with importing the old user_prefs? Where can I find decent documentation for this switch? 2) Does anyone run Procmail on their virtual accounts? If so, could you point me in the right direction? This is something where the results on Google have been less than stellar :-/ 3) Running SA through Amavisd-new is probably going to hurt. A lot. (performance/memory-wise) Any suggestions on how to make this less-painful? This is on a FreeBSD 4.11-RELEASE box, running: postfix-2.2.8 SA 3.1.0_5 pyzor-0.4.0_3 razor-agents-2.77 amavisd-new-2.3.3_1 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ 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] SpamAssassin/Amavis/MySQL Cont'd--the SPF/NJABL/SORBS debacle..
Ok.. first off.. thank you Gary & Clifton for your help :) I have this all up and running.. with some burps here and there, but it's working. Now, all of a sudden mail *from* myself *to* myself is being tagged 5.0xx points of spam for failing SPF/NJABL/SORBS checks?! This wasn't happening before, and I know I was passing my own SPF checks &c. I've looked my server up on NJABL and SORBS and came back negative.. so.. I'm seeing X-Spam-Status: No, score=5.034 tagged_above=5 required=6.3 tests=[RCVD_IN_NJABL_DUL=1.713, RCVD_IN_SORBS_DUL=1.988, SPF_FAIL=1.333] This puzzles me greatly..? Especially from my own server *to* my own server, no less. (Either real or virtual email accounts...) Any ideas here?? 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ 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] SpamAssassin/Amavis/MySQL Cont'd--the SPF/NJABL/SORBS debacle..
D'oh... FreeBSD 4.11-RELEASE p5-Mail-SpamAssassin 3.1.0 amavisd-new 2.3.3 p5-Mail-SPF-Query 1.997 Thanks again.. :) Best, --Glenn (who now needs some sleep..*yawn*) -- "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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ 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] SpamAssassin/Amavis/MySQL Cont'd--the SPF/NJABL/SORBS debacle..
Gary V said the following on 1/12/2006 9:46 AM: > I think the entire header needs to be shown before meaningful diagnosis > can begin. A clear picture of where your server sits in your network, > and any internal_networks/trusted_networks settings you currently have > in local.cf may also help. Sure--the server, however, hasn't moved. It's in the same place it was the day before yesterday, when all of this was fine (grin). (after poking in local.cf) Ok I didn't have an internal_networks/trusted_networks setting. That's now there. I'm no longer getting spam scores in internal emails. So, why would it make a difference whether I'm running SA through spam(c|d) or amavis? AFAIK I wasn't having this problem before. This is puzzling. *shrug* I'm satisified enough with this, even though when setting the sa_tag_level_deflt to 0.0 I still see I'm failing SORBS_DUL and NJABL_DUL (probably because it's not intelligent enough to realize I run SASL-Auth, and all it sees is an IP for a cable modem). Thanks again, Gary! 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ 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] SpamAssassin/Amavis/MySQL Cont'd--the SPF/NJABL/SORBS debacle..
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 since 2001). I connect through my cable-modem, and submit over SMTP-Auth (SASL) to send email. SMTP-Auth has been up and running since last summer, and before that it was pop-before-SMTP. The most puzzling thing here is how, all of a sudden, *all* of my local mail (delivered wing-to-wing or wing-to-virtual or virtual-to-wing) is failing SPF checks, when I *never* failed it anytime before yesterday. Annoying, certainly. Why SA is deciding suddenly I'm failing SPF now, I have no fsck'ing clue. There should have been *NO* operational difference in the flagging of SA in this move from flatfile/spam(c|d) to SQL/running SA through amavisd--in theory that is (and we all know the saying about theory and practice, right?). But anyway--that's more a question for the SA list, than here. :) Again, thank you for your help in pointing me in the right direction on the SQL setups for SA/Amavisdnew. It's greatly appreciated! 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click ___ 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] 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=lnk&kid=103432&bid=230486&dat=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=lnk&kid=103432&bid=230486&dat=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] 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 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=lnk&kid=103432&bid=230486&dat=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] 8 bind variables when 9 are needed?
Hi list! So I just upgraded to 2.4.1,1 (FreeBSD port) and decided to go through my configuration file and re-do it. I'm running perl 5.8.8, DBD-mysql41-3.0003, mysql-server-4.1.18, SpamAssassin 3.1.1_4, and FreeBSD 4.11-RELEASE. So I mounted the new conf file, and I restarted AMaViS and Postfix, and now I'm seeing: May 18 19:30:25 caduceus amavis[9024]: (09024-01) (!) WARN save_info_final: sql execute failed within transaction, err=-1, S1000, DBD::mysql::st execute failed: called with 8 bind variables when 9 are needed at (eval 53) line 138, line 374. at (eval 53) line 153, line 374. May 18 19:30:25 caduceus amavis[9024]: (09024-01) (!!) ERROR sql_storage: too many retries on storing final, info not saved The MySQL statements are direct out of the conf file.. I'm putting in my old ones as well as the new ones, for comparison.. Old conf file SQL: $sql_select_policy = 'SELECT *,users.id FROM users,policy'. ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'. ' ORDER BY users.priority DESC'; $sql_select_white_black_list = 'SELECT wb FROM wblist'. ' WHERE (rid=?) AND (wblist.email IN (%k))'. ' ORDER BY wblist.priority DESC'; New conf file SQL: $sql_select_policy = 'SELECT *,users.id'. ' FROM users LEFT JOIN policy ON users.policy_id=policy.id'. ' WHERE users.email IN (%k) ORDER BY users.priority DESC'; $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'; %sql_clause = ( 'sel_policy' => \$sql_select_policy, 'sel_wblist' => \$sql_select_white_black_list, 'sel_adr' => 'SELECT id FROM maddr WHERE email=?', 'ins_adr' => 'INSERT INTO maddr (email, domain) VALUES (?,?)', 'ins_msg' => 'INSERT INTO msgs (mail_id, secret_id, am_id, time_num, time_iso, sid,'. ' policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?)', 'upd_msg' => 'UPDATE msgs SET content=?, quar_type=?, quar_loc=?, dsn_sent=?,'. ' spam_level=?, message_id=?, from_addr=?, subject=? WHERE mail_id=?', 'ins_rcp' => 'INSERT INTO msgrcpt (mail_id, rid, time_num,'. ' ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?)', 'ins_quar' => 'INSERT INTO quarantine (mail_id, chunk_ind, time_num, mail_text)'. ' VALUES (?,?,?,?)', 'sel_quar' => 'SELECT mail_text FROM quarantine WHERE mail_id=? ORDER BY chunk_ind', ); I fully admit here that I'm no SQL master. I can get around, I can add/remove users and such, but not this kind of stuff! Can anyone tell me what's going on? :-/ Thanks in advance, and thanks for a great product--it's managed to keep my old company, as well as my own server and users Spam/Virus free since 2001! :) 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 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] 8 bind variables when 9 are needed?
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 (mail_id, secret_id, am_id, time_iso, sid, policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?)', 'ins_rcp' => 'INSERT INTO msgrcpt (mail_id, rid, ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?)', Or am I not getting what you're saying here? (Edit: Nope, now the error is "10 bind variables when 9 are needed at line 153.. *headdesk*.. so obviously I'm missing something obvious here. *sigh* Sorry to be clueless on this. I'm great at things like automation and such, but there are days that SQL just reads like 60's stereo instructions to me.. :( ) On an aside, trying to add the FOREIGN KEY constraint makes my mysql server decide to freeze up. I'm looking into that... 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 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] 8 bind variables when 9 are needed?
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 msgs(mail_id) ON DELETE CASCADE; > ALTER TABLE quarantine > ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE; > > See updated suggested set of DELETE clauses at the end of README.sql. Got these done (Turns out the last two just took forever to run! :-) I also ran the maintenance clauses at the end of README.sql, and will script those so they happen regularly.) Even after all this (and resetting the ins_msg & ins_rcp back to what was in the -defaults file), still getting the same error. :-( Thanks again for your help, I do appreciate it... 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 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] 8 bind variables when 9 are needed?
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 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] Whitelisting/Blacklisting?
-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 from emails in the quarantine). My users are a pretty quiet lot, they don't tend to complain or say much. I recently was chatting with one, who said that they had a user set in their blacklist for a while, and it never succeeds in flagging the email as spam. So I asked her to send me an email from this blacklisted person with full headers on. So I checked, and it turned out she had the wrong email in the blacklist. But, it made me go and check my own. So I put an email address of my own on gmail into the blacklist for my account. I sent myself an email from that account on gmail.. here are the X-Spam lines: X-Spam-Flag: NO X-Spam-Score: -101.946 X-Spam-Level: X-Spam-Status: No, score=-101.946 tagged_above=-999 required=5 tests=[AWL=0.245, BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.5, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, USER_IN_WHITELIST=-100] autolearn=ham As you can see, it's saying the user is in the whitelist, but it's in the blacklist. (c/p from the database:) rid sid priorityemail wb 3 0 9 rainb...@gmail.com B Does anyone have any idea what might be going on? I appreciate any and all help, in advance. Thanks again for your time! Best, - --Glenn -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkz61IUACgkQf5MxTDXTimHDIQCbBbx9lExSZ6rGtqGQR+fqgIMb Cw8An2QoJFAUDT9OChhQUyWjtAar/sHC =yGpf -END PGP SIGNATURE- -- What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org
Re: [AMaViS-user] Whitelisting/Blacklisting?
-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 *you*... I set up the schema and stuff based on the amavisnewsql plugin for SquirrelMail, so that's probably why it isn't quite the same? (And I know it's not been updated in forever, and apparently there's something called "server settings" but I haven't figured that plugin out yet...) (much snippage) > I believe what you need is: > > $sql_select_white_black_list = > 'SELECT wb FROM wblist'. > ' WHERE wblist.rid=? AND wblist.email IN (%k)'. > ' ORDER BY wblist.priority DESC'; > > and make sure sender addresses are kept in wblist.email > and recipients are kept in table users. This seems to do what is expected... when I put an email address in the blacklist (one I own from gmail), and send an email to the account that's blacklisted it, it gets treated thusly: Dec 17 17:20:34 caduceus postfix/smtpd[77552]: NOQUEUE: filter: RCPT from mail-gw0-f45.google.com[74.125.83.45]: : Recipient address triggers FILTER smtp-amavis:[127.0.0.1]:10024; from= to= proto=ESMTP helo= Dec 17 17:20:34 caduceus postgrey[1054]: action=pass, reason=client whitelist, client_name=mail-gw0-f45.google.com, client_address=74.125.83.45, sender=my_address...@gmail.com, recipient=...@wingfoot.org Dec 17 17:20:34 caduceus postfix/smtpd[77552]: D2BF439DC25: client=mail-gw0-f45.google.com[74.125.83.45] Dec 17 17:20:34 caduceus postfix/cleanup[77554]: D2BF439DC25: message-id=<4d0be22e.7090...@gmail.com> Dec 17 17:20:34 caduceus postfix/qmgr[98929]: D2BF439DC25: from=, size=2196, nrcpt=1 (queue active) Dec 17 17:20:35 caduceus postfix/smtp[77555]: D2BF439DC25: to=, relay=127.0.0.1[127.0.0.1]:10024, delay=0.84, delays=0.55/0/0.01/0.28, dsn=2.7.0, status=sent (250 2.7.0 Ok, discarded, id=77786-01 - SPAM) Dec 17 17:20:35 caduceus postfix/qmgr[98929]: D2BF439DC25: removed Removing the email from the blacklist or adding it to the whitelist, results in delivery of the email, as expected. Thank you! :-D Best, - --Glenn -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk0L6+EACgkQf5MxTDXTimGa6gCfXSoBhYKyTleRtKEW5b4d5nE3 O5sAoK8jheHiTHzYaQI4r0cOhrG3Kgrj =9lAm -END PGP SIGNATURE- -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org