On 9/30/07, Chris Janton <face@centosprime.com> wrote:
I am trying to get mysql to start/restart properly on my system.

sudo port install mysql5 +darwin_8 +server
...

I get the output

--->  Creating launchd control script
##############################
#############################
# A startup item has been generated that will aid in
# starting mysql5 with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo launchctl load -w /Library/LaunchDaemons/
org.macports.mysql5.plist
##############################
#############################

I finish up (after the installation) with

sudo launchctl load -w /Library/LaunchDaemons/org
.macports.mysql5.plist
nothing found to load

hmmm - any ideas why this isn't found/loaded/etc ?

what does  `locate org.macports.mysql5.plist` give you? 

I get:
/Library/LaunchDaemons/org.macports.mysql5.plist
/opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist

file /Library/LaunchDaemons/org.macports.mysql5.plist
/Library/LaunchDaemons/org.macports.mysql5.plist: symbolic link to `/opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist'

The symlink will allow to keep the file(s) MacPorts needs in the /opt/local tree and still get them to fire at boot time. 

Conversely, you can add the appropriate lines to launchd.conf and get things going. 

more /etc/launchd.conf 
launchctl  load /opt/local/etc/LaunchDaemons/org.macports.dbus/org.macports.dbus.p
list 
launchctl  load /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apa
che2.plist 
launchctl  load /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysq
l5.plist 

I would vote for MacPorts to take the latter approach, with the post-install message explaining that

########
## To get the application to run at boot time, 
## echo launchctl  load /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist >> /etc/launchd.conf
## 
##########

--
Paul Beard / www.paulbeard.org/
<paulbeard@gmail.com/paulbeard@mac.com>