API Gateway: Unable to Create Database error while setting up a software form-factor API Gateway

book

Article ID: 46740

calendar_today

Updated On:

Products

STARTER PACK-7 CA Rapid App Security CA API Gateway

Issue/Introduction

This article will discuss the issue of being unable to setup a software form factor API Gateway with the following error seen during setup:

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

During the API Gateway software setup a Database Creation error, related to MySQL Binary Logging, may present itself when attempting to create a Database. The default MySQL settings contain a particular MySQL global variable, set to off, which can interfere with the creation of the API Gateway database. The global variable in question is the “log_bin_trust_function_creators” variable. By setting this variable to on conditions surrounding function creation are relaxed and the database creation should proceed without issue. For more information on this subject please review the MySQL Binary Logging documentation.

To confirm this is a Binary Logging issue review log files in the following location:

Cause

One root cause is related to MySQL Binary Logging functionality in the MySQL server. The default MySQL settings contain a particular MySQL global variable, set to off, which can interfere with the creation of the API Gateway database. The global variable in question is the “log_bin_trust_function_creators” variable. By setting this variable to on conditions surrounding function creation are relaxed and the database creation should proceed without issue. For more information on this subject please review the MySQL Binary Logging documentation.

Environment

This article applies to all supported versions of the API Gateway when installing the software form factor.

Resolution

One way to confirm if this is caused by the binary logging is to check the /opt/SecureSpan/Gateway/config/logs/config.log file and locate text that may read similar to the following:

 You do not have the SUPER privilege and binary logging is enabled

If the above log entry is found, this is for sure a binary logging-caused issue in MySQL. Be sure to follow the steps below to resolve:

  1. Access the MySQL command line on the node intending to host the SSG database
  2. Issue the following command: SET GLOBAL log_bin_trust_function_creators = 1;
  3. Repeat the steps indicated in the product documentation: Configure the Gateway Application (Software)

Additional Information