Historical database maintenance script configuration

Steps to follow:

• Create “dummy” configuration file for the script to get the login data to the history database:

[root@pandora ~]# cp /etc/pandora/pandora_server.conf /etc/pandora/pandora_historic.conf
[root@pandora ~]# vi  /etc/pandora/pandora_historic.conf

• We have copied the original /etc/pandora/pandora_server.conf to create the “fake” file in which we should modify the following parameters:

dbname pandora
dbname nameDBhistoric
dbuser pandora
dbpass passDBhistoric
dbhost ipDirDBhistoric

• Previously it is necessary to give privileges in the historical DB machine so that it can be accessed remotely with the previously commented data
• Create a file to execute every hour maintenance script:

[root@pandora ~]# vi /etc/cron.hourly/historico_db
"/usr/share/pandora_server/util/pandora_db.pl" "/etc/pandora/pandora_historico.conf" >/dev/null 2>&1

• We can test that the execution of the script with the created file is correct:

[root@pandora ~]# /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_historico.conf