BDA Upgrade to 4.5.0 from 4.2.0 Fails At Step 6 - Mysql::Refreshmysqlpasswords
(Doc ID 2143096.1)
Last updated on AUGUST 03, 2021
Applies to:
Big Data Appliance Integrated Software - Version 4.2.0 and laterLinux x86-64
Symptoms
Mammoth upgrade fails on step 6 with:
Error [11884]: (//bdanode02.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[nmeta_db]/Exec[refresh-nmeta_db-ms-password]/returns) change from notrun to 0 failed: /usr/bin/mysql -uroot -p'' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'navigator'@'localhost' = PASSWORD('<PASSWORD>');
Error [11884]: (//bdanode02.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[naud_db]/Exec[refresh-naud_db-ms-password]/returns) change from notrun to 0 failed: /usr/bin/mysql -uroot -p'' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'navigator'@'localhost' = PASSWORD('<PASSWORD>');
************************************
...
ERROR: Step 6 failed
ERROR: Cannot continue with operation
INFO: Time spent in step 6 InstallBDASoftware is 6697 seconds.
INFO: Running bdadiagcluster...
Checking in the pagent-bdanode03-<timestamp>.log shows:
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[nmeta_db]/Exec[refresh-nmeta_db-ms-password]/returns) SET PASSWORD FOR 'navigator'@'bdanode01.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navigator'@'bdanode02.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navigator'@'bdanode03.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode04.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode05.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR
'navigator'@'bdanode06.example.com' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[nmeta_db]/Exec[refresh-nmeta_db-ms-password]/returns) FLUSH PRIVILEGES ; "
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com//Stage[main]/Mysql::Refreshmysqlpasswords/Refreshpassword[naud_db]/Exec[refresh-naud_db-ms-password]/returns) ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) /usr/bin/mysql -uroot -p'<PASSWORD>' -e " SET SESSION old_passwords=0; SET PASSWORD FOR 'navms'@'localhost' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) SET PASSWORD FOR 'navms'@'bdanode01.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode02.example.com' = PASSWORD('<password>'); SET PASSWORD FOR 'navms'@'bdanode03.example.com' = PASSWORD('<password>'); SET PASSWORD FOR 'navms'@'bdanode04.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode05.example.com' = PASSWORD('<PASSWORD>'); SET PASSWORD FOR 'navms'@'bdanode06.example.com' = PASSWORD('<PASSWORD>');
May 24 16:34:20 bdanode01 puppet-master[31354]: (//bdanode03.example.com/Puppet) FLUSH PRIVILEGES ; "
Checking in mysql shows that the navigator and navms databases are present:
+--------------------+
| Database |
+--------------------+
| information_schema |
| BDA_ODI_REPO |
| BDA_STB |
| activity_monitor |
| hive |
| host_monitor |
| hue |
| mysql |
| navigator |
| navms |
| oozie |
| performance_schema |
| reports_manager |
| resource_manager |
| scm |
| sentry |
| service_monitor |
| sqoop |
+--------------------+
Checking for users and password shows only a navigator user:
+-----------+------+------------------+
| user | host | password |
+-----------+------+------------------+
| navigator | % | <NAVIGATOR_PASSWORD> |
+-----------+------+------------------+
1 row in set (0.00 sec)
Note: With MySQL 5.7 and higher use "authentication_string" instead of Password as the Password column is removed. MySQL 5.7 came in BDA 4.8 so for any version higher use the following instead:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |