MySQL not restarted after portupgrade

[Dan Nelson]

In the last episode (Nov 03), Andrew Berry said:
> For some reason, after running portupgrade databases/mysql51-server,
> MySQL is brought down, but not restarted. It's not a huge issue, as I
> just have to remember to run the rc.d script after upgrading, but I
> was wondering if anyone else had seen this? portupgrade seems to work
> fine with other daemons such as Apache and Courier IMAP.

It's in the pkg-list.  The first line is "@stopdaemon mysql-server", so
any time you upgrade the port, it kills mysql.  Enough ports do this,
and it's so annoying, that I recommend just disabling it completely:

--- bsd.port.mk	5 Sep 2008 19:41:43 -0000	1.604
+++ bsd.port.mk	8 Oct 2008 06:21:55 -0000
@@ -1588,10 +1588,9 @@
 		DATADIR=${DATADIR} DOCSDIR=${DOCSDIR} EXAMPLESDIR=${EXAMPLESDIR} \
 		WWWDIR=${WWWDIR} ETCDIR=${ETCDIR}
 
-PLIST_REINPLACE+=	dirrmtry stopdaemon rmtry
+PLIST_REINPLACE+=	dirrmtry rmtry
 PLIST_REINPLACE_DIRRMTRY=s!^@dirrmtry \(.*\)!@unexec rmdir %D/\1 2>/dev/null || true!
 PLIST_REINPLACE_RMTRY=s!^@rmtry \(.*\)!@unexec rm -f %D/\1 2>/dev/null || true!
-PLIST_REINPLACE_STOPDAEMON=s!^@stopdaemon \(.*\)!@unexec %D/etc/rc.d/\1${RC_SUBR_SUFFIX} forcestop 2>/dev/null || true!
 
 # kludge to strip trailing whitespace from CFLAGS;
 # sub-configure will not # survive double space


Some ports run the rc.d script themselves on uninstall (sysutils/hal,
for exmaple), so you have to edit the pkg-plist file and remove the
unexec line from those manually.

-- 
	Dan Nelson
	dnelson at allantgroup.com