From owner-freebsd-questions@FreeBSD.ORG Sat Apr 16 12:52:37 2005 Return-Path: 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 614AD16A4CE for ; Sat, 16 Apr 2005 12:52:37 +0000 (GMT) Received: from brian.firebadger.net (82-69-4-157.dsl.in-addr.zen.co.uk [82.69.4.157]) by mx1.FreeBSD.org (Postfix) with SMTP id 5F8A043D54 for ; Sat, 16 Apr 2005 12:52:34 +0000 (GMT) (envelope-from richard@firebadger.net) Received: (qmail 421 invoked from network); 16 Apr 2005 11:52:26 -0000 Received: from unknown (HELO ?192.168.1.10?) (192.168.1.10) by 192.168.1.15 with SMTP; 16 Apr 2005 11:52:26 -0000 Message-ID: <42610A85.3010907@firebadger.net> Date: Sat, 16 Apr 2005 13:52:21 +0100 From: Richard Collyer User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: MySql Server Not Starting X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 16 Apr 2005 12:52:37 -0000 Hello, Done a google on this and come up with nothing. I had this problem a week ago and found the solution but I cant find it again and its bugging me. in rc.conf I have mysqld_enable="YES" also I have mysql-server.sh in /usr/local/etc/rc.d/mysql-server.sh Upon boot or by running the script manually I get... (root@brian)-[/usr/local/libexec]$ /usr/local/etc/rc.d/mysql-server.sh --start (root@brian)-[/usr/local/libexec]$ I can run mysql by using ./mysqld -u mysql in /usr/local/libexec but that runs it constantly so killing the ssh session stops the server. I know the answer is going to be simple but I still cant find a reference to it on the web. Cheers Richard ---- mysql-server.sh ------ #!/bin/sh # # $FreeBSD: ports/databases/mysql40-server/files/mysql-server.sh.in,v 1.2 2005/04/11 09:33:11 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). # . /usr/local/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} --pi 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 2>&1 [ $? -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"