ports/79166: Deinstalling databases/mysql*-server kills all mysql servers in system's jails

[Sergey Prikhodko]

>Number:         79166
>Category:       ports
>Synopsis:       Deinstalling databases/mysql*-server kills all mysql servers in system's jails
>Confidential:   no
>Severity:       serious
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Wed Mar 23 18:50:02 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Sergey Prikhodko <sergey at network-asp.biz>
>Release:        FreeBSD 5.2.1-RELEASE-p13 i386
>Organization:
Network-ASP
>Environment:
System: FreeBSD network-asp.biz 5.2.1-RELEASE-p13 FreeBSD 5.2.1-RELEASE-p13 #4: Mon Jan 24 15:00:06 EET 2005 root at network-asp.biz:/usr/obj/usr/src/sys/RKERNEL i386

>Description:

	Deinstallation of one of mysql*-server ports causes killing of all mysqld 
	instances in all system's jails.
	It occurs because of '@unexec killall mysqld' command in port plist.

>How-To-Repeat:

	1. Run mysql server on jail and master
	2. Try deinstall mysql-server on master
	3. Wait for jail users start to complain :)
>Fix:

--- mysql323-server.diff begins here ---
diff -ruN mysql323-server.orig/pkg-plist mysql323-server/pkg-plist
--- mysql323-server.orig/pkg-plist	Wed Mar 16 09:35:27 2005
+++ mysql323-server/pkg-plist	Wed Mar 23 19:57:06 2005
@@ -124,4 +124,4 @@
 @dirrm %%DATADIR%%/swedish
 @dirrm %%DATADIR%%/ukrainian
 @dirrm %%DATADIR%%
- at unexec /usr/bin/killall mysqld > /dev/null 2>&1 || true
+ at unexec %D/etc/rc.d/mysql-server.sh stop > /dev/null 2>&1 || true
--- mysql323-server.diff ends here ---

--- mysql40-server.diff begins here ---
diff -ruN mysql40-server.orig/pkg-plist mysql40-server/pkg-plist
--- mysql40-server.orig/pkg-plist	Mon Mar 14 12:52:45 2005
+++ mysql40-server/pkg-plist	Wed Mar 23 19:56:40 2005
@@ -135,4 +135,4 @@
 @dirrm %%DATADIR%%/swedish
 @dirrm %%DATADIR%%/ukrainian
 @dirrm %%DATADIR%%
- at unexec /usr/bin/killall mysqld > /dev/null 2>&1 || true
+ at unexec %D/etc/rc.d/mysql-server.sh stop > /dev/null 2>&1 || true
--- mysql40-server.diff ends here ---

--- mysql41-server.diff begins here ---
diff -ruN mysql41-server.orig/pkg-plist mysql41-server/pkg-plist
--- mysql41-server.orig/pkg-plist	Wed Mar 23 19:35:27 2005
+++ mysql41-server/pkg-plist	Wed Mar 23 19:56:46 2005
@@ -194,4 +194,4 @@
 @dirrm %%DATADIR%%/swedish
 @dirrm %%DATADIR%%/ukrainian
 @unexec rmdir %D/%%DATADIR%% 2> /dev/null || true
- at unexec /usr/bin/killall mysqld > /dev/null 2>&1 || true
+ at unexec %D/etc/rc.d/mysql-server.sh stop > /dev/null 2>&1 || true
--- mysql41-server.diff ends here ---

--- mysql50-server.diff begins here ---
diff -ruN mysql50-server.orig/pkg-plist mysql50-server/pkg-plist
--- mysql50-server.orig/pkg-plist	Tue Jan 11 06:00:20 2005
+++ mysql50-server/pkg-plist	Wed Mar 23 19:56:52 2005
@@ -190,4 +190,4 @@
 @dirrm %%DATADIR%%/ukrainian
 @unexec rmdir %D/%%DATADIR%% 2> /dev/null || true
 @exec [ -d %%DB_DIR%% ] || %D/bin/mysql_install_db --ldata=%%DB_DIR%%
- at unexec /usr/bin/killall mysqld > /dev/null 2>&1 || true
+ at unexec %D/etc/rc.d/mysql-server.sh stop > /dev/null 2>&1 || true
--- mysql50-server.diff ends here ---

>Release-Note:
>Audit-Trail:
>Unformatted: