--- email builder <[EMAIL PROTECTED]> wrote:
> > > > 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. > > > > Um, not sure I follow you. We have this in /etc/hosts > > > > 10.10.10.50 gaia gaia.example.com > > > > So that DNS resolves correctly for our hosts. If I switch it to this, > will > > that do the trick? > > > > 10.10.10.50 gaia.example.com gaia > > > > No, doesn't seem to help. Our MySQL users are only allowed to log in if > > their hostname is just "gaia", whereas we'd like to just use > > "%.example.com" > > instead. The client gives the error: > > > > ERROR 1045 (28000): Access denied for user 'user'@'gaia' (using password: > > YES) > > Same happens with clients on the same machine, except the connection is > seen > from localhost (makes sense, sure, but I would like the connection to be > approved as if being made from any other machine in our LAN) > > Access denied for user 'user'@'localhost' (using password: YES) > Also tried putting '10.10.%' in the user table, but no dice. > > Which seems to indicate that the client is connecting with an unqualified > > hostname. However, the machine's hostname appears to be correct: > > > > # hostname > > gaia.example.com > > > > Surely I am missing something simple. :) > > > > > > > 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 > > > > > > > __________________________________ > Yahoo! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com > __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
