Issue:
- During the SCH upgrade, while running the script dev/02-initsecurity.sh below error message is seen:
Connected to MySQL version 5.5 using JDBC driver MySQL Connector Java version mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ).
User 'admin@admin' failed to login: [SECURITY_34 - Invalid password]
Executing /opt/streamsets-dpm/streamsets-dpm-3.14.0/bin/streamsets dpmcli security createAppToken --user=admin@admin --password=[HIDDEN] --componentId=reporting000 --output=/opt/streamsets-dpm/streamsets-dpm-3.14.0/etc/reporting-auth-token.txt --regenerateIfExists
.........
Resolution:
- If the default password for admin@admin is changed then set the DPM_ADMIN_USER and DPM_ADMIN_PASSWORD environment variables in command line.
export DPM_ADMIN_USER=admin@admin
export DPM_ADMIN_PASSWORD=mypassword