External mysql db setup for Container Gateway

Products

• CA API Gateway

Issue/Introduction

I am running helm chart provided by Broadcom with external mysql (AWS RDS Instance) and looks like container gateway is not able to connect to mysql instance and I am getting following message: 

Using MySQL database
SSG_DATABASE_WAIT_TIMEOUT set to 300 seconds.
SSG_JVM_HEAP will be 2g
SSG_CLUSTER_HOST will be <ClusterHostName>
SSG_GC_ARGS will be -XX:+PrintGCDetails -Xloggc:/opt/SecureSpan/Gateway/node/default/var/logs/ssg_gc.log
Waiting for one of the databases to come up...

 

Environment

API Gateway 11.0
MySQL Version: 8.0

Resolution

Schema update after account step up and the JDBC line added to the YAML

If your Gateway/Software gateway/Container Gateway is connecting to a remote database, the user must be granted permission to be accessed from different IP locations. The following commands achieve this:

Example:

mysql> CREATE USER 'gateway'@'%' IDENTIFIED BY '<password>'; 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'gateway'@'%';

mysql> FLUSH PRIVILEGES;

THEN

jdbc:mysql://<mysql_hostname>:3306/database?sslMode=REQUIRED&tlsVersions=TLSv1.2,TLSv1.3