Database upgrade error of Upgrade API Gateway 9.2 (Software )

Document ID : KB000005756
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

In upgrade API Gateway to 9.2. 

Error occurred in the following. 

 

https://docops.ca.com/ca-api-gateway/9-2/en/install-configure-upgrade/upgrade-the-gateway/upgrade-a-software-gateway 

"Upgrade Gateways on RHEL/CentOS/SUSE Linux" -> "If Using the MySQL Database" -> 12. Upgrade the CA API Gateway database on one node. Tip: To do this, use option 1 ("Upgrade the CA API Gateway database") on the Gateway Main Menu (Software). 

 

/******************************** 

Gateway Database Upgrader. 

Enter 'quit' to exit at any time. 

 

Database upgrade is required. 

 

Software version : 9.2.00 

Database version : 9.1.00 

 

Perform upgrade? [No]: Yes 

Enter Administrative Database Username [root]: 

Enter Administrative Database Password: 

 

Performing database upgrade: 

 

Testing the upgrade on a test database ... 

Creating test database "ssg_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 'ssg_testUpgrade' 

 

No changes have been made to the database. Please correct the problem and try again. 

Press [Enter] to continue 

/******************************** 

 

Also, when Database is remote MySQL, the problem occurs.

 

Environment:
API Gateway 9.1 (Software)API Gateway 9.2 (Software)DB: MySQL.The customer uses remote DB. Box1 (API Gateway)-------Box2(MySQL)
Cause:

This reason is remote DB. 

So, If you use remote DB, gateway account can not create ssg_testUpgrade.

 

Resolution:

Run the following sql statement on the target MySQL: 

 

GRANT ALL ON *.* TO 'gateway'@'%'; 

FLUSH PRIVILEGES; 

 

Restart MySQL and retry the DB upgrade.