Oracle Big Data Appliance 4.2 to 4.5 Upgrade of a CDH Cluster Fails on Step 1with " ERROR 1045 (28000): Access denied for user 'root'" (Doc ID 2151255.1)

Last updated on JUNE 19, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.2.0 and later
Linux x86-64

Symptoms

BDA upgrade from v4.2.0 to v4.5.0 fails on step 1 with "ERROR 1045 (28000): Access denied for user 'root'".

Step 1 of the upgrade tries to get all passwords for the 'root' MySQL user from all the nodes.

The correct password is entered but the following error is received:

WARNING: The password for the MySQL root user is missing from the parameters file and is required for the installation.
Enter password:
Enter password again:
INFO: Executing verifyMySQLPasswd.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode07 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode07.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode8 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode08.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode09 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode09.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode10 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode10.example.com' (using password: YES) #Step 1#
ERROR: Errors executing verifyMySQLPasswd.sh. Continuing anyway. #Step 1#
WARNING: Incorrect password. Do you wish to try again? (yes/no):
yes
Enter password:
Enter password again:
INFO: Executing verifyMySQLPasswd.sh on nodes /opt/oracle/BDAMammoth/bdaconfig/tmp/all_nodes #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode07 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode07.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode08 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode08.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode09 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode09.example.com' (using password: YES) #Step 1#
ERROR: Error code 1 when executing verifyMySQLPasswd.sh on host bdanode10 #Step 1#
ERROR: Error is : ERROR 1045 (28000): Access denied for user 'root'@'bdanode10.example.com' (using password: YES) #Step 1#
ERROR: Errors executing verifyMySQLPasswd.sh. Continuing anyway. #Step 1#
WARNING: Incorrect password. Do you wish to try again? (yes/no):

Other symptoms:

1. The cluster was previously extended.  The script verifyMySQLPasswd.sh, run by Mammoth during Step 1 of the upgrade,  looks to be accessing the MySQL database on Node 2 of the cluster instead of the MySQL database on Node 3. Typically the primary MySQL runs on Node 3 with the backup on Node 2.

The MySQL database on Node 3 shows the 'root' user on all the nodes:

mysql> select Password,Host from mysql.user where user='root' and Password !='';
+------------------+-----------------------+
| Password | Host |
+------------------+-----------------------+
| <mysql root pwd> | localhost |
| <mysql root pwd> | bdanode01.example.com |
| <mysql root pwd> | bdanode02.example.com |
| <mysql root pwd> | bdanode03.example.com |
| <mysql root pwd> | bdanode04.example.com |
| <mysql root pwd> | bdanode05.example.com |
| <mysql root pwd> | bdanode06.example.com |
| <mysql root pwd> | bdanode07.example.com |
| <mysql root pwd> | bdanode08.example.com |
| <mysql root pwd> | bdanode09.example.com |
| <mysql root pwd> | bdanode10.example.com |
| <mysql root pwd> | % |
+------------------+-----------------------+

However the MySQL database on Node 2 (backup) shows only the 'root' user for the original nodes and not for any of the the nodes extended into the cluster.

mysql> select Password,Host from mysql.user where user='root' and Password !='';
+------------------+-----------------------+
| Password | Host |
+------------------+-----------------------+
| <mysql root pwd> | localhost |
| <mysql root pwd> | bdanode01.example.com |
| <mysql root pwd> | bdanode02.example.com |
| <mysql root pwd> | bdanode03.example.com |
| <mysql root pwd> | bdanode04.example.com |
| <mysql root pwd> | bdanode05.example.com |
| <mysql root pwd> | bdanode06.example.com |
+------------------+-----------------------+

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms