[bug-notifications] [mysql5 0004646]: /var/opt/csw/mysql5/my.cnf ignored

[Mantis Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://www.opencsw.org/mantis/view.php?id=4646 
====================================================================== 
Reported By:                james
Assigned To:                maciej
====================================================================== 
Project:                    mysql5
Issue ID:                   4646
Category:                   other
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
====================================================================== 
Date Submitted:             2010-12-22 13:49 CET
Last Modified:              2011-01-02 13:26 CET
====================================================================== 
Summary:                    /var/opt/csw/mysql5/my.cnf ignored
Description: 
The start up script:
/var/opt/csw/svc/method/svc-cswmysql5
has provision to use a local configuration:
MYSQL_VAR=/var/opt/csw/mysql5
CONFFILE=$MYSQL_VAR/my.cnf

but it fails:

WARNING: Found two instances of my.cnf -
/opt/csw/mysql5/my.cnf and
/var/opt/csw/mysql5/my.cnf
IGNORING /var/opt/csw/mysql5/my.cnf

If I can't write to /opt this is a problem and if I can then I'm wasting
my time in /var/opt anyway.



====================================================================== 

---------------------------------------------------------------------- 
 (0008650) maciej (manager) - 2011-01-02 13:26
 https://www.opencsw.org/mantis/view.php?id=4646#c8650 
---------------------------------------------------------------------- 
In https://sourceforge.net/apps/trac/gar/changeset/12146 MYSQL_HOME is
exported in the startup script, which causes the /opt/csw/mysql5/my.cnf
file to be ignored.  mysqld sets MYSQL_HOME to BASEDIR if BASEDIR/my.cnf is
present.  However, this only happens when MYSQL_HOME is initially unset. 
If we give MYSQL_HOME a value beforehand, mysqld doesn't look into
BASEDIR.

I've created a new set of packages and put them into experimental.  Please
try them.