Portal not starting - "Checking to see if DB schema update is needed............" - liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)

Products

• CA API Developer Portal

Issue/Introduction

Trying to start Portal and not starting.

this Error observed from db-upgrade-portal5.3.2_log2.txt log .

Starting Liquibase at 17:12:50 (version 4.3.5 #62 built at 2021-04-29 18:31+0000)
Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)(type=master)(host=<IP ADDRESS>)(port=3315)/portal?createDatabaseIfNotExist=true&failOverReadOnly=false&serverTimezone=UTC with driver com.mysql.cj.jdbc.Driver.  Access denied for user 'USER'@'example.com' (using password: YES)
For more information, please use the --logLevel flag
[2025-12-16 17:12:51] SEVERE [liquibase.integration] Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)(type=master)(host=<IP ADDRESS>)(port=3315)/portal?createDatabaseIfNotExist=true&failOverReadOnly=false&serverTimezone=UTC with driver com.mysql.cj.jdbc.Driver.  Access denied for user 'USER'@'example.com' (using password: YES)
liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)(type=master)(host=<IP ADDRESS>)(port=3315)/portal?createDatabaseIfNotExist=true&failOverReadOnly=false&serverTimezone=UTC with driver com.mysql.cj.jdbc.Driver.  Access denied for user 'USER'@'example.com' (using password: YES)
        at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:131)

        ...
        Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: 
        liquibase.exception.DatabaseException: Connection could not be created to jdbc:mysql://address=(protocol=tcp)
        (type=master)(host=<IP ADDRESS>)(port=3315)/portal?createDatabaseIfNotExist=true&failOverReadOnly=false&serverTimezone=UTC 
        with driver com.mysql.cj.jdbc.Driver.  Access denied for user 'USER'@'example.com' (using password: YES)

Environment

CA Developer Portal 5.3.2

Debian 11 bullseye

Cause

-permissions was wrongly modified for the database/JDBC connection user

 

Resolution

1. MySQL DBA need to grant permissions to the JDBC user account which is used to connect the mysql server from the gateway.

2. Also, review the portal.conf file and check if the mysql server IP Address is correctly set.

3. If you updated the portal.conf file ,then

Stop the API Portal (stop portal services) :

docker stack rm portal

4. To Start again the API Portal with the script from the appropriate folder as such:

sudo ./portal.sh  

 

Additional Information

Starting from Portal 5.2.3

PORTAL_DATABASE_USERNAME=##SECRET_DATABASE_USERNAME##
PORTAL_DATABASE_PASSWORD=##SECRET_DATABASE_PASSWORD##

This values are masked for security reasons. So this is expected to be that way on the current Portal version.

more info can be found on the documentation: Secure Portal Application Secrets