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

[Mantis Bug Tracker]

The following issue has been RESOLVED. 
====================================================================== 
https://www.opencsw.org/mantis/view.php?id=4646 
====================================================================== 
Reported By:                james
Assigned To:                laurent
====================================================================== 
Project:                    mysql5
Issue ID:                   4646
Category:                   other
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     resolved
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-12-22 13:49 CET
Last Modified:              2013-06-09 16:05 CEST
====================================================================== 
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.



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

---------------------------------------------------------------------- 
 (0010429) laurent (manager) - 2013-06-09 16:05
 https://www.opencsw.org/mantis/view.php?id=4646#c10429 
---------------------------------------------------------------------- 
Upon my suggestion, and the method was replaced recently (before I took
over the package) by the default MySQL script.
It looks for my.cnf in /etc/opt/csw/my.cnf, then /opt/csw/my.cnf, then
/var/opt/csw/mysql5/my.cnf (the content of the last two, if found, is added
to the default).
The only modification for the script is the one that allows picking up the
binary architecture to run on Solaris according to what the system supports
or what is configured.

So basically, it follows what upstream recommends, and it has been working
nicely for me. Unless there's some negative feedback, I'll close this
ticket soon. 

---------------------------------------------------------------------- 
 (0010430) laurent (manager) - 2013-06-09 16:05
 https://www.opencsw.org/mantis/view.php?id=4646#c10430 
---------------------------------------------------------------------- 
See last note.