From owner-freebsd-questions@FreeBSD.ORG Sun Aug 28 20:50:20 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 04FDA16A41F for ; Sun, 28 Aug 2005 20:50:20 +0000 (GMT) (envelope-from aidanwhyte@eircom.net) Received: from ni-mail3.dna.utvinternet.net (mail3.u.tv [194.46.8.37]) by mx1.FreeBSD.org (Postfix) with ESMTP id 797CD43D46 for ; Sun, 28 Aug 2005 20:50:19 +0000 (GMT) (envelope-from aidanwhyte@eircom.net) Received: from [10.4.1.34] (unverified [194.46.226.80]) by ni-mail3.dna.utvinternet.net (Vircom SMTPRS 4.1.361.20) with ESMTP id for ; Sun, 28 Aug 2005 21:50:15 +0100 Message-ID: <43122387.3090202@eircom.net> Date: Sun, 28 Aug 2005 21:50:15 +0100 From: Aidan Whyte User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) 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: mysqld startup problems 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: Sun, 28 Aug 2005 20:50:20 -0000 Hi. I've freshly installed FreeBSD 5.4 and brought it up to -stable sources (as of yesterday). I installed mysqld 4.1 from the ports tree. The install went fine. I put mysql_enable="YES" into /etc/rc.conf and then tried /usr/local/etc/rc.d/mysql-server.sh start. The following happens when i try that.. [root]@[/] # /usr/local/etc/rc.d/mysql-server.sh status mysql is not running. [root]@[/] # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. [mysql]@[/] # ps -aux | grep mysql root 93645 0.0 0.3 1768 1224 p0 S 9:45PM 0:00.03 /bin/sh /usr/local/etc/rc.d/mysql-server.sh start root 93654 0.0 0.3 1620 1184 p0 S 9:45PM 0:00.02 su -m mysql -c sh -c "/usr/local/bin/mysqld_safe --defaults-extra- mysql 93655 0.0 0.4 3088 1672 p0 S 9:45PM 0:00.04 /usr/local/bin/bash mysql 93657 0.0 0.2 1432 824 p0 R+ 9:45PM 0:00.01 ps -aux mysql 93658 0.0 0.2 1484 816 p0 S+ 9:45PM 0:00.01 grep mysql [mysql]@[/] # exit exit [root]@[/] # ps -aux | grep mysql root 93660 0.0 0.2 1484 816 p0 S+ 9:46PM 0:00.01 grep mysql [root]@[/] # Notice that rc.d/mysql-server.sh switches my user to 'mysql' and when i exit out of it, all the mysql processes are gone. I can manually start /usr/local/bin/mysqld_safe fine. I haven't modified any of the mysql installation, startup scripts, or anything else that I can think of which would cause this to happen. Does anyone have any ideas where I could look for problems? Thanks, Aidan.