RE: [Exim] ACL problem - semi-urgent

On Mon, 9 Jun 2003, Troy Settle wrote:

> > Please reply only to list.
> >
> > > 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
> >
> > This does not work. I've tried it myself.
> >
> > My work around was:
> > hostlist relay_from_hosts = ${lookup
> > mysql{MYSQL_HOSTS}{${sg{$value}{\\n}{ : }} }}

> We have a winner. Thank you William, I do appreciate it.

Hi.

I think I ran into the same undelying problem here, but fixed it in another
manner:

domainlist local_domains = pgsql;SELECT dm.name FROM domains dm, sites si WHERE
dm.site_id = si.id AND si.active = 't' AND dm.name = '$domain'

As I understand it, hotlists and domainlists with lookups in then re-run the
lookup each time they're used, allowing you to match against $domain and such.
I searched this mailinglist, and this was apparently how one is supposed to do
it.

It appeared to make sense when looking at the debug messages too, displaying
how Exim "thinks".

-- Daniel