Layer7 API Gateway: Unable to create database for new installation

Products

• CA API Gateway
• API SECURITY
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

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

 

 

 

Cause

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)

 

Environment

Release : 9.4

Component : API Gateway

Resolution

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)