mysqld startup problems

[Aidan Whyte]

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.