[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:                
====================================================================== 
Project:                    mysql5
Issue ID:                   4646
Category:                   other
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2010-12-22 13:49 CET
Last Modified:              2011-01-02 02:41 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.



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

---------------------------------------------------------------------- 
 (0008648) maciej (manager) - 2011-01-02 02:41
 https://www.opencsw.org/mantis/view.php?id=4646#c8648 
---------------------------------------------------------------------- 
I did part of the work so far. The experimental catalog[1] contains
packages which read /etc/opt/csw/mysql5/my.cnf.  The postinstall script no
longer writes to /opt/csw/mysql5 (where it does not have write access).

There's a remaining problem that /opt/csw/mysql5/my.cnf still has
precedence over /etc/opt/csw/mysql5/my.cnf, and a way to fix that would be
to set MYSQL_HOME to something else than /opt/csw/mysql5.

If you remove the old /opt/csw/mysql5/my.cnf file, or make an install on a
clean system, you will be able to have a per-zone configuration.  

[1] http://buildfarm.opencsw.org/experimental.html#mysql-5.0