[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 10:31 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.



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

---------------------------------------------------------------------- 
 (0008649) james (developer) - 2011-01-02 10:31
 https://www.opencsw.org/mantis/view.php?id=4646#c8649 
---------------------------------------------------------------------- 
Where would I set MYSQL_HOME if it's not in the conf file?  The
configuration really needs to be simpler and in one place.

In a zone configuration you can't remove /opt/csw/mysql5/my.cnf.

The solution is to not have a working copy in /opt.  Put the master in
/opt as a sample and copy it to /etc/opt on install where is becomes the
working conf.

Note the configurations should be in /etc not /var.