Not able to Restart Portal

Products

• CA API Developer Portal

Issue/Introduction

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.

Environment

Release : 5.1.2

Cause

• Using MySQL external from GW 11 OVA (mysql 8.0.31)  for portal 5.1.2
• Portal's JDBC driver unable to connect and update the external mysql 8.0.31 database.
• In the my.cnf file it's configured with default-authentication-plugin=caching_sha2_password

Resolution

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';

Additional Information

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/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory"

During migration, running the following command to resolve this issue:

ALTER USER '<user>'@'%' IDENTIFIED WITH mysql_native_password BY '<password>';