Using the Policy Manager for Linux Database Recovery Tool (Version 10.00 and later)

This discussion has a more recent version.
Khairul_A Posts: 272 F-Secure Employee
This article describes the use of the database recovery tool available since PM version 12.10. If you are running the Policy Manager version 12.00 or older, use the following recovery tool available on our ftp server:
  • Tool: <A href="" target="_blank" rel="noopener noreferrer"></A>
  • Documentation: <A href="" target="_blank" rel="noopener noreferrer"></A>

Command name



Depending on which recovery information you want to use:

  1. Recovery DB with all data from default DB directory of PM


    fspms-db-recover <recovered-db-dir>
  2. Recovery DB with all data from specific corrupt DB directory

    fspms-db-recover -curDir=<corrupt-db-dir> <recovered-db-dir>
  3. Recovery DB without Scanning Reports

    fspms-db-recover -noReports <recovered-db-dir>
  4. Recovery DB without Alerts

    fspms-db-recover -noAlerts <recovered-db-dir>
  5. Recovery DB without Scanning Reports and Alerts from the custom database directory

    fspms-db-recover -noReports -noAlerts -curDir=<corrupt-db-dir> <recovered-db-dir>
  6. Recovery DB without Scanning Reports and Alerts from default DB directory of PM


    fspms-db-recover -noReports -noAlerts <recovered-db-dir>


At the output, the

  • Valid H2 database files;
  • Management keypair with the password 'password'.

The result of the recovery operation is written into the file named 'recovery.log' in the current directory.


  • fspms-db-recover /tmp/h2db-recovered
  • fspms-db-recover -curDir=/tmp/h2db /tmp/h2db-recovered
  • fspms-db-recover -noAlerts -curDir=/tmp/h2db /tmp/h2db-recovered

Notes and issues

  • Always use the recovery tool provided with your installation of Policy Manager. If you are using Policy Manager version 12.00 or older, you can download the tool from our ftp server (see above). The recovery tool automatically identifies the version of Policy Manager. If it is unable to identify the Policy Manager version and recover the database, please contact F-Secure support.
  • When recovering the database from the default directory (no
    parameter is specified), Policy Manager Server must be stopped before running the tool.
  • In some cases, the database is broken so badly that it can't be opened at all. In this case, the 'recovery.log' file will contain an error message similar to the following:

    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; 

    Unfortunately, this indicates that there's no way to recover this database.

  • In other cases, some of the vital tables cannot be recovered automatically. However, there's still a chance to rescue the data from those tables manually. In this case, please contact F-Secure support.

Contact information

Please submit any issues you might be facing to F-Secure support according to the support contact information available in your License Agreement.