1. Home
  2. Knowledge Base
  3. Articles (EN/ES/FR)
  4. Historical database maintenance script configuration

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
Was this article helpful?

Related Articles

Need Support?

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