Upgrade SSG DB failed 94 to 10.1
search cancel

Upgrade SSG DB failed 94 to 10.1

book

Article ID: 224693

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Getting Access denied for user 'gateway'@'%' to database 'ssg10_testUpgrade'

Gateway Database Upgrader.
Enter 'quit' to exit at any time.

Enter database host [localhost]: <HostName>
Enter database port [3306]:
Enter database name [ssg]: ssg10
Enter database username [gateway]: 
Enter database password:
Database upgrade is required.

 Software version : 10.1.00
 Database version : 9.4.00

Perform upgrade? [No]: yes
Enter Administrative Database Username [root]: gateway
Enter Administrative Database Password:

Performing database upgrade:

  Testing the upgrade on a test database ...
  Creating test database "ssg10_testUpgrade" (without audits).
  Database creation may take a few minutes.
  The database was not upgraded due to the following reasons:

Access denied for user 'gateway'@'%' to database 'ssg10_testUpgrade'

No changes have been made to the database. Please correct the problem and try again.
Press [Enter] to continue

Environment

Release : 10.1

Component :

Cause

Root cause the documentation are missing key steps when the SSG database is external and named different  (Permission to create and test the upgrade)

 

Resolution

Link from the 9.4 docs for scenario 2

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/9-4/install-configure-upgrade/upgrade-the-gateway/expedited-appliance-upgrade/upgrade-scenario-2-database-on-separate-host.html

Resolution 

Modify Permissions on the Database Host

Next, perform these permissions grants on the master database host:

Run the following MySQL commands to modify the permissions for the Administrative Database User (ADU);

  1. CREATE USER '<ADU>'@'<HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
  2. GRANT ALL ON <DBNAME>_testUpgrade.* TO '<ADU>'@'<HOSTNAME>' IDENTIFIED BY 'password' WITH GRANT OPTION;
  3. GRANT ALL ON <DBNAME>.* TO '<ADU>'@'<HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
  4. GRANT ALL ON mysql.* TO '<ADU>'@'<HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
  5. FLUSH PRIVILEGES;