To the mysql init script, I added:
# REQUIRE: dhclient
And to the dhclient init script I added:
# REQUIRE: NETWORKING
In addition to changing DHCP to SYNCDHCP in rc.conf, mysql now starts up
on boot. I would think the dhclient change should be required in the
default setup since NETWORKING should be up before attempting to grab a
dhcp IP, or am I misunderstanding here?
Either way, the above seems to have solved my problem. Thanks!
Rob
Matthew Seaman wrote:
Rob wrote:
Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting
on boot anymore. It starts fine once the system has booted, and
looking at the mysql log I see:
100105 17:46:56 mysqld_safe Starting mysqld daemon with databases from
/var/db/m
ysql
100105 17:46:56 [ERROR] Can't start server: cannot resolve hostname!:
Unknown er
ror: 0
100105 17:46:56 [ERROR] Aborting
I use dhcp and ddns in my network, so I'm guessing that mysql is
attempting to start before the networking has stabilized. Is there a
way to make mysql be the last thing started at boot?
MySQL will be happy if it can work out what the hostname of the machine
is. You say you're using ddns? If that means your machines are pushing
a hostname up to the DHCP server while they ask it for an IP number, then
there should be no problem.
You can simply set the hostname in /etc/rc.conf -- it doesn't really
matter if the machine thinks its name is one thing, and the IPs on its
network interfaces resolve to something else (at least, not for the
purposes of running mysql.). The thing you'ld have to look out for are
the host part of usernames in grants of permissions to users.
I tried adding:
# REQUIRE: NETWORKING
To the init script, but that didn't seem to have any effect. Is there
a tool that will run through all the init scripts and tell you the
order of startup?
rcorder(8)
You might also find it beneficial to use 'SYNCDHCP' instead of plain 'DHCP'
in ifconfig_XXY lines in /etc/rc.conf -- this will cause the boot
process to
block on getting an IP for the interface, rather than the default action of
backgrounding that process and trying to start everything else up.
Cheers,
Matthew
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[email protected]"
