Date: Tue, 26 Sep 2006 08:36:17 GMT From: Chatchawan Wongsiriprasert <cws@miraclenet.co.th> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/103669: mysql-server rc script can not use mysql_flags variable Message-ID: <200609260836.k8Q8aHAH086951@www.freebsd.org> Resent-Message-ID: <200609260840.k8Q8ePAL022993@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 103669
>Category: ports
>Synopsis: mysql-server rc script can not use mysql_flags variable
>Confidential: no
>Severity: serious
>Priority: medium
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Tue Sep 26 08:40:24 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator: Chatchawan Wongsiriprasert
>Release: 6.1
>Organization:
MiracleNet group
>Environment:
FreeBSD poseidon.net0.intranet 6.1-RELEASE-p7 FreeBSD 6.1-RELEASE-p7 #3: Tue Sep 26 09:16:05 ICT 2006 cws@poseidon.net0.intranet:/usr/obj/usr/src/sys/POSEIDON i386
>Description:
Due to command line parameter order restriction of mysqld.
Setting mysql_flags in rc.conf cause an error (in mysql error log)
[ERROR] /usr/local/libexec/mysqld: unknown variable 'defaults-extra-file=/home/mysql/my.cnf
User must use mysql_args to set additional mysql parameters but this method is differ from another port and may cause confuse to the user
>How-To-Repeat:
stop mysqld
set mysql_flags in rc.conf such as mysql_flags=--bind-address=127.0.0.1
restart mysqld
>Fix:
Apply this patch to /usr/local/etc/rc.d/mysql-server
diff -u mysql-server.org mysql-server
--- mysql-server.org Tue Sep 26 15:17:29 2006
+++ mysql-server Tue Sep 26 15:30:02 2006
@@ -32,6 +32,12 @@
: ${mysql_dbdir="/var/db/mysql"}
: ${mysql_args=""}
+if [ "${mysql_flags}" != "" ];
+then
+ mysql_args="${mysql_args} ${mysql_flags}"
+ mysql_flags=
+fi
+
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200609260836.k8Q8aHAH086951>