Patch-ID# 145646-11


Download this patch from My Oracle Support

Your use of the firmware, software and any other materials contained in this update is subject to My Oracle Support Terms of Use, which may be viewed at My Oracle Support.
For further information on patching best practices and resources, please see the following links:
Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.

Keywords: security oracle ha-mysql ha-mysql patch
Synopsis: Oracle Solaris Cluster 3.3: HA-MySQL Patch for Oracle Solaris 10
Date: May/08/2017


Install Requirements: NA

Solaris Release: 10

SunOS Release: 5.10

Unbundled Product: Oracle Solaris Cluster

Unbundled Release: 3.3

Xref: This patch available for Oracle Solaris 10 x86 as patch 145647

Topic: Oracle Solaris Cluster 3.3: HA-MySQL Patch for Oracle Solaris 10

Relevant Architectures: sparc

Bugs fixed with this patch:

Sun CR # Bug #
675611315513179
16459459
16490635
20565895
20657631
20674115
20696531
20703770
20704165
20961172
21482073
21482103
21489278
21497620
22566637
23173259
23229459
23593715
24314709
24357210
24372832
24386631
24386835
24402269
24403080
24428229
24428571
24450177
24478487
25138396
25143812
25144119
25950675
684290115564012
699207715674967
699520515677529
702419015700471
702767915702834
703063015704896
708050715736318


Changes incorporated in this version: 25950675

Patches accumulated and obsoleted by this patch: 146158-01 149871-01

Patches which conflict with this patch:

Patches required with this patch:

Obsoleted by:

Files included with this patch:

/opt/SUNWscmys/bin/control_mysql
/opt/SUNWscmys/bin/functions
/opt/SUNWscmys/bin/mysql_rt_control
/opt/SUNWscmys/bin/mysql_rt_validate
/opt/SUNWscmys/bin/probe_mysql
/opt/SUNWscmys/bin/probe_smf_mysql
/opt/SUNWscmys/bin/start_mysql
/opt/SUNWscmys/bin/stop_mysql
/opt/SUNWscmys/etc/ORCL.mysql
/opt/SUNWscmys/geocontrol/bin/functions
/opt/SUNWscmys/geocontrol/bin/mysql_geo_control
/opt/SUNWscmys/geocontrol/bin/mysql_geo_replication
/opt/SUNWscmys/geocontrol/util/mysql_geo_register
/opt/SUNWscmys/lib/64
/opt/SUNWscmys/lib/argv_password
/opt/SUNWscmys/lib/functions_static
/opt/SUNWscmys/lib/sparcv9/argv_password
/opt/SUNWscmys/ndb_mgmd/bin/functions
/opt/SUNWscmys/ndb_mgmd/bin/mysql_ndb_mgmd_control
/opt/SUNWscmys/ndb_mgmd/bin/mysql_ndb_mgmd_rt_control
/opt/SUNWscmys/ndb_mgmd/bin/mysql_ndb_mgmd_rt_validate
/opt/SUNWscmys/ndb_mgmd/etc/ORCL.mysql_ndbmgmd
/opt/SUNWscmys/ndb_mgmd/util/mysql_ndb_mgmd_config
/opt/SUNWscmys/ndb_mgmd/util/mysql_ndb_mgmd_register
/opt/SUNWscmys/ndbd/bin/functions
/opt/SUNWscmys/ndbd/bin/mysql_ndbd_control
/opt/SUNWscmys/ndbd/bin/mysql_ndbd_rt_control
/opt/SUNWscmys/ndbd/bin/mysql_ndbd_rt_validate
/opt/SUNWscmys/ndbd/etc/ORCL.mysql_ndbd
/opt/SUNWscmys/ndbd/util/mysql_ndbd_config
/opt/SUNWscmys/ndbd/util/mysql_ndbd_register
/opt/SUNWscmys/ndbd_shutdown/bin/functions
/opt/SUNWscmys/ndbd_shutdown/bin/mysql_ndbd_shut_rt_control
/opt/SUNWscmys/ndbd_shutdown/bin/mysql_ndbd_shut_rt_validate
/opt/SUNWscmys/ndbd_shutdown/bin/ndbd_shutdown_control
/opt/SUNWscmys/ndbd_shutdown/etc/ORCL.mysql_ndbd_shutdown
/opt/SUNWscmys/ndbd_shutdown/util/ndbd_shutdown_config
/opt/SUNWscmys/ndbd_shutdown/util/ndbd_shutdown_register
/opt/SUNWscmys/util/ha_mysql_config
/opt/SUNWscmys/util/ha_mysql_register
/opt/SUNWscmys/util/ha_mysql_smf_register
/opt/SUNWscmys/util/mysql_config
/opt/SUNWscmys/util/mysql_register
/opt/cluster/lib/rgm/rtreg/ORCL.mysql
/opt/cluster/lib/rgm/rtreg/ORCL.mysql_ndbd
/opt/cluster/lib/rgm/rtreg/ORCL.mysql_ndbd_shutdown
/opt/cluster/lib/rgm/rtreg/ORCL.mysql_ndbmgmd

Problem Description:

25950675 patch 145646-10 and 145647-10 must be respun
 
(from 145646-10)
 
21482073 print clean errors asking user to encrypt passwd when needed during rs creation
21482103 verb tense used in msgs is misleading to user
21489278 warn users about passwd in clear text if FMPASS defined in reg file
21497620 on primary, if MySQL DB is down geo does not report the problem
23173259 Solaris Cluster agent for MySQL probe is not resilient ${RESOURCE}.mysql.last
23229459 return code of ha_mysql_register is 0 even if global_zone function failed
24314709 cd to non-existing dir resulting in unnecessary failure message
24357210 typo in description of MySQL property MYSQL_HOST
24372832 mysql_host should be validated
24386631 problem with HA-MySQL
24386835 geo goes to disable rs before it creates it at "geopg get"
24402269 resourcetype issues: CLRT parameter not set, gds registration and ORCL.mysql chk
24403080 geo-mysql needs to fail at check_switchover if required grants are missing
24428229 creation of mysql rs must fail if storage rs not online on any node
24428571 need graceful failure if user defined in mysql_user does not exist
24450177 "Create_configuration unsuccessful" msg printed incorrectly if non-root user
24478487 if MySQL FS not mounted, geopg validate fails without printing reason
25138396 start of HA-MySQL rs failing due to syntax problems
25143812 if validate fails, request to enable debug returns failure but leaves debug on
25144119 MySQL rep rs probe reporting syntax problems
 
(from 145646-09)
 
22566637 HA-MySQL component resource should not require parameter file on file system
23593715 cannot use "clrs create -t ORCL.mysql" to create HA-MySQL resource
 
(from 145646-08)
 
20565895 MySQL agent needs to take FIPS-140 activation setting into account
20657631 MySQL agent failing to set resource status
20674115 problem with HA-MySQL
20696531 fail MySQL rs creation if FM paswd not in reg file or encrypted passwd file
20703770 geo-mysql not working when MySQL passwd is encrypted for HA-MySQL
20704165 geopg start of geo-mysql reports success when MySQL rs is disabled
20961172 registration of replication resource must use SUNW.gds
 
(from 145646-07)
 
15513179 MySQL resource doesn't change to faulted state if sc3_test_database is dropped
 
(from 145646-06)
 
16459459 MySQL agent is unable to stop the slave threads for MySQL 5.6
16490635 MySQL agent must use ksh93-compliant function definitions
 
(from 145646-05)
 
        This revision accumulates feature point patch 149871-01 into OSC 3.3 U2.
 
(from 145646-04)
 
7024190 register scripts need to define resource_offline_restart dependencies for HAStoragePlus
7027679 HA-MySQL password should not disclose the database user in ps readable form
7030630 problem with HA-MySQL
7080507 MySQL agents configuration should give the option to set arbitrary resource parameters
 
(from 145646-03)
 
        This revision accumulates feature point patch 146158-01.
 
        This revision was planned in anticipation of including into update 1
        new features expected to be in the above feature point patch.  In
        this case, that particular feature point patch ended up not being
        targeted for such changes.  It is not necessary to install this
        revision to a system having the prior 145646-02 revision.
 
(from 145646-02)
 
6992077 MySQL agent must support version 5.5
6995205 MySQL replication resource stays degraded after takeover
 
(from 145646-01)
 
6842901 MySQL Geo replication probe should always return 0 & set resource status in the presence of faults
 
(from 146158-01)
 
        This revision is effectively a copy of the 145646-02 sustaining patch.
 
(from 149871-01)
 
        Feature point patches combine copies of released fixes with new
        features.  This feature point patch ended up containing only copies
        of previously-released fixes with nothing new added.


Patch Installation Instructions:
--------------------------------
 
There are three (3) possible procedures for installing patches on Oracle
Solaris Cluster. The proper method to use and any additional instructions
for this patch are specified below in the "Special Install Instructions"
section.
 
Refer to the chapter entitled "Patching Oracle Solaris Cluster Software and
Firmware" in the "Oracle Solaris Cluster System Administration Guide" for a
description of the different install processes and instructions on how to
install Oracle Solaris Cluster 3.3 patches.
 
Refer to the man pages for instructions on using 'patchadd' and 'patchrm'
commands provided with Oracle Solaris, to install and remove patches.


Special Install Instructions:
-----------------------------
 
NOTE 1:  Install this patch using one of the following patch install
         procedures found in the "Patching Oracle Software and Firmware"
         chapter of the "Oracle Solaris Cluster System Administration Guide:"
 
         * Non Rebooting Patch
         * Rebooting Patch (Node)
         * Rebooting Patch (Cluster and Firmware)
 
NOTE 2:  Revision -03 delivers features introduced during update 1.
 
NOTE 3:  If you do not want to disclose the password of the MySQL monitoring
         user in a readable form, leave all passwords empty in the mysql_config
         and the ha_mysql_config file.  In this case you must call the
         ha_mysql_register script with -e on all nodes to run the MySQL
         database.  This stores the password in an encrypted form.
 
         Example:
 
         ksh /opt/SUNWscmys/util/ha_mysql_register -f <directory>/ha_mysql_config -e
 
NOTE 4:  Revision -05 delivers features introduced during update 2.
 
NOTE 5:  Starting with revision -08, password encryption mandates the
         installation of OSC 3.3 update 2.  If a resource is running
         in non-global zones other than zone clusters, the encryption
         of a password must be done on one node in the  global zone.


README -- Last modified date: Monday, May 8, 2017