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

[Kerin Millar]

On 23/01/2013 18:58, Manuel McLure wrote:
> I'm having a problem with booting my Gentoo system due to MySQL
> hanging at startup. My system is up-to-date stable (including
> udev-197, although I believe the problem started while I was still on
> 171) except for the kernel, which is at 3.1.10 because I can't seem to
> get lirc to work correctly on newer kernels. The problem started after
> a large system update just before the udev 171 to 197 migration. Among
> other upgrades dhcpcd was upgraded from 5.2.12 to 5.6.4, net-tools was
> upgraded from 1.60_p20110409135728 to 1.60_p20120127084908, and openrc
> was upgraded from 0.9.8.4 to 0.11.8.

<snip additional info>

> 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?

I can't determine what the problem is exactly but I can offer some hints ...

You should detail your my.cnf file. By default, the mysql runscript 
depends only on net.lo. There's nothing wrong with that unless you are 
binding to a specific address. Using "skip-name-resolve" is also 
helpful, provided that you don't require host names to be resolved for 
your grant tables to work correctly.

If the nature of your configuration is such that a specific interface 
must be up then you can insert the following lines in /etc/conf.d/mysql:

rc_use="net.eth1"
rc_after="net.eth1"

NOTE: You need not - and should not - edit the mysql runscript directly 
in order to customize its dependencies.

This particular caveat is described by the comments in that file, along 
with several others. I'd suggest taking a look at these comments if you 
haven't already done so.

Cheers,

--Kerin