Database Management from the Console

The core of Pandora FMS system is its database.

It stores all the data collected by the monitored systems, agent configurations, alerts, events, audit data, different users and their information. In other words, all system data.

There are several extensions you can use from the web Console to view information about the database. Some of them are described here.

Diagnostic info

Management → Admin tools → Diagnostic info menu.






This section displays general information about the Pandora FMS installation. It shows recommended parameters as well as warnings about existing values that need to be changed.

It may take a few moments to load all the information. Then it will show the following sections:

  1. Info status Pandora FMS: With installed versions, a link to access the Console, and basic license information.
  2. PHP setup: Installed PHP language version and configured values for execution time, timeout, and memory handling.
  3. Database size stats: Basic database information and its usage with PFMS.
  4. Database health status: Includes, among other values, the last execution of the script pandora_db.
  5. Database status info: Installed database version.
  6. System Info: Information about the hardware and operating system hosting the web Console.
  7. MySQL Performance metrics: Displays a series of recommended values and compares them with the configured ones. Validated values are denoted with the icon , items that need correction are shown with the icon .
  8. Tables fragmentation in the Pandora FMS database: Analyzes table fragmentation to keep it below the recommended percentage (10% by default).
  9. Pandora FMS logs dates: Size of log files.
  10. Pandora FMS Licence Information: Extended information about the license in use.
  11. Status of the attachment folder: Total number of files in the attachment directory.
  12. Information from the tagente_datos table: Special table with agent data and information; its size should be constantly monitored.
  13. Pandora FMS server threads: Threads used for different PFMS servers.
  14. Date system: Date and time of the web Console (which may differ from the date and time of the database).

Additionally, graphs representing the self-monitoring of the PFMS Server modules will be shown at the end.

DB Interface

Management → Admin tools → DB Interface menu.






It is an extension that allows you to execute commands on the database and view the results. This is an advanced tool that should only be used by people who are familiar with SQL and the Pandora FMS database schema in sufficient detail. It is reserved for users of type superadmin.

Improper use of this tool can destroy data or render the application permanently inoperable. It should be used with caution.

DB Schema Check

Menu Management → Admin tools → DB Schema check.






This extension allows you to check for structural differences between the Pandora FMS database and a reference schema to compare potential errors. It is recommended to use this extension to verify if a database migration has been performed correctly.

This check can only be performed on MySQL databases. The user must have privileges for the SELECT, DROP, CREATE, and REFERENCES commands.

  • DB User with privileges: root.
  • DB Password for this user: pandora or Pandor4!.
  • DB Hostname: localhost.
  • DB Name (testing purposes only; temporary): db_test.

Steps taken during the check:

  • A temporary database is created with the structure the installation database should have (different depending on the installed version).
  • The schema of the created database is compared with the database schema referenced in the installation.
  • The temporary database is deleted.
  • The results are displayed, and if something is incorrect, messages with instructions will be shown to bring the database to its correct structure.

Back to the Pandora FMS documentation index