From owner-freebsd-questions@FreeBSD.ORG Mon Sep 26 20:28:09 2005 Return-Path: X-Original-To: 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 57E8016A41F for ; Mon, 26 Sep 2005 20:28:09 +0000 (GMT) (envelope-from freebsd@redry.net) Received: from luke.segpub.com.au (luke.segpub.com.au [64.49.254.38]) by mx1.FreeBSD.org (Postfix) with ESMTP id AE4CB43D49 for ; Mon, 26 Sep 2005 20:28:07 +0000 (GMT) (envelope-from freebsd@redry.net) Received: (qmail 97363 invoked by uid 89); 27 Sep 2005 06:28:07 +1000 Received: by simscan 1.1.0 ppid: 97334, pid: 97348, t: 0.8937s scanners: clamav: 0.86.1/m:33/d:984 spam: 3.0.4 Received: from unknown (HELO ?192.168.1.33?) (213.202.164.201) by 0 with SMTP; 27 Sep 2005 06:28:06 +1000 In-Reply-To: <6.2.3.4.2.20050926131354.05b98e40@cobalt.antimatter.net> References: <6.2.3.4.2.20050926123752.0352ad60@cobalt.antimatter.net> <6.2.3.4.2.20050926131354.05b98e40@cobalt.antimatter.net> Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <92AE5A80-D02C-4475-9885-7B7BC0661EEB@redry.net> Content-Transfer-Encoding: 7bit From: eoghan Date: Mon, 26 Sep 2005 21:28:04 +0100 To: Glenn Dawson X-Mailer: Apple Mail (2.734) X-Spam-Checker-Version: SpamAssassin 3.0.4 (2005-06-05) on luke.segpub.com.au X-Spam-Level: X-Spam-Status: No, score=-2.6 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=3.0.4 Cc: freebsd-questions@freebsd.org Subject: Re: mysql port install 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 Sep 2005 20:28:09 -0000 On 26 Sep 2005, at 21:17, Glenn Dawson wrote: > At 01:04 PM 9/26/2005, eoghan wrote: > >> On 26 Sep 2005, at 20:40, Glenn Dawson wrote: >> >>> Make sure you have mysqld_enable"YES" in your /etc/rc.conf and then >>> use >>> /usr/local/etc/rc.d/mysql-server.sh start >>> to start the server. (you may nee to copy mysql-server.sh from >>> mysql-server.sh.sample first) >>> >> >> Hi Glenn >> Thanks! However, I get: >> #>/usr/local/etc/rc.d/mysql-server.sh start >> This: not found >> #> >> I have checked the dir and mysql-server.sh is there. >> Any ideas? >> > > Can you share the contents or your mysql-server.sh? > > Also, I'm cc'ing this over to freebsd-questions@ which is a more > appropriate list for this, lets continue on that list. > > -Glenn Thanks. Sorry about the wrong list! Ive copied the contents below. #!/bin/sh # # $FreeBSD: ports/databases/mysql41-server/files/mysql-server.sh.in,v 1.3 2005/04/11 08:47:36 ale Exp $ # # PROVIDE: mysql # REQUIRE: NETWORKING SERVERS # BEFORE: DAEMON # KEYWORD: shutdown # # 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). # . /etc/rc.subr name="mysql" rcvar=`set_rcvar` load_rc_config $name : ${mysql_enable="NO"} : ${mysql_limits="NO"} : ${mysql_dbdir="/var/db/mysql"} : ${mysql_args=""} mysql_user="mysql" mysql_limits_args="-e -U ${mysql_user}" pidfile="${mysql_dbdir}/`/bin/hostname`.pid" command="/usr/local/bin/mysqld_safe" command_args="--defaults-extra-file=${mysql_dbdir}/my.cnf --user=$ {mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} $ {mysql_args} > /dev/null &" procname="/usr/local/libexec/mysqld" start_precmd="${name}_prestart" mysql_install_db="/usr/local/bin/mysql_install_db" mysql_install_db_args="--ldata=${mysql_dbdir}" mysql_create_auth_tables() { eval $mysql_install_db $mysql_install_db_args >/dev/null [ $? -eq 0 ] && chown -R ${mysql_user}:${mysql_user} $ {mysql_dbdir} } mysql_prestart() { if [ ! -d "${mysql_dbdir}/mysql/." ]; then mysql_create_auth_tables || return 1 fi if checkyesno mysql_limits; then eval `/usr/bin/limits ${mysql_limits_args}` 2>/dev/null else return 0 fi } run_rc_command "$1"