Database schema/structure of hardware appliance gateway and virtual appliance gateway

Products

• CA Mobile API Gateway
• CA API Gateway

Issue/Introduction

Hi Team,

For testing a use case we need to enable and disable local admin account on API Database.

Please find below command which was effective when we had hardware appliance in bank premises.

mysql>update logon_info SET fail_count\=0 where login\="admin";

 

As you are aware that, We have migrated from hardware appliance to virtual appliance(vm) where database structure is different on new platform. We need to make sure if we can still use below command on new database without any side impact. 

Environment

Release :

Component :

Resolution

For the same version of the gateway, the ssg database schema is the same for hardware appliance gateway and virtual appliance gateway.