FortiManager
FortiManager supports network operations use cases for centralized management, best practices compliance, and workflow automation to provide better protection against breaches.
kcapecchi
Staff
Staff
Article Id 189835

Description

 
This article describes how to verify and correct certain database integrity errors.
CLI commands that can be used:
 
diagnose pm2 check-integrity all
diagnose dvm check-integrity
diagnose cdb check objcfg-integrity
diagnose cdb check policy-assignment
diagnose cdb check policy-packages root
diagnose cdb check adom-integrity
diagnose cdb upgrade check +all

Not all integrity problems can be detected and corrected by these commands.

If a database correction is attempted, it is recommended to run the command a second time in order to confirm that the changes were correctly done.

 

Scope

 

FortiManager.


Solution

 
The FortiManager database can also be checked using the SQLite Studio application from sqlitestudio.pl. Here is the procedure to use it:
 
  1. Rename the FortiManager Backup with a .tgz extension and unarchive to disk. Locate the /var/pm2/global.db files.
  2. Open these files with the SQLite Studio application.
  3. Perform an Integrity check as per the following screenshots. The results should indicate 'ok' if the FortiManager database is in a good state.

    ccapecchi_FD36512_tn_FD36512-1.jpg

    ccapecchi_FD36512_tn_FD36512-2.jpg