This document describes how to recover from a Video Surveillance Manager (VSM) High Availability (HA) standby server's databases that are left empty when the HA configuration is deleted.
The HA feature in VSM uses symmetric MySQL replication in order to keep both of the Operations Manager (VSOM) servers' databases in sync. The initial configuration of HA overwrites the VSOM database of the standby server so a snapshot of the primary server's database can be copied over.
When HA is deleted, the database on the standby server is cleared out.
Verify the Problem
Use this command from root to check if the database has been cleared:
echo "select objectid,name,objecttype,VSMCSOFTWAREVERSION from server;" | /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/db.cnf VSOM
There should be at least one line that comes back.
Recovery takes a few steps from the command line:
service cisco stop
service cisco start
Navigate to the VSOM GUI's login page and log in as admin with the password admin. It might take a few minutes for the databases to sort themselves out and be ready for login, so be patient.
The system will ask you to set the admin password just as if it was a new install.
After you set the password and ensure that the standby server is in a functional state, you can navigate to the primary server and create HA again.