upgrade database fails after applying gateway 11.1.x

Products

• CA API Gateway

Issue/Introduction

After installing gateway 11.1.x the database upgrade is failing on software .

when  trying to upgrade the database after a Software Gateway upgrade from v11.0 to v11.1(GA)

See following output from that action:

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

Database upgrade is required.

 Software version : 11.1.00
 Database version : 11.0.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:

Your password does not satisfy the current policy requirements

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

The root password does meet the password settings of the external MySQL server.

 

Resolution

The database upgrade creates a temp database using the database user used in gateway to connect to the MySQL database which is by default the user "gateway".

The  password for this user needs to comply with the external MySQL server password rules.