ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 237785

calendar_today

Updated On:

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.