Database Management from the Console

The core of the Pandora FMS system is its database. It stores all the data collected by the monitored systems, the configuration of the agents, the alerts, the events, the audit data, the different users and their data. That is, all the data in the system.

There are several extensions that you can use from the Console to view information about the database.

Diagnostic tool

In this section you can view general information about the Pandora FMS installation. The recommended parameters are shown, as well as warnings about existing values that need to be changed.

Menu Management → Admin tools → Diagnostic info. Sections:

  1. Info status Pandora FMS.
  2. PHP setup.
  3. Database size stats.
  4. Database health status.
  5. Database status info.
  6. System Info.
  7. MySQL Performance metrics.
  8. Tables fragmentation in the Pandora FMS database.
  9. Pandora FMS logs dates.
  10. Pandora FMS Licence Information.
  11. Status of the attachment folder.
  12. Information from the tagente_datos table.
  13. Pandora FMS server threads.
  14. Date system.

DB Interface

Improper use of this tool may destroy data or render the application permanently inoperative. Use with caution.

It is an extension that allows to execute commands in the database and see its result. Advanced tool that should only be used by people who know SQL and the Pandora FMS database schema with enough detail.

Menu Management → Admin tools → DB Interface.

DB Schema Check

This check can only be performed on MySQL databases.

This is an extension that allows to check the structural differences between the established Pandora FMS database, and a pattern scheme to compare possible errors.

Menú Management → Admin tools → DB Schema check.

It is recommended to use this extension to check if a database migration has been performed correctly.

  • The user must have privileges to Select, Drop, Create and References. Example:
    • DB User with privileges: root.
    • DB Password for this user: pandora or Pandor4!.
    • DB Hostname: localhost.
    • DB Name (testing purposes only; temporary): db_test.
  • A temporary database is created with the structure that the installation database must have (different depending on the version installed).
  • The schema of the database created is compared with that of the database referenced in the installation.
  • The temporary database is deleted.
  • The results are displayed, if something is incorrect, messages will be displayed with instructions to follow to bring the database to its correct structure.

Return to Pandora FMS documentation index