Debug container gateway database connection

Products

• CA API Gateway

Issue/Introduction

The container gateway took more than 40 minutes to start.  

Environment

Layer7 Container Gateway 11

Cause

The connection to the AWS RDS was slow. 

Resolution

You can debug database connection issues by running the following command from the container Gateway:

LIQUIBASE_JAR=`ls ${GATEWAY_DIR}/runtime/lib/liquibase-*jar`;MYSQL_JAR=`ls ${GATEWAY_DIR}/runtime/lib/mysql-connector-java-*jar`; java -jar ${LIQUIBASE_JAR} --driver=com.mysql.cj.jdbc.Driver --classpath ${MYSQL_JAR}:${GATEWAY_DIR}/config/etc/db --changeLogFile=ssg.xml --url=${SSG_DATABASE_JDBC_URL} --username=${SSG_DATABASE_USER} --password=${SSG_DATABASE_PASSWORD} --logLevel=debug update