On 06/14/2016 08:02 AM, Wietse Venema wrote:
Paul R. Ganci:
On 06/14/2016 04:28 AM, Wietse Venema wrote:
Paul R. Ganci:
<snip>If the MYSQL library was handling the host name resolution
then why does the postmap -q query succeed? Shouldn't both queries fail?
Perhaps you are running postmap as ROOT; Postfix runs as on-root.
Indeed I was.
Perhaps you have chroot enabled in master.cf. This is the default on
debian/ubuntu. See http://www.postfix.org/DEBUG_README.html#no_chroot
Change the master.cf entry should to this:
smtp inet n - n - - smtpd
-----------------------------------^^^
Using chroot requires additional setup.
I am running CentOS 7 which runs postfix chroot. Everything works as
expected in this mode except for the mysql configuration. You are
suggesting a permissions problem but I have verified that even with
world read access the problem occurs. I do not want to run postfix as
root. I am okay with the setup as it is now however can you elaborate on
what additional setup I would need to get the mysql database to work
with a server name rather than a server IP address? I really thought it
was as simple as making the config file and then just making the proper
entry in main.cf ala:
local_recipient_maps = mysql:/etc/postfix/local_recipient_map.cf
There is definitely something strange because I just put back the server
name and did a postmap query from a non-root account and it works fine.
I also verified that I don't have a typo in the main.cf config so I
really don't understand what might be different between the mysql access
from postfix vs postmap.
--
Paul (ga...@nurdog.com)
Cell: (303)257-5208
