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)