[mythtv] [mythtv-commits] Ticket #9756: DBHostName=localhost causes MythSocket to attempt to contact mysql on ::1 (ipv6 localhost)

[E. Westbrook]

On Sat, Apr 30, 2011 at 19:56, Gavin Hurlbut <gjhurlbu at gmail.com> wrote:

> On Sat, Apr 30, 2011 at 11:10 AM, <noreply at mythtv.org> wrote:
>
>> > I have a mysql.txt as follows.
>> >
>> > {{
>> > DBHostName=localhost
>>
>
> Check /etc/hosts.  Chances are localhost is mapped to the IPv6 address
> there, which you may want to try commenting out.
>

A better workaround to recommend would be to use the numeric ipv4 address
127.0.0.1 in mysql.txt, since other things will invariably depend on the
/etc/hosts mapping to ::1.

The preferred "proper" solution, of course, should be for the connecting
code to fail over to ipv4 (i.e. try ipv6 first, then ipv4) whenever a
hostname resolves to both ipv6 and ipv4 addresses (whether via /etc/hosts or
via A and AAAA records in DNS).

OpenSSH does it exactly this way and is a good model to follow.

Should I cross-post this advice to the ticket itself?

$0.02,
Eric
(HE.net Sage-Certified ipv6 Engineer)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-dev/attachments/20110502/eccd6fb0/attachment.html