[AMaViS-user] SQL quarantine, quarantine table not optimized

2005-07-29 Thread Paolo Cravero as2594
Hi. I am evaluating and stressing a amavisd + SA + clamav + MySQL setup (one P4 3GHz machine, 1GB RAM). Full quarantine to MySQL (message bodies too). Latest test includes an attempt at filling up MySQL tables with LOTS of data (million rows, 20-30GB table). I am not a MySQL guru, but I

Re: [AMaViS-user] SQL quarantine, quarantine table not optimized

2005-07-29 Thread Brian Wong
I tried indexing the quarantine table by one of its fields mail_id: CREATE INDEX quarantine_idx_mail_id ON quarantine(mail_id); and the query now takes a reasonable 1 second for 85000 rows. I thought the 'PRIMARY KEY' in the 'CREATE TABLE quarantine' statement created an implicit index.

Re: [AMaViS-user] Tagging mails #SPAM# and #SCANNED#

2005-07-29 Thread Gary V
Javier wrote: Hi again, I need to make amavisd to add on mails subject, some tags, for all mails the tag #Scanned# and for the posible spam ones the tag #SPAM#. I´ve read on the docs that this is done only by amavis and not by SA, i also read that i should play around with this settings:

Re: [AMaViS-user] Stripping attachments

2005-07-29 Thread Gordon Thagard
Are you an Amavisd-NEW developer? If so, may I suggest this functionality be included in future revs of the product? I know that other Anti-SPAM/VIRUS/BLOCKED utilities have this capability and it just seems like another nicety to add to an already very nice tool. Cheers, Michael Scheidell

[AMaViS-user] Problem processing messages, more

2005-07-29 Thread Jay Plesset
Totally reinstalled Amavis-new. Running in debug mode: Jul 29 20:45:40 boo.dp-design.com /usr/local/sbin/amavisd[3014]: (03014-01) decode_parts: level=1, #parts=1 : p001 Jul 29 20:45:40 boo.dp-design.com /usr/local/sbin/amavisd[3014]: (03014-01) run_command: [3023] /usr/local/bin/file p001

[AMaViS-user] graphing utility

2005-07-29 Thread Matt Juszczak
HI all, Looking for a good graphing utility for amavis. I wanted to use amavis-stats but it seems to give me errors when I try to run it on FreeBSD (even using the port). Any other alternatives? Thanks! -Matt --- SF.Net email is

Re: [AMaViS-user] graphing utility

2005-07-29 Thread Dale Walsh
On Jul 30, 2005, at 12:39 AM, Matt Juszczak wrote: HI all, Looking for a good graphing utility for amavis. I wanted to use amavis-stats but it seems to give me errors when I try to run it on FreeBSD (even using the port). Any other alternatives? Thanks! -Matt The issue you are