Re: [AMaViS-user] MySQL InnoDB Performance - Ultra Slow Queries

super slow. Hmmm, I've seen MySQL 5.0 creating tmp tables on disk... Seconded...I saw it this morning in /var/tmp with an innodb table.. -Dave -- Dave McGuire Port Charlotte, FL -- This SF.net email

Re: [AMaViS-user] temporarily disable quarantine?

false positives are almost nonexistent, I figured this'd be the best way to do it. Set the kill level to 5? Ahh! I assume you mean $sa_quarantine_cutoff_level, but yes, I think that'd do fine, I hadn't thought of that. Thanks! -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] Performance tuning and bayes db

the advantage of InnoDB over MyISAM for these tables? Does the same advice apply to MySQL-based quarantine tables? Also, why BayesStore::MySQL over BayesStore::SQL? (just curious) -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] Performance tuning and bayes db

with amavisd for several years now, with no badness that I'm aware of. Based on your advice, though, I suppose it's probably worth doing a few alter table queries this afternoon. -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] does amavis invoke spamassassin?

there is no need to run spamc, spamd, or spamassassin. See if you have entries in your mail log for amavis, as opposed to spamassassin: cat /var/log/mail.log | grep amavis Oh good heavens. grep amavis /var/log/mail.log -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] queue processing directory

/amavis/tmp and I've mounted a ramdisk there on some of my systems. It does seem to help throughput somewhat on machines that are otherwise I/O bound. It's a memory trade-off, though, so keep your eye on that. -Dave -- Dave McGuire Port Charlotte, FL

[AMaViS-user] spam-related mailing lists?

rulesets are effective (SARE rules, etc) and what people are doing to stem the spam tide. I'd be surprised if there weren't such a list somewhere...does anyone know of one? Thanks, -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] Another secondary virus scanner

-new+MySQL platform. Use your uvscan as a backup scanner. It won't be called unless clamd fails, which is just what you need. Is this just a matter of moving the uvscan block from @av_scanners to @av_scanners_backup in amavisd.conf? -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] how many people really use the quarantine?

. -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01

Re: [AMaViS-user] how many people really use the quarantine?

it. I'm going to take over/fork a SQL-db editing tool, and am tempting to drop all support for quarantine in that. But before I did that, I wanted to see if there were good reasons to keep it I wasn't thinking of. What tool is it? -Dave -- Dave McGuire Port Charlotte, FL

[AMaViS-user] SA rules summary for ham not logged?

due to difficulty in taking this system down for any length of time...I'll do so when 2.5.3 is released. Thanks, -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

[AMaViS-user] local_domains_maps

, as the config file is actually a Perl script...but I'm primarily a C and assembly language programmer and have zero Perl knowledge. :-( Thanks, -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] local_domains_maps

, as the config file is actually a Perl script...but I'm primarily a C and assembly language programmer and have zero Perl knowledge. :-( Thanks, -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] SA rules summary for ham not logged?

) of each message as amavisd processes it. -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007 - SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From

[AMaViS-user] SQL-based w/b lists vs. policies

the users and policy tables in the database; I'd just like to use score_sender_maps from the database now. Thanks, -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] rbl in SA or in MTA, which is better

. :-( -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log

Re: [AMaViS-user] easy quarantine question

(for example) today. I haven't gone and spot-checked that they're actually duplicates, though...but I can't imagine them not being so. -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] Cannot manage /var/virusmails directory

. Is there any solution for this? And what can I do to manage this directory so that I only keep 30 days worth of message zipped? Uhh: # find /var/virusmails -ctime +30 -exec rm -f {} \; -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] Cannot manage /var/virusmails directory

the maximum command line length...Ahh yes (looking at the man page) -L num does that. The find(1) utility in GNU findutils has a -delete option which makes it even easier, but that's not quite universal. -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25

Re: [AMaViS-user] Cannot manage /var/virusmails directory

one person with a serious attitude problem. Cheers indeed. -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007 - This SF.net email is sponsored by: Splunk Inc. Still grepping

[AMaViS-user] excessive time spent in sql-update?

with information XYZ) and I'd really like some suggestions on how to identify the bottleneck so I can address it. Does anyone have any thoughts on this? Thanks, -Dave -- Dave McGuire Port Charlotte, FL Farewell Ophelia, 9/22/1991 - 7/25/2007

Re: [AMaViS-user] excessive time spent in sql-update?

On Aug 17, 2007, at 4:48 PM, Dave McGuire wrote: Hi folks. I've been handholding one of my mail servers for most of today as it deals with a large backlog of messages that are seemingly the result of a large flood of spam. In the TIMING log entries, amavisd-new (v2.4.5) is spending what I

Re: [AMaViS-user] excessive time spent in sql-update?

. The flood has died down and my mail server is now keeping up. I've also tuned the MySQL server a bit (adjusted some buffer sizes in my.cnf) and reduced the query latency a bit further; most queries are now executing in less than 10ms. -Dave -- Dave McGuire Port Charlotte

[AMaViS-user] thoughts on hard-whitelisting

. -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http

Re: [AMaViS-user] thoughts on hard-whitelisting

perspective. -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data

Re: [AMaViS-user] FW: [NETRAGARD SECURITY ADVISORY][Maia Mailguard 1.0.2 Arbitrary Code Execution][NETRAGARD-20070628]

. -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http

Re: [AMaViS-user] MySQL ISAM or InnoDB engine?

about this. My bayes-related tables are set up to use the MyISAM engine...Is InnoDB's r/w concurrency a big enough benefit for me to change my existing setup? Thanks, -Dave -- Dave McGuire Port Charlotte, FL

Re: [AMaViS-user] MySQL ISAM or InnoDB engine?

again! -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click

Re: [AMaViS-user] MySQL ISAM or InnoDB engine?

-- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http

Re: [AMaViS-user] How to receive quarantined spam?

! -Dave -- Dave McGuire Port Charlotte, FL - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now

Re: [AMaViS-user] How to receive quarantined spam?

this. Is it possible to configure amavis to do *both*...i.e., send caught spam to the local quarantine directory, as well as send a copy of it to a configurable email address? Thanks, -Dave -- Dave McGuire Port Charlotte, FL