Layer7 API Gateway: Unable to determine database version (incorrect credentials?), cannot upgrade

Products

• CA API Gateway

Issue/Introduction

If you are upgrading your CA API Gateway from 9.3 to 9.4 you will be required to upgrade your Database from the Gateway SSG Menu with the following options:

Option 2) Display CA API Gateway configuration menu
Option 1) Upgrade the CA API Gateway database

If you run this procedure you may see the following error:

Unable to determine database version (incorrect credentials?), cannot upgrade

In this scenario your MySQL services may be running but your Gateway SSG Service status may show: WONT_START.  This status can be seen with:

Option 2) Display CA API Gateway configuration menu
Option 7) Manage CA API Gateway status

Upon trying to start the SSG Services you may also see the following messages in your ssg log (/opt/SecureSpan/Gateway/node/default/var/logs/ssg_0_0.log)

**** Unable to start the server: The version mismatch between the database (version 9.3.00) and Gateway (version 9.4.00) is too great.The database version must be within two major versions of the Gateway and cannot be lower.To resolve, either upgrade the database or the Gateway.

Environment

CA API Gateway 9.3 / 9.4 in a clustered environment with local MySQL DB (and replication between nodes)

This document is specifically for the Layer7 API Gateway Appliance form-factor

Cause

The errors could indicate a problem with your MySQL grants for the default MySQL root account.

Resolution

Log into the Primary Gateway Node and drop into the root shell with:

Option 3) Use a privileged shell (root)

Run the command:  mysql ssg 

From the MySQL Command Prompt run the following commands:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Now try to run the Database Upgrade procedure again for better results.

Additional Information

The following document references the Database Upgrade Procedure detailed in the formal CA API Gateway 9.3 documentation, linked below:

Specifically Step 8: Upgrade the Gateway Database