On Thu, 2011-09-29 at 13:41 +0100, Ron White wrote:
> On Thu, 2011-09-29 at 13:27 +0100, Graeme Fowler wrote:
> > On Thu, 2011-09-29 at 13:18 +0100, Ron White wrote:
> > > And that didn't work either. Despite it not reporting any issues on
> > > installation - it does not appear to be working. No queries being made,
> > > no errors - just like before. Mmmm.
> >
> > Your configuration isn't right:
> >
> > > domainlist hosted_domains = ${lookup mysql{MYSQL_HOSTEDDOMAINLIST}}
> > >
> > > <relevant ACL clause>
> > > check_rcpt:
> > > accept domains = local_domains : *.local_domains
> > > deny message = relay not permitted
> >
> > You define the domainlist - and then don't use it. Even corrected, the
> > line:
> >
> > accept domains = hosted_domains
> >
> > ...is still invalid, as it needs to be:
> >
> > accept domains = +hosted_domains
> >
> > The latter with the + means "look the domain up in the domain list"; the
> > version you currently have means "compare the domain with the literal
> > string 'hosted_domains'".
> >
> > If you use the right syntax, you'll get your lookup. This explains why
> > you weren't getting an error - because the lookup was never being used.
> >
> > Graeme
> >
> >
> Brilliant - thanks Graham, that's exactly it. It now works as expected
> with the small caveat that I need to resolve the SELinux issue that
> prevents access to /var/lib/mysql/mysql.sock in enforcing mode - but I
> think I can work that out with a bit of reading.
>
> Many thanks for your time and patience. I am most obliged to you.
>
> Ron
Just following up on my own post here for the sake of archives/google.
To fix the issue with the mysql socket access and SElinux, all that was
required was:
setsebool exim_can_connect_db 1
Thanks to all for the excellent help I received via the list.
Ron.
