Re: [AMaViS-user] Mysql 5.1 + Partitioning Storage Schema / Cleanup

2010-05-19 Thread Mark Martinec
ALTER TABLE quarantine PARTITION BY LIST (partition_tag) ( PARTITION p0 VALUES IN (1,5,9,13,17,21,25,29,33,37,41,45,49), PARTITION p1 VALUES IN (2,6,10,14,18,22,26,30,34,38,42,46,50), PARTITION p2 VALUES IN (3,7,11,15,19,23,27,31,35,39,43,47), PARTITION p3 VALUES IN

Re: [AMaViS-user] Configuring Sophos with amavisd-new

2010-05-19 Thread Mark Martinec
Ashish, I deployed amavisd-new (with Clam-AV and spamassassin) with my postfix installation referring this: http://wiki.centos.org/HowTos/Amavisd Now because of business requirement changes I need to use Sophos instead of Clam-AV with my installed amavisd-new. Can anybody reply with a

Re: [AMaViS-user] spamassassin per user/email

2010-05-19 Thread Mark Martinec
Stefan, i am using Amavisd-new in a virtualUser Setup via LDAP. I would like to call SpamAssassin per user/email. Is there any way to do this or do i need to use spamAssassion via another solution? Depends on what you have in mind. As amavisd calls SpamAssassin once per message (not once per

Re: [AMaViS-user] severe performance degredation by amavisd 2.6.4 under load

2010-05-19 Thread Mark Martinec
Andy, I saw a suggestion from Matt Reimer back in April regarding ditching db41 for db42 to resolve a strange performance issue with Amavisd on FreeBSD 8. Yeah. That was it. I ditched db41 for db42 and wow what a difference. Thanks for a thorough investigation and a resolution! That box

Re: [AMaViS-user] Current p0f rules?

2010-05-19 Thread Mark Martinec
Andy, Are the sample rules in the release notes still the preferred p0f ruleset for SA? Yes, still valid. It's pretty much what I'm using at our site. The IP distance (hop count) rules may need tweaking if your site is close to poorly policed ISPs, but it works well in our academic networks

Re: [AMaViS-user] UTF8 in fields subject and from_addr in msgs table

2010-05-19 Thread Mark Martinec
Miguel, I'm having some trouble reading the fields subject and from_addr from msgs table, they are in latin1 encoding, I need them in UTF8. The only way I'm able to do this is to issue an update to the msgs table preceded by a set names utf8: code $conn_h-execute(set names utf8);

Re: [AMaViS-user] virus_check_*_ttl

2010-05-19 Thread Mark Martinec
$virus_check_negative_ttl= 3*60; # time to cache contents as not infected $virus_check_positive_ttl= 30*60; # time to cache contents as infected Are these seconds or minutes? I know. Note the lack of time units. I was going by the time to live in seconds part. I try to stick to SI

Re: [AMaViS-user] getting policy fired on email from SQL

2010-05-19 Thread Mark Martinec
Jernej, I was wondering whether there is a way to find out with SQL query from amavis database, which emails were sent through SA and which were not. I know that it depends on the policy, but is there a way to combine policy with msgs table? I am looking for emails that were sent

Re: [AMaViS-user] Amavis sometimes looses e-mails

2010-05-19 Thread Mark Martinec
d h, We are using FreeBSD 7, Postfix 2.5.1, Amavis 2.6.1 May 4 18:11:14 amavis[54714]: (54714-08-2) smtp resp to NOOP (idle 113.5 s): 220 you.got.mail ESMTP Postfix May 4 18:11:14 amavis[54714]: (54714-08-2) Negative SMTP resp. to DATA: 250 2.1.5 Ok May 4 18:11:14

Re: [AMaViS-user] forward SPAM for few domains

2010-05-19 Thread Mark Martinec
Lampa, is there some way how to setup forwarding mails marked as SPAM for some domains to one user (spam for domains @example.com, @example2.com, @example3.com, ... forward to s...@example.com) ? If I understand correctly, you'd want to whitelist senders @example.com, @example2.com,

Re: [AMaViS-user] ban files only for AM.PDP-SOCK

2010-05-19 Thread Mark Martinec
David, I want to block pps file and other file only for policy bank AM.PDP-SOCK this the policy bank config $policy_bank{'AM.PDP-SOCK'} = { protocol = 'AM.PDP', notify_method = 'pipe:flags=q argv=/usr/sbin/sendmail -Ac -i -f ${sender} -- ${recipient}', auth_required_release = 0,

Re: [AMaViS-user] forward SPAM for few domains

2010-05-19 Thread Lampa
2010/5/19 Mark Martinec mark.martinec+ama...@ijs.si: If I understand correctly, you'd want to whitelist senders @example.com, @example2.com, @example3.com, but just for a recipient s...@example.com. This can be accomplished with @score_sender_maps : @score_sender_maps = ({  # a by-recipient

[AMaViS-user] anyone getting sql-enter FAILED: find_or_save_addr: failed to insert addr

2010-05-19 Thread Michael Scheidell
If you DON'T get this, no need to tell me, if we do have a couple people getting this, then we can try to see why. I am looking for people running latest amavisd, with mysql 5.1.x and getting these errors in your maillogs: May 19 16:16:01 mx1 postfix/lmtp[57047]: 51EB9B0D6E9: