OpenSolaris

Printable Version Enter a New Search
Bug ID 6555257
Synopsis mysql_register script completion text should be changed to reflect status of commands executed
State 7-Fix in Progress (Fix is in progress)
Category:Subcategory suncluster:ha-mysql
Keywords
Responsible Engineer Detlef Ulherr
Reported Against 3.1u4 , 3.2_fcs
Duplicate Of
Introduced In
Commit to Fix 3.2_patch_02
Fixed In
Release Fixed , 3.2u1_fcs(3.2u1_02) (Bug ID:2150172)
Related Bugs
Submit Date 9-May-2007
Last Update Date 23-May-2007
Description
mysql_register script text should be changed to reflect status of commands executed.  Current behaviour is text mentioning that HA configuration is done even if the database is down and all the scripts have failed.

bash-3.00# /opt/ xxxxx Wscmys/util/mysql_register -f /global/mysql/mysql_config
sourcing /global/mysql/mysql_config and create a working copy under /opt/ xxxxx Wscmys/util/mysql_config.work

MySQL version 5 detected on 5.10/SC3.2


Add faulmonitor user (fmuser) with password (fmuser) with Process-,Select-, Reload- and Shutdown-privileges to user table for mysql database for host joker4

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Add faulmonitor user fmuser with Process-, Select-, Reload- and Shutdown-privileges to user table for mysql database for joker4 failed

Add SUPER privilege for fmuser@joker4

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Add GRANT privilege for root@joker4 failed

Add faulmonitor user (fmuser) with password (fmuser) with Process-,Select-, Reload- and Shutdown-privileges to user table for mysql database for host pjoker2

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Add faulmonitor user fmuser with Process-, Select-, Reload- and Shutdown-privileges to user table for mysql database for pjoker2 failed

Add SUPER privilege for fmuser@pjoker2

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Add GRANT privilege for root@pjoker2 failed

Create test-database sc3_test_database

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Create test-database sc3_test_database failed

Grant all privileges to sc3_test_database for faultmonitor-user fmuser for host joker4

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Adding all privileges to sc3_test_database for faultmonitor-user fmuser for host joker4 failed

Grant all privileges to sc3_test_database for faultmonitor-user fmuser for host pjoker2

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)
Adding all privileges to sc3_test_database for faultmonitor-user fmuser for host pjoker2 failed

Flush all privileges

/opt/mysql/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/joker3.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/joker3.sock' exists!
Flush all privileges failed

Mysql configuration for HA is done  <==== this should be changed to reflect failure.
Work Around
N/A
Comments
N/A