RE: [Exim] ACL problem - semi-urgent

Troy,

    you doing popb4smtp like we talked about on the phone?

bkw

-----Original Message-----
From: exim-users-admin@??? [mailto:exim-users-admin@exim.org] On Behalf
Of Brian K. West
Sent: Monday, June 09, 2003 10:47 AM
To: 'Troy Settle'; exim-users@???
Subject: RE: [Exim] ACL problem - semi-urgent

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/ ##



--

## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##