From owner-freebsd-ports@FreeBSD.ORG Wed Jan 26 16:14:53 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 720B116A4CE for ; Wed, 26 Jan 2005 16:14:53 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by mx1.FreeBSD.org (Postfix) with ESMTP id 73FEB43D45 for ; Wed, 26 Jan 2005 16:14:52 +0000 (GMT) (envelope-from metrol.net@gmail.com) Received: by wproxy.gmail.com with SMTP id 69so78293wra for ; Wed, 26 Jan 2005 08:14:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=I49jPRRRwspZ6kSGhUq9Hd66wwoXv2W1a3002DVyBbCiIOPTKn+zrDubUVnnOsczRDPaSP1SrjKHva//yKfLBo9hY0GT23RRqSZnAeesHxf5XCBxX4uFvP96mMJYBQXkBGEUcbLsOTV6YtX98j7DK3TIXaK/SZn/w51pVx7/44c= Received: by 10.54.18.34 with SMTP id 34mr10176wrr; Wed, 26 Jan 2005 08:14:18 -0800 (PST) Received: by 10.54.51.66 with HTTP; Wed, 26 Jan 2005 08:14:18 -0800 (PST) Message-ID: Date: Wed, 26 Jan 2005 08:14:18 -0800 From: Michael Collette To: freebsd-ports@freebsd.org In-Reply-To: <20050126125251.GA2034@isis.wad.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <672DC1EE-6C10-11D9-9754-003065C7DFE8@quinn.com> <20050126125251.GA2034@isis.wad.cz> cc: Roman Neuhauser cc: Fred Condo Subject: Re: MySQL 4.0.23a on 5-STABLE has a startup glitch X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Michael Collette List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Jan 2005 16:14:53 -0000 On Wed, 26 Jan 2005 13:52:51 +0100, Roman Neuhauser wrote: > # fcondo@quinn.com / 2005-01-21 16:56:09 -0800: > > On Jan 21, 2005, at 2:43 PM, Michael Collette wrote: > > >On 5-STABLE I am unable to get mysql-server-4.0.23a to start with the > > >rcng script. Upon launching the script it dumps me to a prompt owned > > >by the mysql user. I have run into one other user on the mailing > > >lists with the same exact problem. > > > I'm seeing identical behavior under FreeBSD 4.10-p5 with MySQL 4.1.9. I > > finally traced the execution of the startup script by invoking it as: > > > > sh -x /usr/local/etc/rc.d/mysql-server.sh start > > > > The resulting output showed this detail: > > > > + su -m mysql -c sh -c "/usr/local/bin/mysqld_safe --user=mysql > > --datadir=/var/db/mysql --pid-file=/var/db/mysql/OBFUSCATED.pid > > > /dev/null &" > > bash: no job control in this shell > > That looks like you have installed bash and replaced the original > /bin/sh with (a link to) bash and/or have a strange $PATH. > > I strongly suggest you don't try to use bash as /bin/sh: it's a poor > /bin/sh lookalike, and will e. g. break quite a few jobs in > periodic(8). I know I haven't done that here. Bash is my default shell, but I didn't do any messing around with linking away from sh. I'm getting the exact same symptoms here on 5-STABLE. MySQL doesn't start with the new rcng script, and it just sits there at a prompt owned by the mysql user. It will do this when I try to launch it manually or at boot. Running ps ax shows that "su -m mysql" line that Fred mentioned. I just don't quite get why this needs to launch with su anyway. Isn't that what the --user switch is for in the mysqld_safe command? -- "When you come to a fork in the road....Take it" - Yogi Berra