Using the Policy Manager for Linux Database Recovery Tool (Version 10.00 and later) - WithSecure Community
<main>
<article class="userContent">
<p> </p>Using the Policy Manager for Linux Database Recovery Tool (Version 10.00 and later) <div>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: <ul><li>Tool: <code class="code codeInline" spellcheck="false" tabindex="0">https://download.f-secure.com/support/tools/pm/recovery-tool/fspm-recovery-tool-12.10.42001-cf555fd0.zip</code> </li> <li>Documentation: <code class="code codeInline" spellcheck="false" tabindex="0">https://download.f-secure.com/support/tools/pm/recovery-tool/README</code> </li> </ul></div> <p><strong>Command name</strong> </p> <p> </p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover</pre> <p><strong>Usage</strong> </p> <p>Depending on which recovery information you want to use: </p> <div> <ol><li>Recovery DB with all data from default DB directory of PM <p>(<code class="code codeInline" spellcheck="false" tabindex="0">/var/opt/f-secure/fspms/data/h2db</code>) </p> <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover <recovered-db-dir></pre> </li> <li>Recovery DB with all data from specific corrupt DB directory <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover -curDir=<corrupt-db-dir> <recovered-db-dir></pre> </li> <li>Recovery DB without Scanning Reports <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover -noReports <recovered-db-dir></pre> </li> <li>Recovery DB without Alerts <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover -noAlerts <recovered-db-dir></pre> </li> <li>Recovery DB without Scanning Reports and Alerts from the custom database directory <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover -noReports -noAlerts -curDir=<corrupt-db-dir> <recovered-db-dir></pre> </li> <li>Recovery DB without Scanning Reports and Alerts from default DB directory of PM <p>(<code class="code codeInline" spellcheck="false" tabindex="0">/var/opt/f-secure/fspms/data/h2db</code>) </p> <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">fspms-db-recover -noReports -noAlerts <recovered-db-dir></pre> </li> </ol></div> <p><strong>Output</strong> </p> <p>At the output, the <code class="code codeInline" spellcheck="false" tabindex="0">&lt;recovered-db-dir&gt;</code> contains: </p> <div> <ul><li>Valid H2 database files; </li> <li>Management keypair admin.pub/admin.prv with the password 'password'. </li> </ul></div> <p>The result of the recovery operation is written into the file named 'recovery.log' in the current directory. </p> <p><strong>Example</strong> </p> <div> <ul><li><code class="code codeInline" spellcheck="false" tabindex="0">fspms-db-recover /tmp/h2db-recovered</code> </li> <li><code class="code codeInline" spellcheck="false" tabindex="0">fspms-db-recover -curDir=/tmp/h2db /tmp/h2db-recovered</code> </li> <li><code class="code codeInline" spellcheck="false" tabindex="0">fspms-db-recover -noAlerts -curDir=/tmp/h2db /tmp/h2db-recovered</code> </li> </ul></div> <p><strong>Notes and issues</strong> </p> <div> <ul><li>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 <a rel="nofollow" href="https://www.f-secure.com/en/web/business_global/support">F-Secure support</a>. </li> <li>When recovering the database from the default directory (no <code class="code codeInline" spellcheck="false" tabindex="0">-curDir</code> parameter is specified), Policy Manager Server must be stopped before running the tool. </li> <li>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: <p></p><pre class="code codeBlock" spellcheck="false" tabindex="0">org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; </pre> <p>Unfortunately, this indicates that there's no way to recover this database. </p> </li> <li>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 <a rel="nofollow" href="https://www.f-secure.com/en/web/business_global/support">F-Secure support</a>. </li> </ul></div> <p><strong>Contact information</strong> </p> <p>Please submit any issues you might be facing to F-Secure support according to the support contact information available in your License Agreement. </p> <div id="related"> <strong>Related information</strong> <ul><li><a rel="nofollow" href="https://community.f-secure.com/business-suite-en/kb/articles/5639"> Using the Policy Manager for Windows Database Recovery Tool (Version 10.00 and later) </a></li></ul></div> <br>
</article>
</main>