Re: [gentoo-user] MySQL startup problem - interface does not have an address yet.

[Stroller]

On 23 January 2013, at 18:58, Manuel McLure wrote:
> … eth0 is not configured any more (it used to be used for IPTV
> connectivity to my cable provider for MythTV before they changes their
> system.) eth1 is configured via DHCP to an RFC 1918 10.x.x.x address -
> the DHCP server is always configured to provide the same IP address
> for this system. net.eth1 is symlinked to /etc/runlevels/default.
>
> The boot process starts, configures eth1, starts LCDd, and then
> attempts to start MySQL - and hangs for about 15 minutes before
> continuing with the boot.
>
> I added several debugging statements to /etc/init.d/mysql and found
> that even though the log shows that eth1 got its IP address, when
> MySQL attempts to start the interface does not have an IP address
> assigned. It's like the net.eth1 script exits before the interface is
> completely up.

I think, to be rigorous, I would want to test this system (I'm not saying you should keep it this way) by setting the IP address statically for eth1. 

From what I'm understanding, this doesn't sound like a MySQL problem, but a DHCP problem.

You're checking the IP address with ifconfig - I believe that is deprecated. I guess at some point you might replace that in your `echo > test.log` scripts with the newer tools, just to make sure they say the same thing. Maybe this is paranoia, but you know what they say about that.

http://blog.timheckman.net/2011/12/22/why-you-should-replace-ifconfig/

> ...
> eth1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
>        inet6 NNNN:NNNN:NNNN:NNNN:NNNN:NNNN:NNNN:NNNN  prefixlen 64
> scopeid 0x0<global>
>        inet6 NNNN::NNNN:NNNN:NNNN:NNNN  prefixlen 64  scopeid 0x20<link>

I don't think these are valid IPv6 addresses. If you're not using IPv6 then I would recommend removing the IPv6 USE flag globally and remerging everything --newuse. This will ensure nothing is depending upon IPv6 or expecting it or waiting for it.

> The entries for eth1 in /etc/conf.d/net are:
>
> config_eth1="dhcp"
> routes_eth1="239.0.0.0/8"

Is this right?

> I could add a delay to the mysql script to ensure startup, but I'd
> rather figure out why the IP address is not yet available even though
> the net.eth1 script has completed. Does anyone have any hints on what
> could be going wrong?

There are several DHCP clients available in Portage. 

You need to tell us which one you're using.

It wouldn't do any harm to experiment with one or two others.

I think that a busybox version may be installed on some systems, and that this may interfere or misbehave. I don't know if a bug report has been filed for this.6

Stroller.