email builder wrote:
Hello,
When we connect to our bayes/awl/user_scores databases, the connections are
being made by clients with unqualified hostnames. If we try to use GRANTs
such as 'user'@'%.example.com', connections are refused since only the
hostname portion is being used to connect I guess. For example, if a
hostname is "gaia", a GRANT of 'user'@'gaia' works correctly, but not the
above wildcard. Our connections are all over a local area network. Can
anyone shed light on how to force connecting clients to be recognized with a
fully qualified hostname so we don't have to keep track of GRANTs for every
one of our spamd client machines?
Thanks!
/etc/hosts is your friend.. have a simple mapping of the IP to Hostname
(assuming that the IP address doesn't change) and a corresponding entry
for the hostname in the mysql (db/user) tables.
Also make sure you have this in /etc/nsswitch.conf, to ensure that
/etc/hosts gets a higher priority over /etc/resolv.conf
hosts: files dns
- dhawal
