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...
API Gateway 11.0
MySQL Version: 8.0
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