[prev in list] [next in list] [prev in thread] [next in thread] 

List:       exim-users
Subject:    Re: [exim] Mysql support - no errors but checking compiled in
From:       Ron White <exim.ml () riotm ! co ! uk>
Date:       2011-09-30 7:01:19
Message-ID: 1317366079.8926.4.camel () testbed
[Download RAW message or body]

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.



-- 
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
[prev in list] [next in list] [prev in thread] [next in thread]