From: Date: December 29 2004 5:15pm
Subject: Re: host names don't work in config.ini
List-Archive: http://lists.mysql.com/cluster/1301
Message-Id: <41D2D838.1030107@wtxs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Mikael Ronström wrote:
> Hi Lewis,
> 
> 2004-12-28 kl. 22.15 skrev Lewis Bergman:
> 
>> After comparing Alex's config.ini and setup and mine they are both 
>> identical except he uses IP's and I was using host names. After 
>> changing mine to IP's both nodes connected.
>>
>> Can't seem to get the API's going yet but at least the nodes look right.
>>
>> This seems like a documentation glitch unless I am way off base with 
>> what i have tried.
> 
> 
> Hostnames certainly work with MySQL Cluster. But using hostnames 
> introduces quite a few error sources since a proper
> DNS lookup system must be set-up, sometimes /etc/hosts must be edited 
> and their might be security blocks ensuring that
> communication between certain machines is not possible other than on 
> certain ports. I remember a problem 5 years ago
> when at one site I needed to use hostnames without the full name (only 
> the name in the domain, e.g. mysql1) and in
> another site I needed to use full names e.g. mysql1.domain.se.
> 
> Thus if there are problems with host names it seems like a good path to 
> use IP-addresses instead.
> 
> MySQL Cluster uses gethostbyname or a variant of it to translate name so 
> to debug hostname problems please check:
> man gethostbyname
> 
> where particularly /etc/host.conf and /etc/hosts aer mentioned as 
> important and this manual page refer to the named service
> which uses /etc/bind/named.conf* as configuration files.
> 
> Rgrds Mikael
> 
As an additional note I found that I had no in-addr-arpa record on my name 
server. I don't know if that would have fixed my particular host name 
problem since the docs for gethostbyname don't mention doing in reverse 
checks but for the sake of completeness I thought this might help someone else.

-- 
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
325-691-3301
800-299-6962