Re: [AMaViS-user] Per-day msgs/msgrcpt/quarantine tables

2007-09-03 Thread Thomas Gelf
Mark Martinec schrieb: > I have now a somewhat more advanced variant of my previously posted patch, > which automatically sets partition_tag to a current ISO8601 week number > (1..53) if $sql_partition_tag is undef, which will be a default. > If anyone is interested please drop me a line. /me drop

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Thomas Gelf
Mark Martinec schrieb: > Your understanding is correct. There is not much need to clear a > database of process statuses, unless there are hundreds or thousands > of stale entries left there, but in this case you'd have a more serious > problem to solve anyway. Apart from amavisd-nanny, an amavisd

Re: [AMaViS-user] Per-day msgs/msgrcpt/quarantine tables

2007-09-03 Thread Mark Martinec
Robert Pelletier writes: > If we chose to work with 1 partition / week controlled within the > application, the absolute fastest way to delete the data is to drop > the partition. (ALTER TABLE myTable DROP PARTITION myPartition) I have now a somewhat more advanced variant of my previously posted p

Re: [AMaViS-user] zip file causing crashes

2007-09-03 Thread Mark Martinec
Jerry, > Hmmm, I'm in the process of moving the mail/web servers over to a > Linux system (the Mac is too much trouble). I wonder if this is just > a Mac thing that will go away with the move? > > While I'm here, any suggestions on setting up the new system? To > keep is close to what I'm used t

Re: [AMaViS-user] zip file causing crashes

2007-09-03 Thread Jerry Durand
At 10:06 AM 9/3/2007, Clifton Royston wrote: > > Hmmm, I'm in the process of moving the mail/web servers over to a > > Linux system (the Mac is too much trouble). I wonder if this is just > > a Mac thing that will go away with the move? > > Might be an old ClamAV version? Which one do you have.

Re: [AMaViS-user] zip file causing crashes

2007-09-03 Thread Clifton Royston
On Mon, Sep 03, 2007 at 09:49:29AM -0700, Jerry Durand wrote: > At 09:39 AM 9/3/2007, Thomas Gelf wrote: > > >I tried out your file: > > > ># wget http://interstellar.com/temp/amavis-.../email.txt > ># clamdscan email.txt > >/home/user/email.txt: Worm.SomeFool.P FOUND > > > >--- SCAN SUMMA

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Mark Martinec
Thomas, > I'm a little bit sceptic about FuzzyOCR & Co - I'll try to run a > more recent devel version. I also temporarily disabled gif checks > as giffix keeps segfaulting on Etch (I need to build a new package, > there is a known patch). Right, the FuzzyOCR is quite fishy, and its external prog

Re: [AMaViS-user] zip file causing crashes

2007-09-03 Thread Jerry Durand
At 09:39 AM 9/3/2007, Thomas Gelf wrote: >I tried out your file: > ># wget http://interstellar.com/temp/amavis-.../email.txt ># clamdscan email.txt >/home/user/email.txt: Worm.SomeFool.P FOUND > >--- SCAN SUMMARY --- >Infected files: 1 >Time: 0.023 sec (0 m 0 s) > >(Using ClamAV 0.

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Thomas Gelf
Mark Martinec schrieb: > Well, you already said the mail contents is full of spaces, so > the above does not apply. It is still good to know nevertheless, > and the $sa_spawned trick still applies, regardless of a > reason for SpamAssassin segfaults. I'm a little bit sceptic about FuzzyOCR & Co -

Re: [AMaViS-user] zip file causing crashes

2007-09-03 Thread Thomas Gelf
Jerry Durand schrieb: > This is probably just a Clamd problem, but I thought I'd run it by > here, too. I've been busy the past couple of days and haven't kept > up on list messages. > > I've received several e-mails that hang the mail system (Amavisd-new > reports TROUBLE) and the processor i

Re: [AMaViS-user] Amavis Hiccups?

2007-09-03 Thread Mark Martinec
Justin, > When I meant hiccups from the previous post, > I meant one amavisd process stall or one amavisd is trying to do its job > but somehow it got stuck with one message (spam message). > Although I have 10 more amavisd instances, this one process that is stuck > with one message is stopping o

[AMaViS-user] zip file causing crashes

2007-09-03 Thread Jerry Durand
This is probably just a Clamd problem, but I thought I'd run it by here, too. I've been busy the past couple of days and haven't kept up on list messages. I've received several e-mails that hang the mail system (Amavisd-new reports TROUBLE) and the processor is running at 100% utilization. On

Re: [AMaViS-user] LDAP local_domains_maps

2007-09-03 Thread Mark Martinec
Marcin, > I read some posts on this mailing group but still wonder how to perform > a simply lookup against LDAP. What I need is to use LDAP ONLY in > particular moments like finding local_domains. I don't what to use LDAP > in any different states. In exim I can invoke {lookup ldap} in almost > a

Re: [AMaViS-user] Notifications delivery

2007-09-03 Thread Mark Martinec
Jordi, > $final_virus_destiny = D_BOUNCE; > If I send from an external account ([EMAIL PROTECTED]) a > message with virus eicar, for example, to one of my SMTP accounts > ([EMAIL PROTECTED]), the logs show the next: > > Aug 31 18:48:47 tartarus.opengea.org /usr/sbin/amavisd[5782]: (05782-04) > Blo

Re: [AMaViS-user] virus_scan log entry inaccurate w/multiple malware names?

2007-09-03 Thread MrC
Mark Martinec wrote: > Mike, > >> I noticed a peculiarity this morning in my amavis log reports, which >> claimed that both ClamAV-clamd and McAfee AntiVirus detected the > > Admittedly this log report can be misleading. There is currently > only one list of virus names found (@virusname), and i

Re: [AMaViS-user] virus_scan log entry inaccurate w/multiple malware names?

2007-09-03 Thread Mark Martinec
Mike, > I noticed a peculiarity this morning in my amavis log reports, which > claimed that both ClamAV-clamd and McAfee AntiVirus detected the > SaneSecurity malware: Email.Malware.Sanesecurity.07082700 > It was clear that uvscan did not detect a SaneSecurity signature, > so I tracked down the as

Re: [AMaViS-user] another x-original-to question...

2007-09-03 Thread Mark Martinec
Zivago, > > > recipient_delimiter = + > > > $recipient_delimiter = '+'; > Thanks for the suggestion. I think this is a pretty decent workaround > and should work for this small setup. What would be even cooler would > for amavisd to have an option to read Postfix's virtual table. Not sure > if

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Mark Martinec
> Ok. If there are pictures in the mail, my next suspect > is a SpamAssassin plugin ImageCheck, which is > known to segfault on certain corrupted images. > It just wasn't designed with robustness in mind. P.S. Well, you already said the mail contents is full of spaces, so the above does not apply.

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Mark Martinec
Thomas, Thomas, > spamassassin < /var/lib/amavis/tmp/...-09604/parts/p002 ... > Segmentation fault > > So it really doesn't seem to be Amavisd-new's fault - I'll go on and > stress other people ;-) Thanks a lot for your help! Ok. If there are pictures in the mail, my next suspect is a SpamAssass

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Thomas Gelf
Mark Martinec schrieb: > So if you believe the file(1) is not a cause of delays, > please show a TIMING report from the amavisd log for > problematic messages (available at the log level 2 or above). Log level is 2, but as told before the last line there seems to be "providing full original messag

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Mark Martinec
Thomas, > thanks for your answer! file is 4.17-5etch2 - which is not 4.21, but > Debian people should have backported all relevant fixes as of my So if you believe the file(1) is not a cause of delays, please show a TIMING report from the amavisd log for problematic messages (available at the log

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Thomas Gelf
Thomas Gelf schrieb: > thanks for your answer! file is 4.17-5etch2 - which is not 4.21, but > Debian people should have backported all relevant fixes as of my > /usr/share/doc/file/changelog.Debian: NB: CVE-2007-2026 is also fixed, tests from http://www.amavis.org/security/asa-2007-3.txt are fine!

Re: [AMaViS-user] Long bad whitespace-lines

2007-09-03 Thread Thomas Gelf
Mark Martinec schrieb: > My guess is that you are bitten by a Linux regexp library problem, > triggered by the file(1) utility (it doesn't affect for example FreeBSD > with the same version of a file utility). It has been discussed before > on this ML. Also mentioned in: http://www.amavis.org/secur