Unable To Create Database Error When Configuring A Software Gateway Install

Products

• CA API Gateway

Issue/Introduction

When going through the initial setup and configuration of a software gateway installation the following error is generated:

Error creating database when saving configuration 'Unable to create database'

Environment

All Supported versions of API Gateway.

Cause

There were no errors generated in the mysqld.log or the gateways config.log to help determine the cause of the problem.

As we were dealing with a software gateway install the installation and configuration of mysql was performed by the end client.  Looking at the mysql configuration we could see that the validate password plugin was installed.

Executing a mysql query along the following showed that a password length of at least 8 characters was required for user accounts.

show variables like 'validate_password%';

Resolution

After making sure that the mysql gateway user account being used for the setup had a password length which was at least 8 characters long, we could then complete the setup and the ssg database was created successfully.

Additional Information

Gopinath (JAN-27-2025): Updated Environment and mysql query.