Skip site navigation (1)Skip section navigation (2) 
Date:      Mon, 30 Sep 2019 19:47:32 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 240949] databases/mysql57-server subtle start script issue
Message-ID:  <bug-240949-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help 
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D240949

            Bug ID: 240949
           Summary: databases/mysql57-server subtle start script issue
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: mmokhi@freebsd.org
          Reporter: freebsd@pk1048.com
          Assignee: mmokhi@freebsd.org
             Flags: maintainer-feedback?(mmokhi@freebsd.org)

The pkg-message states:

MySQL57 has a default %%ETCDIR%%/my.cnf,
remember to replace it wit your own
or set `mysql_optfile=3D"$YOUR_CNF_FILE` in rc.conf.

And the /usr/local/etc/rc.d/mysql-server script states:

# mysql_optfile (str):  Server-specific option file.
#                       Set it in the rc.conf or default behaviour of
#                       `mysqld_safe` itself, will be picking
#                       ${mysql_confdir}/my.cnf if it exists.

But setting mysql_optfile in /etc/rc.conf does not replace the default my.c=
nf
file, instead it sets the mysqld_safe --defaults-extra-file parameter, whic=
h is
invoked as well as the default from /usr/local/etc/mysql/my.cnf.

Either make the pkg-message and comment in the rc.d script clear that both =
are
invoked or set the mysqld_safe --defaults-file parameter instead of
--defaults-extra-file.

>From the mysqld_safe man page:

       o   --defaults-extra-file=3Dfile_name

           Read this option file in addition to the usual option files. If =
the
           file does not exist or is otherwise inaccessible, the server will
           exit with an error.  file_name is interpreted relative to the
           current directory if given as a relative path name rather than a
           full path name. This must be the first option on the command line
           if it is used.

           For additional information about this and other option-file
           options, see Section 4.2.2.3, "Command-Line Options that Affect
           Option-File Handling".

       o   --defaults-file=3Dfile_name

           Use only the given option file. If the file does not exist or is
           otherwise inaccessible, the server will exit with an error.
           file_name is interpreted relative to the current directory if gi=
ven
           as a relative path name rather than a full path name. This must =
be
           the first option on the command line if it is used.

           For additional information about this and other option-file
           options, see Section 4.2.2.3, "Command-Line Options that Affect
           Option-File Handling".

--=20
You are receiving this mail because:
You are the assignee for the bug.=

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-240949-7788>