From owner-freebsd-questions@FreeBSD.ORG  Mon May  9 19:07:48 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 8043816A4EA
	for <freebsd-questions@freebsd.org>;
	Mon,  9 May 2005 19:07:48 +0000 (GMT)
Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101])
	by mx1.FreeBSD.org (Postfix) with ESMTP id F3D1F43D31
	for <freebsd-questions@freebsd.org>;
	Mon,  9 May 2005 19:07:47 +0000 (GMT)
	(envelope-from dan@dan.emsphone.com)
Received: (from dan@localhost)
	by dan.emsphone.com (8.13.1/8.13.3) id j49J7lpT065854;
	Mon, 9 May 2005 14:07:47 -0500 (CDT)
	(envelope-from dan)
Date: Mon, 9 May 2005 14:07:47 -0500
From: Dan Nelson <dnelson@allantgroup.com>
To: Paul Keyes <paul_s_keyes@yahoo.ca>
Message-ID: <20050509190747.GG38839@dan.emsphone.com>
References: <20050509185100.53324.qmail@web32105.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050509185100.53324.qmail@web32105.mail.mud.yahoo.com>
X-OS: FreeBSD 5.4-STABLE
X-message-flag: Outlook Error
User-Agent: Mutt/1.5.8i
cc: Chris Hodgins <christopher.hodgins@gmail.com>
cc: freebsd-questions@freebsd.org
Subject: Re: starting mysql server automatically
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 09 May 2005 19:07:48 -0000

In the last episode (May 09), Paul Keyes said:
> I tried adding mysql_enable="YES" to /etc/rc.conf and
> rebooted but sockstat -4 | grep mysql showed nothing
> and mysql server wasn't running.
> 
> Some information about my system:
> 
> $uname -r
> 5.3-RELEASE
> 
> $pkg_info | grep mysql
> mysql-client-5.0.3_1 Multithreaded SQL database(client)
> mysql-server-5.0.3_1 Multithreaded SQL database(server)

Try building the mysql50-server and mysql50-client ports; they come
with FreeBSD-style startup scripts.  What you pasted looks like the
generic one shipped with the source distribution, and it doesn't look
like it got installed right:

> if test -z "$basedir"
> then
>   basedir=@prefix@
>   bindir=@bindir@
>   datadir=@localstatedir@
>   sbindir=@sbindir@
> else
>   bindir="$basedir/bin"
>   sbindir="$basedir/sbin"
> fi

The @xxx@ blocks should have been replaced with paths to
/usr/local/something .

-- 
	Dan Nelson
	dnelson@allantgroup.com