Unable to run migrate-db on worker node after remote MySQL database password has been changed from default

book

Article ID: 100033279

calendar_today

Updated On:

Description

Error Message

[java] 2016-11-08 05:36:13,480 WARN [STDERR] (main com.teneo.esa.cluster
.MigrateDbNamespace$FailedMigrationException: Could not open connection to new DB server.
Please use Password Manager to ensure all of this system's passwords
are identical to those of the new Master system

Cause

migrate-db will fail for the new worker node because the new worker node has the default MySQL passwords. The worker node will not be able to connect to the database.

Resolution

1. Stop eDP services on the worker node

2. Use Password Manager to change passwords on the worker node to match the password on the remote DB

3. Perform b migrate-db and verify it completes successfully.

3. Start eDP services on the worker node

4. Add the worker node on the master through the Appliances screen

Issue/Introduction

The migrate-db command fails when attempting to run on a new worker node and remote MYSQL database password has been changed from default.