CA API Gateway: AWS AMI - Cannot create ssg database UNKNOWNDB_FAILURE

Products

• CA API Gateway

Issue/Introduction

If you are deploying the CA API Gateway AWS AMI form-factor you may receive the following error if trying to use a non-RDS Database (for example your own implementation of MySQL)

"Error creating database when saving configuration 'Cannot create database: 'Access denied for user 'root'@'%' to database 'ssg'' [code:42,000, UNKNOWNDB_FAILURE]'

Environment

Release : 9.x

Component : CA API API Gateway

Cause

The cause of this error is a general incompatibility when trying to use a non-RDS Database for your CA API Gateway AWS AMI form-factor deployment

Resolution

To resolve this issue please ensure that you are creating an RDS database and not trying to use an independent MySQL database as this is not supported with the CA API Gateway AWS AMI form-factor architecture 

Please see the Additional Information section for general information on the CA API Gateway AWS AMI form-factor deployment process and the Database creation section. 

Additional Information

Using the Gateway AMI Appliance

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/other-gateway-form-factors/using-the-gateway-ami-appliance.html 

Launch a DB Instance (AMI)

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/other-gateway-form-factors/using-the-gateway-ami-appliance/launch-a-db-instance-ami.html