Upgrade to Spectrum 21.2.8 fails with mySQL error "Access denied for user 'root'@'localhost'"

Products

• Spectrum
• Network Observability

Issue/Introduction

post install log

********** Started: Wed Feb 23 12:57:29 2022 **********
running Custom Script Install-Tools/CUS/mysql.cus
 ERROR 1045 (28000) at line 2: Access denied for user 'root'@'localhost' (using password: YES)
newUser Failure: mysql --defaults-file=/Spectrum/mysql/my-spectrum.cnf --login-path=myclient mysql
Error(s) occurred. Please see /Spectrum/Install-Tools/LOGS/21.2.8.0.32_20220223/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED
********** Completed: Wed Feb 23 13:01:31 2022 **********

 

mysql log

******* Removing and copying new mysql/bin dir *******
******* Removing and copying new mysql/share dir *******
done fetching the old password
myspectrumlogin.cnf alreadly existing in /Spectrum/mysql/data , not updating the existing file

******* Preserving mysql directory *******

.....

Waiting for mysql to start up... try count 1 
Creating ##### user in database ... 
**^G Error during newUser ##### 0n3cl1Ck
2022-02-23T12:27:07.737518Z 9 [Note] Access denied for user 'root'@'localhost' (using password: NO)

Environment

Release : 21.2.8

Component : SPCINS - SPECTRUM INSTALLATION

Cause

Rerunning the install causes this error. Renaming the myspectrumlogin.cnf in /Spectrum/mysql/data before running the install again, does not fix the problem and we get the same error and failed install.

Resolution

 

the problem happens when we reinstall so if this is a virtual machine and a pre-upgrade snapshot prior is available, you can restore to the previous versions and install again.

If no snapshot is available,  the following resolution needs to be done after the first un successful install before attempting to reinstall.

1. Install the spectrum 21.2.8 latest build
2. Connect to mysql using root user
  $SPECROOT/mysql/bin/mysql --defaults-file=$SPECROOT/mysql/my-spectrum.cnf -uroot -pMySqlR00t
 3. Update the "root" File_priv.
        UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' , File_priv='Y' WHERE User='root';
        FLUSH PRIVILEGES;
4. Verify the "root" user File_priv update to "Y" or not
            select user, Host, File_priv from mysql.user;
5. Re install the spectrum.

 

 

 

Additional Information

This has been scheduled to be fixed in the 21.2.10 release.