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_dbwith 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.