1. Home
  2. Knowledge Base
  3. Articles (EN/ES/FR)
  4. Solution to the Database Maintenance notification

Solution to the Database Maintenance notification

When we find this message in the Pandora FMS notification system, it indicates that the database maintenance script is not being executed, this script has to be executed every hour and it is used to keep our DB in optimal state, delete old data, pass data to the historical DB (in case it is configured), etc.

Of course we do not have to launch it manually every hour, if we do not have to leave it programmed in the cron of the system, for it:

  • We create the file called pandora_db with the following content:
[root@pandora ~]# vi pandora_db
"/usr/bin//pandora_db" "/etc/pandora/pandora_server.conf" >/dev/null 2>&1
  • We move this file to the run system’s cron directory every hour on the hour:
[root@pandora ~]# mv pandora_db /etc/cron.hourly/
  • To make sure that the script runs smoothly we can run it once manually and see that the script finishes successfully:
[root@pandora ~]# /usr/bin/pandora_db /etc/pandora/pandora_server.conf
  • Note: If the script has not been executed for a long time this operation may take some time to finish.
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support

Recent Discussions