search cancel

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


Article ID: 237785


Updated On:


CA Mobile API Gateway CA API Gateway


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. 


Release :

Component :


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