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:
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