The restart of Portal fails with the following error (with MySQL hosted on a Gateway 11 OVA):
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: INFO: Cannot load service: liquibase.license.LicenseService: Provider liquibase.license.pro.DaticalTrueLicenseService could not be instantiated
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ####################################################
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## _ _ _ _ ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## | | (_) (_) | ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## | | ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## |_| ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## Get documentation at docs.liquibase.com ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## Get certified courses at learn.liquibase.com ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## Free schema change activity reports at ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## https://hub.liquibase.com ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ## ##
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: ####################################################
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: Starting Liquibase at 22:55:02 (version 4.5.0 #52 built at 2021-09-27 16:19+0000)
Feb 28 16:55:02 svma03106 5f2b128706ab[1226]: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Release : 5.1.2
Workaround until MySQL 8.0.31 is fully support as a portal DB
Create the portal user, the alter the password
Explicitly forcing password native
mysql> ALTER USER 'portal'@'%' IDENTIFIED WITH mysql_native_password BY '7layer';
This can also occur if migrating from Postgres to MySQL where the DB is 8.0.31 or above
"ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/
During migration, running the following command to resolve this issue:
ALTER USER '<user>'@'%' IDENTIFIED WITH mysql_native_password BY '<password>';