API Gateway: Unable to create database for new installation


Article ID: 141867


Updated On:


CA API Gateway


This article will discuss the cause and resolution for when the following error is seen when setting up a new API Gateway node. When attempting to install a new gateway node with a local MySQL database, you receive the below error message during gateway configuration : 

Configuration Summary
Press < to go to the previous step, type "quit" to quit.

The following configuration will be applied:

  Java VM
    Java VM Path = /opt/oraclejava/jdk1.8.0_101/jre
    Java VM Memory Allocation = 512

  Database Connection
    Database Host = localhost
    Database Port = 3306
    Database Name = ssg
    Database Username = gateway
    Administrative Database Username = root

  CA API Gateway Policy Manager Administrative Account
    Policy Manager Username = xxxxx

  Cluster Configuration
    Cluster Host = xxx.xxx.xxx

Press [Enter] to continue.
Please wait while the configuration is applied ...
Configuration Results

An error occurred during configuration.

Error creating database when saving configuration 'Unable to create database, there is an existing incompatible database.'





This can occur if the ssg database already exists. To confirm you can log in to MySQL and run the below

mysql> show databases;
| Database           |
| information_schema |
| mysql              |
| performance_schema |
| ssg                |
| sys                |
5 rows in set (0.00 sec)



Release : 9.4

Component : API Gateway


To resolve the issue the old database will need to be dropped prior to running the setup.

mysql> drop database ssg;
Query OK, 0 rows affected (0.01 sec)