Issue upgrading Gateway database to 9.3

book

Article ID: 74992

calendar_today

Updated On:

Products

CA API Gateway (Layer 7) SA94 to API SECURITY STARTER PACK-7 CA Rapid App Security MOBILE API GATEWAY CA Mobile - API Gateway CA API Gateway

Issue/Introduction

When trying to upgrade a software appliance 9.2 CR7 to 9.3 and getting to the database upgrade we might get "Unable to determine database version (incorrect credentials?), cannot upgrade." when trying to upgrade the database even though our password has not changed.

 

Getting "Unable to determine database version (incorrect credentials?), cannot upgrade." when trying to upgrade the database even though our password has not changed.

Environment

Red Hat 6.9, Gateway 9.2 CR7 software edition.

Resolution

Env: Gateway 9.2 CR7 software edition.
Installing the MYSQL 5.7 Server RPM was not enough.
Running the below command:
mysql_upgrade -u root -p<password>
and then restarting MYSQL resolved the problem.