Configure gateway failure due to special char in database password

Products

• CA Mobile API Gateway

Issue/Introduction

Configure gateway on the gateway menu, to connect to an existing database.

When run mysql command on gateway to login mysql database, the DB credential is correct.

But on gateway menu, input the same dabase user/password, it fails with error "Access denied for user 'xxx'@'xxxxxxx' (using password: YES)'.''"

Environment

Release : 2.0

Cause

The database password has special chars like '<', '>', etc. which cannot be handled properly by the gateway configure script.

Resolution

When configure gateway on the gateway menu, the db user password cannot have special chars ( for e.g. \.[]{}()<>*+-=!?^$| )