From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 28 05:46:39 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 65BD5106567A
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Aug 2008 05:46:39 +0000 (UTC)
	(envelope-from dpchrist@holgerdanske.com)
Received: from holgerdanske.com (holgerdanske.com [65.19.145.106])
	by mx1.freebsd.org (Postfix) with SMTP id 55F5C8FC08
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Aug 2008 05:46:39 +0000 (UTC)
	(envelope-from dpchrist@holgerdanske.com)
Received: from a64x23800p ([64.142.42.100]) by holgerdanske.com for
	<freebsd-questions@freebsd.org>; Wed, 27 Aug 2008 22:46:36 -0700
From: "David Christensen" <dpchrist@holgerdanske.com>
To: <freebsd-questions@freebsd.org>
References: <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p>
	<20080827053200.GA7476@bacardi.frase.id.au>
Date: Wed, 27 Aug 2008 22:46:31 -0700
Message-ID: <1587E1CA38444A64AC903BEA6D1B9CA9@a64x23800p>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
Thread-Index: AckIBls4JHbo1l6fReGpVhrJVkHHLwAwjL8w
In-Reply-To: <20080827053200.GA7476@bacardi.frase.id.au>
Subject: RE: mysql-server-5.1.22 system administration docs on
	FreeBSD7.0-RELEASE-i386 ?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
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: Thu, 28 Aug 2008 05:46:39 -0000

Fraser Tweedale wrote:
> put the following line in /etc/rc.conf:
>     mysql_enable="YES"
> and run (as root):
> /usr/local/etc/rc.d/mysql-server start
 
    # echo 'mysql_enable="YES"' >> /etc/rc.conf

    # /usr/local/etc/rc.d/mysql-server start
    Starting mysql.

    # mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.1.22-rc FreeBSD port: mysql-server-5.1.22

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql>

Ahhh -- much better.  :-)


The explanation is here:

 
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-rcd.html

    Since the rc.d system is primarily intended to start/stop services
    at system startup/shutdown time, the standard start, stop and
    restart options will only perform their action if the appropriate
    /etc/rc.conf variables are set. For instance the above sshd restart
    command will only work if sshd_enable is set to YES in
    /etc/rc.conf. ...


freebsdemail@gmail.com wrote:
> Try adding mysql_enable="YES" to /etc/rc.conf after this is done try
> starting again via the rc script. In the future pass the parameter
> rcvar to the rc script.
> Eg. /usr/local/etc/rc.d/mysql-server rcvar
> mysql_enable="YES" this would indicate what to add to rc.conf

    # /usr/local/etc/rc.d/mysql-server rcvar
    # mysql
    mysql_enable=YES

The explanation is here:

 
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-rcd.html

    It is easy to check if a service is enabled in /etc/rc.conf by
    running the appropriate rc.d script with the option rcvar. Thus, an
    administrator can check that sshd is in fact enabled in
    /etc/rc.conf by running:

    # /etc/rc.d/sshd rcvar
    # sshd
    $sshd_enable=YES


Thanks!

David