Hello.


> All other applications properly do lookups, inclusing Apache, PHP,

> exim4 and

> courier-mta.





Please check that you can find afterparty.local using `host` utility

and able connect to it with mysql client. Send an output

of the following statement executed on the weird server:



 SHOW VARIABLES;









"Thomas van Gulick" <[EMAIL PROTECTED]> wrote:

> I'm running multiple mysql servers on a local network. One of them has an 

> additional network interface to the outside world. This server is the only 

> one properly resolving any hostnames. All other servers fail to resolv 

> anything.

> 

> I'm running bind9 named for my outside domain and a local domain and I've 

> notices the Mysql daemons except the one with outside link, fail to do any 

> domain lookup, there are no packets sent over port 53, while the Mysql 

> daemon with outside link properly does a lookup request on port 53 to my 

> name daemon.

> 

> Using IPs all is fine, replication starts normally, but when using the 

> hostnames, the Mysql daemon fails to connect to it's master with "Error: 

> Unknown MySQL server host 'afterparty.local' (2)' errno: 2005."

> 

> All other applications properly do lookups, inclusing Apache, PHP, exim4 and 

> courier-mta.

> 

> So, to summarize. IP works, hostname doesn't.

> On the server with outside link, hostname works, using the same my.cnf, 

> hosts, resolv.conf and host.conf.

> Same libc too.

> Same Mysql version too (4.1.8 icc version, I've tried 4.1.10a to no avail)

> 

> Can anyone thing of anything that might cause this? Many thanks!

> 

> Thomas



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to