From owner-freebsd-questions@FreeBSD.ORG Fri May 6 18:03:46 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 D53D516A4D4 for ; Fri, 6 May 2005 18:03:46 +0000 (GMT) Received: from clunix.cl.msu.edu (clunix.cl.msu.edu [35.9.2.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8692D43DA0 for ; Fri, 6 May 2005 18:03:46 +0000 (GMT) (envelope-from jerrymc@clunix.cl.msu.edu) Received: from clunix.cl.msu.edu (localhost [127.0.0.1]) j46I3jJF013710; Fri, 6 May 2005 14:03:45 -0400 (EDT) Received: (from jerrymc@localhost) by clunix.cl.msu.edu (8.12.10+Sun/8.12.2/Submit) id j46I3jon013709; Fri, 6 May 2005 14:03:45 -0400 (EDT) From: Jerry McAllister Message-Id: <200505061803.j46I3jon013709@clunix.cl.msu.edu> To: paul_s_keyes@yahoo.ca (Paul Keyes) Date: Fri, 6 May 2005 14:03:45 -0400 (EDT) In-Reply-To: <20050506175218.40330.qmail@web32107.mail.mud.yahoo.com> X-Mailer: ELM [version 2.5 PL7] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: starting mysql server automatically 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: Fri, 06 May 2005 18:03:46 -0000 > > Hi All, > > I'm setting up a server running Freebsd 5.3 I have > mysql running well but I can't seem to get it to start > automatically at boot time. I can only start it as > root with the command: > mysqld_safe --user=mysql & > > (when I do this everything works fine) > > I tried installing the mysql.server sript as: > /usr/local/etc/rc.d/mysql.server.sh > but when I try to run it manually I get this: > ./mysql.server.sh: 102: Syntax error: Bad for loop > variable > > What is the best way to get the mysql server running > automatically when the computer boots? Well, you probably will have to fix the for loop problem You may have to set a variable in your rc.conf or earlier in the mysql.server.sh. Usually that script works just fine so, either something got changed, something is in a differnt than usual place or some value didn't get set where it needs to be. It is hard to guess without seeing stuff and tinking with it. Probably there is only one for loop, so take a look at it and see what variable it is trying to use. Put some echo's in the startup script to find out where it is barfing if you need. ////jerry > > Thanks, > Paul >