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.
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:
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.
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.
Select
, Drop
, Create
and References
. Example:root
.pandora
or Pandor4!
.localhost
.db_test
.