forum.lissyara.su

Код: Выделить всё

------ This is a copy of the message, including all the headers. ------

Return-path: <edu@domain.ru>
Received: from [222.171.12.89]
	by balthasar.solaris.ru with esmtp (Exim 4.66 (FreeBSD))
	(envelope-from <edu@domain.ru>)
	id 1IAnpw-000NTf-JX
	for mscdcrhhtxhiylcprgus@solaris.ru; Tue, 17 Jul 2007 18:15:40 +0400
Received: from [222.171.12.89] by relay.domain.ru; Tue, 17 Jul 2007 14:15:52 -0800
Message-ID: <01c7c87c$fb61d0a0$590cabde@edu>
From: =?koi8-r?B?IkPBzc/FIMnO1MXSxdPOz8Ug1yDtxdbE1c7B0s/EztnIIPPUwc7EwQ==?=
	=?koi8-r?B?0tTByCDmyc7BztPP18/KIO/U3sXUzs/T1MkuIPfXz8TO2cogy9XS0w==?=
	=?koi8-r?B?LiI=?= <edu@incom.ua>
To: <mscdcrhhtxhiylcprgus@solaris.ru>
Subject: =?koi8-r?B?98HM0Q==?=
Date: Tue, 17 Jul 2007 14:15:52 -0800

Код: Выделить всё

# Борьба с "левыми" NDR.
# Заносим в базу адрес или обновляем метку времени при получении NDR.
warn senders = :
     hosts = !+relay_from_hosts
     condition = ${lookup mysql{INSERT INTO bounce_counter (date,recipient,count) VALUES (now(),'$recipients','1') ON DUPLICATE KEY UPDATE count=`count`+1,date=now();}{yes}{no}}

# Блокируем, если адрес получателя есть в базе.
drop log_message = 550 Too many bounce messages to $recipients at last 30 minutes.
     hosts = !+relay_from_hosts
     senders = :
     condition = ${lookup mysql{SELECT recipient FROM bounce_counter WHERE `recipient`='$recipients' AND count>3;}{yes}{no}}
     message = 550 Too many bounce messages to $recipients at last 30 minutes.
## Записи с count меньше 3 и старее 30 мин. удаляются из базы из cron-а.
## Записи, старее 1 часа удаляются из базы без условий.

Код: Выделить всё

CREATE TABLE IF NOT EXISTS `bounce_counter` (
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `recipient` varchar(100) NOT NULL default '',
  `count` int(3) NOT NULL default 0,
  PRIMARY KEY  (`recipient`),
  UNIQUE KEY `ip` (`recipient`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Код: Выделить всё

...
$query=("delete from bounce_counter where UNIX_TIMESTAMP(date)<UNIX_TIMESTAMP(now())-1800;");
$sth=$dbh->prepare($query); $sth->execute;
...

Код: Выделить всё

# ratelimit for bounce messages for recipient
  drop  hosts     = !+relay_from_hosts
        senders   = :
        message   = Bounce messages rate exceeds per $sender_rate_period for $sender_host_address
        log_message   = Bounce messages rate exceeds per $sender_rate_period for $sender_host_address
        ratelimit = 2 / 30m / per_rcpt / $sender_host_address