L7 API GW MySQL Repl Issue After Applying Layer7_API_PlatformUpdate_64bit_v11.0-Debian-2024-12-16

Products

• CA API Gateway

Issue/Introduction

 ==> Error creating Gateway database user: 'uatgw'

        Message: mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'uatgw'@'%'

        Refer to https://dev.mysql.com/doc/mysql-errors/8.0/en/client-error-reference.html
        for more information.

Environment

11.0

Resolution

The customer did not have a gateway user created , the script that is running to run the replication between the database does not create the gateway user , so we had to create the gateway user specifically inside the secondary database node .