From owner-freebsd-questions@FreeBSD.ORG Mon Nov 26 02:51:08 2007 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 0FABC16A420 for ; Mon, 26 Nov 2007 02:51:08 +0000 (UTC) (envelope-from jekillen@prodigy.net) Received: from smtp105.sbc.mail.mud.yahoo.com (smtp105.sbc.mail.mud.yahoo.com [68.142.198.204]) by mx1.freebsd.org (Postfix) with SMTP id C658613C4D5 for ; Mon, 26 Nov 2007 02:51:07 +0000 (UTC) (envelope-from jekillen@prodigy.net) Received: (qmail 56848 invoked from network); 26 Nov 2007 02:50:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=prodigy.net; h=Received:X-YMail-OSG:In-Reply-To:References:Mime-Version:Content-Type:Message-Id:Content-Transfer-Encoding:Cc:From:Subject:Date:To:X-Mailer; b=Fcyik63lnH2ZpIeDXv9BzJoDxV9jLoy3X4gqH09h6xLrUjAsH9nBQWELgA68HONsWXybsIUEvERxBWCxSXp14q5iRdsJwvSnh2Vt7K3hR9dk4DdMJ4uO76hK1S1ZNTwzRzkof+2xxJZFXq+6G37Cj9yirGFUmHGPns6og6BSUZY= ; Received: from unknown (HELO ?75.7.236.228?) (jekillen@prodigy.net@75.7.236.228 with plain) by smtp105.sbc.mail.mud.yahoo.com with SMTP; 26 Nov 2007 02:50:57 -0000 X-YMail-OSG: MO1L8LgVM1n.bdIOYbYRqSDmDN5DctuHcICGXmpiClz5j6irxNqXRs7POlILNhMnl3s7nZQO8Q-- In-Reply-To: <3710.10.202.77.103.1196026478.squirrel@webmail.superhero.nl> References: <81137B0FC6F246FA30ECC1DD@paul-schmehls-powerbook59.local> <7E797148-F4F1-4BE8-B086-6E54B53BD2C6@gmail.com> <3710.10.202.77.103.1196026478.squirrel@webmail.superhero.nl> Mime-Version: 1.0 (Apple Message framework v622) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: jekillen Date: Sun, 25 Nov 2007 18:51:52 -0800 To: "Gelsema, P \(Patrick\)" X-Mailer: Apple Mail (2.622) Cc: User Questions Subject: Re: short Q 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: Mon, 26 Nov 2007 02:51:08 -0000 On Nov 25, 2007, at 1:34 PM, Gelsema, P ((Patrick)) wrote: > On Sun, November 25, 2007 21:18, Shantanoo Mahajan wrote: >> >> On 26-Nov-07, at 1:23 AM, Paul Schmehl wrote: >> >>> --On November 23, 2007 9:04:01 PM -0800 jekillen >>> wrote: >>> >>>> Hello: >>>> Is this the way to start mysqld in rc.conf? >>>> mysqld_enable="YES" > > head /usr/local/etc/rc.d/mysql-server > # > # Add the following line to /etc/rc.conf to enable mysql: > # mysql_enable (bool): Set to "NO" by default. > # Set it to "YES" to enable MySQL. > # mysql_limits (bool): Set to "NO" by default. > # Set it to yes to run `limits -e -U mysql` > # just before mysql starts. > # mysql_dbdir (str): Default to "/var/db/mysql" > # Base database directory. > # mysql_args (str): Custom additional arguments to be passed > # to mysqld_safe (default empty). > > > Cheers > > Patrick > >>>> >>> Most ports that have daemons will have startup scripts in /usr/ >>> local/etc/rc.d/. Most of those scripts will include comments about >>> what switches are required in /etc/rc.conf to start the daemon. >>> Look there first for instructions. >>> >>> If you look at the mysqld startup script in /usr/local/etc/rc.d, >>> you will notice that it says use msyqld_enable="YES" in /etc/rc.conf. >> >> I do not have freebsd machine around to verify, but iirc, its >> 'mysql_enable' >> and not 'mysqld_enable'. >> >> regards, >> shantanoo Thank you all for responses. I did get this straightened out: It is mysql_enable="YES" and putting a script named mysql in the /etc/rc.d directory with the lines; #! /bin/sh /usr/local/bin/mysqld_safe --user=mysql & did the trick. This is what the mysql docs prescribe for starting the server. Perhaps that is not the best way to go about it at system start, but it works. Thanks again; Jeff K