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