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

book

Article ID: 145440

calendar_today

Updated On:

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]'

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

Environment

Release : 9.x

Component : CA API API Gateway

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/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/9-4/other-gateway-form-factors/using-the-gateway-ami-appliance.html

Launch a DB Instance (AMI)

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