Re: [AMaViS-user] SQL-Quarantine timeout while cleaning
Paolo, today I gave a test run to the quarantine cleanup script during working hours, and noticed amavisd-new behaviour. Because of DB timeout the message was left in Postfix' incoming queue. Right, this is the intended behaviour. Setup: 2.3.3 with Mysql 4.1.17 quarantine and Bayes store. Here's the log excerpt from one of the messages that got deferred: ... Dec 28 15:41:36 srv-asgw03 amavis[23922]: (23922-01-2) writing mail text to SQL failed: Error closing, flush: sql inserting text failed, sql execute: sts=1205, DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at (eval 37) line 127 ... Dec 28 15:41:36 srv-asgw03 postfix/smtp[23889]: DAE675840FA: to=[EMAIL PROTECTED], relay=127.0.0.1[127.0.0.1], delay=217, status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in processing, id=23922-01-2, spam quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id RwE12bnYGrrT failed:... Was the message sent twice? Any cure? Sent twice? What makes you think so? After this unsuccessful attempt, Postfix retried the same message later, and when cleanup was over, the next attempt should have been successful. Recipients should have this message delivered exactly once. Mark --- 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=7637alloc_id=16865op=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] custom templates based on country code?
Pablo, Is there any way to set up amavis-new to select bounce, (etc) delivery notifications based on user choise or any other factor? I am trying to find out a way to send bounce/virus/spam delivery/warnings/errors notifications to users in their native language. Some hacking may be required. One option would be to provide another macro with its value being an integer - an index into a list of template text choices. Then you can use it in a template, e.g. [? %L |english template|spanish template|french|german] See README.customize. How to determine the right language is up to you to determine. Currently the only off-the-shelf option to address your needs are policy banks. Each policy bank can have its own set of template texts. If somehow you can persuade Postfix to submit mail for content filtering to different amavisd-new ports, based on the language of choice, then this is the cleanest solution, no hacking of code required. See: http://www.ijs.si/software/amavisd/amavisd-new-docs.html#pbanks Mark --- 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=7637alloc_id=16865op=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] How to automatically report SPAM to spamcop
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MJ Sent: Wednesday, December 28, 2005 7:07 AM To: amavis-user@lists.sourceforge.net Subject: [AMaViS-user] How to automatically report SPAM to spamcop Hi, I am running postfix 2.2.4 on Solaris 8 with amavisd-new.2.3.2, SpamAssassin 3.1.0 and Clamav 0.8.7.1 as an AV/AS gateway to my main email system. Since we are any ISP and we received thousands of SPAM messages I want to report these messages to spamcop. I have gone through the faq's on spamcop site and some docs on spamassassin site but still I didn't get a clear idea how to configure this. Can any one guide me on this. Sign up for spamassassin. Put the spamassissin addresses into local.cf Use sa-learn to report spam (if you are an isp, use perl and procmail scripts to look for spam tages and submit) Make sure you use common .razor directorier if you use razor also. Second question is that am using postfix to check the rbls, is it OK or I need to check this in amavisd? An rbl is a 'one hit and you are out'. No quarantine, no scoring, nothing. And SA will be checking them anyway (so you check them twice?) Your choice. Thanks, MJ --- 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=7637alloc_id=16865op=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/ --- 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_idv37alloc_id865op=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] amavisd-new cut connection from postfix
Hi. My Amavisd-new cut the connection to postfix if the amavisd-new spammodule is in use. I installed all Modules, but it still doesn't work. Here are my amavisd.conf the logfile with loglevel 5. I Hope someone else can help me. https://mail.lug-wt.de/amavis.log https://mail.lug-wt.de/amavisd.conf Greets Michael --- 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=7637alloc_id=16865op=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] amavisd-new cut connection from postfix
Michael, My Amavisd-new cut the connection to postfix if the amavisd-new spammodule is in use. I installed all Modules, but it still doesn't work. Here are my amavisd.conf the logfile with loglevel 5. I Hope someone else can help me. https://mail.lug-wt.de/amavis.log https://mail.lug-wt.de/amavisd.conf Thanks for the log. Indeed it is within SA that the Perl process crashes. Do the 'spamassassin' command line utility and the 'sa-learn' work? Try: # su vscan -c 'spamassassin --lint' # su vscan -c 'sa-learn --sync --force-expire --showdots' If they do work without complaints, then try: amavisd debug-sa Mark --- 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=7637alloc_id=16865op=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] Custom spamassassin rule don't work
I have this custom rule on /etc/mail/spamassassin/local.cf uri GEOCITIES /^http:\/\/(uk|it|de|sg|ar|jp|in|es|au|ca|www)\.geocities\.com\/.*\/\?/i describe GEOCITIES Tons of spam with Geocities URL scoreGEOCITIES 4.0 However it simply doesn't work. Geocities spam, still enters my mailbox. SA headers show nothing about this URI test. Someone recomended this rule to stop geo spam, i just added the other country sub-domains. Am i missing something? Santos --- 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=7637alloc_id=16865op=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] Custom spamassassin rule don't work
On Thu, Dec 29, 2005 at 08:14:48PM +, Santos wrote: I have this custom rule on /etc/mail/spamassassin/local.cf uri GEOCITIES /^http:\/\/(uk|it|de|sg|ar|jp|in|es|au|ca|www)\.geocities\.com\/.*\/\?/i describe GEOCITIES Tons of spam with Geocities URL scoreGEOCITIES 4.0 However it simply doesn't work. Geocities spam, still enters my mailbox. SA headers show nothing about this URI test. Someone recomended this rule to stop geo spam, i just added the other country sub-domains. 1) Try spamassassin --lint in the /etc/mail/spamassassin directory, to make sure your syntax is correct. 2) Check the amavisd log messages to see which configuration files are actually loaded on startup. The directories used for system and local SA config files vary considerably from one OS distro to anohter. -- Clifton -- Clifton Royston -- [EMAIL PROTECTED] / [EMAIL PROTECTED] President - I and I Computing * http://www.iandicomputing.com/ Custom programming, network design, systems and network consulting services --- 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=7637alloc_id=16865op=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] Custom spamassassin rule don't work
Clifton wrote: On Thu, Dec 29, 2005 at 08:14:48PM +, Santos wrote: I have this custom rule on /etc/mail/spamassassin/local.cf uri GEOCITIES /^http:\/\/(uk|it|de|sg|ar|jp|in|es|au|ca|www)\.geocities\.com\/.*\/\?/i I think there is something in .*\/\? that is not right. Maybe they meant .*\/? which is rather general and I think the \/? would end up being superfluous when the .* is used prior to it. How about: /^http:\/\/(uk|it|de|sg|ar|jp|in|es|au|ca|www)\.geocities\.com\/[a-z0-9-_]+\/?/i which is a little more specific. A fun tool (Windows): http://www.renatomancuso.com/software/pcreworkbench/pcreworkbench.htm 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://ads.osdn.com/?ad_id=7637alloc_id=16865op=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/