MYSQL_RELAY = SELECT DISTINCT INET_NTOA(ip) AS
ip FROM MYSQL_AUTHTABLE WHERE INET_NTOA(ip)='${sender_host_address}' AND ts
> UNIX_TIMESTAMP() - MYSQL_RELAYTIMER;
Must do select distinct.. And use ${sender_host_address}
bkw
-----Original Message-----
From: exim-users-admin@??? [
mailto:exim-users-admin@exim.org] On Behalf
Of Troy Settle
Sent: Monday, June 09, 2003 9:44 AM
To: exim-users@???
Subject: [Exim] ACL problem - semi-urgent
All,
I'm having an issue with the ACL for controlling host access. Here's the
relevent portions of my configuration.
MYSQL_HOSTS = SELECT host FROM hosts WHERE status='allow' hostlist
relay_from_hosts = mysql;MYSQL_HOSTS accept hosts = +relay_from_hosts
Here's the output from the specified query:
mysql> SELECT host FROM hosts WHERE status='allow';
+------------------+
| host |
+------------------+
| 63.171.251.0/24 |
| 206.228.241.0/24 |
| 204.118.174.0/24 |
| 208.23.220.0/24 |
| 208.33.189.0/24 |
| 65.164.92.0/24 |
| 65.164.93.0/24 |
| 64.238.240.0/24 |
| 64.4.124.0/24 |
| 65.171.244.0/24 |
| 65.171.245.0/24 |
| 127.0.0.1 |
+------------------+
Here's a sample log:
2003-06-09 06:26:02 H=(cms2) [204.118.174.250] F=<cms@???>
rejected RCPT <eew@???>: relay not allowed
Any suggestions on how to fix this other than opening up relay to all hosts?
TIA,
--
Troy Settle
Pulaski Networks
http://www.psknet.com
540.994.4254 - 866.477.5638
--
## List details at
http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
