From owner-freebsd-isp Thu Feb 3 0: 5: 1 2000 Delivered-To: freebsd-isp@freebsd.org Received: from calumet.infoteam.com (calumet.infoteam.com [207.246.83.3]) by builder.freebsd.org (Postfix) with ESMTP id 415BB4309 for ; Thu, 3 Feb 2000 00:04:59 -0800 (PST) Received: (from kmartin@localhost) by calumet.infoteam.com (8.8.8/8.8.8) id DAA10210 for freebsd-isp@FreeBSD.ORG; Thu, 3 Feb 2000 03:05:03 -0500 (EST) (envelope-from kmartin) Date: Thu, 3 Feb 2000 03:05:03 -0500 From: Kenn Martin To: freebsd-isp@FreeBSD.ORG Subject: Re: controlling local boot sequence Message-ID: <20000203030503.A10082@infoteam.com> References: <20000201175018.A21189@infoteam.com> <20000201194931.B3152@numachi.com> <20000201223115.A24239@infoteam.com> <20000202122914.A13278@numachi.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0.1i In-Reply-To: <20000202122914.A13278@numachi.com>; from reichert@numachi.com on Wed, Feb 02, 2000 at 12:29:14PM -0500 Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Wed, Feb 02, 2000 at 12:29:14PM -0500, Brian Reichert wrote: > On Tue, Feb 01, 2000 at 10:31:15PM -0500, Kenn Martin wrote: > > OK. Looking into this, but I just need to figure out which MySQL > > file(s) to run lsof against. It seems that most aren't open right > > after startup :-( But anyway, I think that I am getting closer to > > a better solution. > > I use either to the socket ( '/tmp/mysql.sock' ) or the network > port ( 'TCP:3306' ), as per your local install. I suppose the > socket is best, as MySQL can be started w/o a netwotk connection... Well, for anyone that is interested, using netstat to check for the socket appears to work very reliably. Here is my new mysql-server startup script. I have it echo the dot in the loop just so I can visually see what is happening on the console. It always echoes one or two dots (depending on the system). kmartin@alydar$ cat /usr/local/etc/rc.d/340.mysql-server.sh #!/bin/sh if [ -x /usr/local/bin/safe_mysqld ] then /usr/local/bin/safe_mysqld --user=mysql > /dev/null & && echo -n ' mysql' # make sure that our sockets have initialized before continuing # as other startup daemons depend on us until /usr/bin/netstat | grep mysql\.sock > /dev/null; do echo -n "."; sleep 1; done fi -- Kenn Martin To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message