Disaster Recovery11 minutes to read
In the event of a disaster or data loss, you can restore the backed up data to the Password Manager Pro database. To restore the data, Password Manager Pro provides scripts. The following topics are covered in this document: 1. Configuration Steps for PostgreSQL and MySQLThe following steps are required for disaster recovery for Password Manager Pro with PostgreSQL (OR) MySQL as the backend database.
i. For Windows
ii. For Linux
2. Configuration Steps for MS SQL ServerFollow the below steps for disaster recovery if Password Manager Pro is running with MS SQL server as the backend database. 2.1 PrerequisitePassword Manager Pro uses SQL server's encryption mechanism to encrypt the data. The encryption master key will be stored under <PMP Installation Folder>/conf directory with the name masterkey.key. For security reasons, during installation of MS SQL, we recommend moving the encryption key from the default location to a secure location and use it while performing disaster recovery. Step 1Install another instance of Password Manager Pro with MS SQL server as the backend. You are now specifying a new instance of MS SQL server where the backup has to be restored. Ensure that the new instance of MS SQL server is configured with SSL. For details, refer steps 1 to 3 under MS SQL Configuration. Step 2Copy the Password Manager Pro backup file from the SQL server. By default, it will be present under <MSSQL_installation_folder>/Backup folder and have the name something like pmpbackup_pmpversion_backupdate-time.bak (For example, pmpbackup_6400_110721-1159.bak). Click here to learn more about taking backups of your Password Manager Pro data. The backups taken from the MS SQL database will be stored as a .bak file in the host, where the SQL server is running. Step 3Launch Microsoft SQL Server Management Studio (in the machine where the backed up data are to be restored - that is, another instance of SQL server) and connect to the Database Engine. Step 4Right-click on Databases and the click Restore Database from the displayed menu. Step 5In the Restore Database window, choose the option From device and click [...] button to browse the Password Manager Pro backup file. Step 6In the Specify Backup window that opens up, choose the option File as the Backup media and click Add. Step 7In the Locate Backup File window, select the Password Manager Pro backup file and click OK. Step 8
Step 9Now, you need to restore the Master Key. As mentioned in the prerequisite section above, by default, the encryption master key will be stored under <PMP Installation Folder>/conf directory in the file named masterkey.key. For security reasons, if you have moved the file to some other secure location, identify that. Open the masterkey.key file and copy the password. Step 10Connect to the SQL server in which you have restored the Password Manager Pro backup file.
use write_the_name_of the restored_database;
Example:
use passtrix;
Execution of the above queries will help decrypt the data. Step 11Navigate to <PMP_Installation_Folder>/conf folder, edit manage_key.conf and specify the location of pmp_key.key (encryption master key). PMP requires the pmp_key.key file accessible with its full path when it starts up every time. After a successful start-up, it does not need the key anymore and so the device with the key file can be taken offline.
©2024, ZOHO Corp. All Rights Reserved. | |