From owner-freebsd-questions@FreeBSD.ORG Mon Sep 26 20:44:32 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 9C0B916A41F for ; Mon, 26 Sep 2005 20:44:32 +0000 (GMT) (envelope-from glenn@antimatter.net) Received: from cobalt.antimatter.net (cobalt.antimatter.net [69.55.224.239]) by mx1.FreeBSD.org (Postfix) with ESMTP id 33DE643D6E for ; Mon, 26 Sep 2005 20:44:30 +0000 (GMT) (envelope-from glenn@antimatter.net) Received: from glenn-mobile.antimatter.net (cpe-66-27-86-22.san.res.rr.com [66.27.86.22]) (authenticated bits=0) by cobalt.antimatter.net (8.13.4/8.13.4) with ESMTP id j8QKiS1a003843 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 26 Sep 2005 13:44:29 -0700 X-MailKey: purple frogs are falling from the sky Message-Id: <6.2.3.4.2.20050926133955.05746c80@cobalt.antimatter.net> X-Mailer: QUALCOMM Windows Eudora Version 6.2.3.4 Date: Mon, 26 Sep 2005 13:43:00 -0700 To: eoghan From: Glenn Dawson In-Reply-To: <92AE5A80-D02C-4475-9885-7B7BC0661EEB@redry.net> References: <6.2.3.4.2.20050926123752.0352ad60@cobalt.antimatter.net> <6.2.3.4.2.20050926131354.05b98e40@cobalt.antimatter.net> <92AE5A80-D02C-4475-9885-7B7BC0661EEB@redry.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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:44:32 -0000 At 01:28 PM 9/26/2005, eoghan wrote: >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. I see a couple things, scroll down... >#!/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} -- There's an extra space after --user=$ >datadir=${mysql_dbdir} --pid-file=${pidfile} $ {mysql_args} > /dev/null &" another extra space after $ and before {mysql_args} Not sure if those were because of the way you pasted the file, or if they are really there, but you'll want to check that out first. -Glenn >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" > > >_______________________________________________ >freebsd-questions@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"