ports/81915: mysql-server.sh not ssh-friendly

[David Marshall]

>Number:         81915
>Category:       ports
>Synopsis:       mysql-server.sh not ssh-friendly
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Sun Jun 05 11:40:08 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     David Marshall
>Release:        FreeBSD 5.4-RELEASE amd64
>Organization:
>Environment:
System: FreeBSD master.psrk.com 5.4-RELEASE FreeBSD 5.4-RELEASE #1: Sat May 28 03:05:48 EDT 2005 david at master.psrk.com:/usr/obj/usr/src/sys/MASTER amd64



>Description:
        In at least databases/mysql41-server, the mysql-server.sh file
        created in /usr/local/etc/rc.d is not friendly to ssh when starting.
        An ssh command that involves starting MySQL will never terminate.

>How-To-Repeat:

        ssh some.machine.com /usr/local/etc/rc.d/mysql-server.sh start
>Fix:


        Pipe STDERR to /dev/null like STDOUT is piped.

        Patch that works in a more-ssh-friendly fashion below.


--- mysql-server.sh     Sun Jun  5 03:20:22 2005
+++ mysql-server.sh.orig        Sun Jun  5 03:19:31 2005
@@ -37,7 +37,7 @@
 mysql_limits_args="-e -U ${mysql_user}"
 pidfile="${mysql_dbdir}/`/bin/hostname`.pid"
 command="/usr/local/bin/mysqld_safe"
-command_args="--defaults-extra-file=${mysql_dbdir}/my.cnf --user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_args} > /dev/null 2>&1 &"
+command_args="--defaults-extra-file=${mysql_dbdir}/my.cnf --user=${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_args} > /dev/null &"
 procname="/usr/local/libexec/mysqld"
 start_precmd="${name}_prestart"
 mysql_install_db="/usr/local/bin/mysql_install_db"
>Release-Note:
>Audit-Trail:
>Unformatted: