From owner-freebsd-questions@FreeBSD.ORG Wed Jan 6 16:17:06 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 50E8F1065670 for ; Wed, 6 Jan 2010 16:17:06 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id A85F28FC1E for ; Wed, 6 Jan 2010 16:17:05 +0000 (UTC) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.4/8.14.3) with ESMTP id o06GH0qc013930; Wed, 6 Jan 2010 16:17:00 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk o06GH0qc013930 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1262794621; bh=5xa/GMtM8DJr2iKNMjVYW8BNnUYJUVrqEDkblrceKNA=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4B44B776.9050300@infracaninophile.co.uk>|Date:=20W ed,=2006=20Jan=202010=2016:16:54=20+0000|From:=20Matthew=20Seaman= 20|Organization:=20Infracaninophi le|User-Agent:=20Thunderbird=202.0.0.23=20(X11/20091129)|MIME-Vers ion:=201.0|To:=20lists@midsummerdream.org|CC:=20freebsd-questions@ freebsd.org|Subject:=20Re:=20mysql=20not=20starting=20on=20boot|Re ferences:=20<4B44B376.2010005@midsummerdream.org>|In-Reply-To:=20< 4B44B376.2010005@midsummerdream.org>|X-Enigmail-Version:=200.95.6| Content-Type:=20multipart/signed=3B=20micalg=3Dpgp-sha256=3B=0D=0A =20protocol=3D"application/pgp-signature"=3B=0D=0A=20boundary=3D"- -----------enig2CB73EA3F5C3867F0F20F347"; b=DJtWFu03ZRSjiyncuEJIfZVHrixE+mApnknGQoIwh0NL4NT1+JMqSRWbWOxYPoERg 2nB0zKk4bw0ptwEEpFkqEBAb3jhFBxc3JqXL/JcJu3LOiQ9c6koCR0SZZz4J3ThQ4K Wh/VAW92OOuX4jF0bUiYuv83dt4CjpOlKRE5H+Es= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <4B44B776.9050300@infracaninophile.co.uk> Date: Wed, 06 Jan 2010 16:16:54 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.23 (X11/20091129) MIME-Version: 1.0 To: lists@midsummerdream.org References: <4B44B376.2010005@midsummerdream.org> In-Reply-To: <4B44B376.2010005@midsummerdream.org> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig2CB73EA3F5C3867F0F20F347" X-Virus-Scanned: clamav-milter 0.95.3 at happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: mysql not starting on boot X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 Jan 2010 16:17:06 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2CB73EA3F5C3867F0F20F347 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable 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 lookin= g=20 > at the mysql log I see: >=20 > 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!:=20 > Unknown er > ror: 0 > 100105 17:46:56 [ERROR] Aborting >=20 > I use dhcp and ddns in my network, so I'm guessing that mysql is=20 > attempting to start before the networking has stabilized. Is there a=20 > 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. =20 > I tried adding: >=20 > # REQUIRE: NETWORKING >=20 > To the init script, but that didn't seem to have any effect. Is there = a=20 > 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 'DHC= P' 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 --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enig2CB73EA3F5C3867F0F20F347 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREIAAYFAktEt3wACgkQ8Mjk52CukIznKwCgk5KkRkn2goAeJ7L/zYzYgzNY 7YUAnREASgJivJ64gOTeetzU6GWOI1JT =+mqU -----END PGP SIGNATURE----- --------------enig2CB73EA3F5C3867F0F20F347--