ports/103669: mysql-server rc script can not use mysql_flags variable
Chatchawan Wongsiriprasert
cws at miraclenet.co.th
Tue Sep 26 08:40:31 UTC 2006
>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 at 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:
More information about the freebsd-ports-bugs
mailing list