[bug-notifications] [mysql5 0004971]: MySQL 5.5 ignores correct elements in the configuration file (and a fix)

[Mantis Bug Tracker]

The following issue has been ASSIGNED. 
====================================================================== 
https://www.opencsw.org/mantis/view.php?id=4971 
====================================================================== 
Reported By:                laurent
Assigned To:                laurent
====================================================================== 
Project:                    mysql5
Issue ID:                   4971
Category:                   regular use
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
====================================================================== 
Date Submitted:             2012-07-03 17:42 CEST
Last Modified:              2013-05-26 10:54 CEST
====================================================================== 
Summary:                    MySQL 5.5 ignores correct elements in the
configuration file (and a fix)
Description: 
I have added configuration elements in the /etc/opt/csw/my.cnf files that
are ignored:

[mysqld]
datadir               = /path/to/mysql5
pid-file              = /path/to/mysql5/mysql.pid

[mysqld_safe]
log-error             = /path/to/mysqld.err

Other elements in the same files are properly taken into account, so the
file itself is read properly. On further investigation, it appears that
those elements are in fact handled by the start script.
The current svc-cswmysql5 method is based on a script that is too old and
does not take those into account. Workaround seems to be using a mysql5rc
file that is sourced in the method script, but this is awkward, as the
MySQL documentation doesn't point to those.
======================================================================