Mantis - mysql5
Viewing Issue Advanced Details
4971 regular use major always 2012-07-03 17:42 2013-05-26 10:57
laurent  
laurent  
normal  
closed  
fixed  
none    
none  
0004971: MySQL 5.5 ignores correct elements in the configuration file (and a fix)
I have added configuration elements in the /etc/opt/csw/my.cnf files that are ignored:

[mysqld]
datadir = /path/to/mysql5
pid-file = /path/to/mysql5/mysql.pid

[mysqld_safe]
log-error = /path/to/mysqld.err

Other elements in the same files are properly taken into account, so the file itself is read properly. On further investigation, it appears that those elements are in fact handled by the start script.
The current svc-cswmysql5 method is based on a script that is too old and does not take those into account. Workaround seems to be using a mysql5rc file that is sourced in the method script, but this is awkward, as the MySQL documentation doesn't point to those.
I'm attaching a new method script based on the mysql.server script coming from the 5.5.19 sources (the last I build myself, I could do better if you need :-)
The script has a couple of Solaris /bin/sh specific bugs fixed, and is adapted to use /opt/csw, /var/opt/csw and /etc/opt/csw.
I've tested it on my system as a drop-in replacement to the current script. It just works.
Obviously, it might entail some behaviour change for people using workarounds, but as the new behaviour closely follows the documentation, I think it's worth it.
? file icon svc-cswmysql5 [^] (10,646 bytes) 2012-07-03 17:42
Issue History
2012-07-03 17:42 laurent New Issue
2012-07-03 17:42 laurent File Added: svc-cswmysql5
2013-05-26 10:54 laurent Status new => assigned
2013-05-26 10:54 laurent Assigned To => laurent
2013-05-26 10:57 laurent Note Added: 0010406
2013-05-26 10:57 laurent Status assigned => closed
2013-05-26 10:57 laurent Resolution open => fixed

Notes
(0010406)
laurent   
2013-05-26 10:57   
Change was integrated and works well.