mysqld startup problems

[Aidan Whyte]

Anyone have any ideas at all about this?


Aidan.

Aidan Whyte wrote:
> 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.