We're using MySQL to enforce load-balancer-compatible sending limits
using the RCPT and DATA ACL's in Exim 4.69:
acl_check_rcpt:
drop condition = ${if > {${eval: $rcpt_count + ${lookup mysql{SELECT
count FROM mailcount_$tod_logfile WHERE ip = '$sender_host_address'}}}}
{1000} {yes}{no}}
message = Message would exceed 1000 recipient limit for
$sender_host_address
acl_check_data:
warn continue = ${lookup mysql{INSERT INTO mailcount_$tod_logfile (ip,
count) VALUES('$sender_host_address', $rcpt_count) ON DUPLICATE KEY
UPDATE count=count+VALUES(count);}}
When MySQL is unavailable, the warn continue statement fails quietly and
doesn't interrupt delivery. However, since the RCPT ACL uses a drop
condition, all incoming mail is deferred when MySQL is down:
30625 lookup deferred: MYSQL connection failed: Can't connect to MySQL
server on '192.168.X.X' (111)
30625 drop: condition test deferred
30625 SMTP>> 451 Temporary local problem - please try later
30625 LOG: MAIN REJECT
30625 H=(t) [127.0.0.1] F=<sender@???> temporarily rejected
RCPT user@???: MYSQL connection failed: Can't connect to
MySQL server on '192.168.X.X' (111)
30625 LOG: lost_incoming_connection MAIN
30625 SMTP command timeout on connection from (host) [SENDER.HOST.IP]
30625 SMTP>> 421 servername: SMTP command timeout - closing connection
Is there any way to enable a "defer_ok" or equivalent functionality in
this case?
Thanks!
Rich Sandberg
richs@???
