[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:                laurent
====================================================================== 
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:              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.



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

---------------------------------------------------------------------- 
 (0008668) maciej (developer) - 2011-01-05 01:00
 https://www.opencsw.org/mantis/view.php?id=4646#c8668 
---------------------------------------------------------------------- 
The problem with patching mysqld_safe is that it changes the documented way
MySQL startup works.  Imagine someone trying to debug a problem that is
related to these settings.  They will probably read MySQL documentation[1]
and examine our startup script.  If we patch mysqld_safe, they will find no
indication that we're changing the default behavior.  They might spend a
lot of time debugging, until they discover that we've modified mysqld_safe.
 Don't you think it might be a problem?

[1] http://dev.mysql.com/doc/refman/5.0/en/option-files.html 

---------------------------------------------------------------------- 
 (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.