ArtdaqDatabaseInstallation < CENF

CENF Web>WebPreferences>ArtdaqDatabaseInstallation (2020-03-24, GennadiyLukhanin) (raw view)

---+Artdaq database bundle installation instructions.

Log into np04-srv-010 using np04daq account ( =ssh np04daq@np04-srv-010= ) and do the following:
   * Copy the artdaq_database.env file to the home (=$HOME=) directory of the np04daq user. (=cat $HOME/artdaq_database.env=)
   * Download the installation script. ( =wget= https://cdcvs.fnal.gov/redmine/projects/artdaq-utilities/repository/database/revisions/develop/raw/artdaq-database/deployment-scripts/install_artdaq_database.sh
 )
   * Make it executable. ( =chmod a+x ./install_artdaq_database.sh= )
   * Run it. ( =./install_artdaq_database.sh |tee install.log= )
---++Note: Respond with =YesIam!= to the first prompt.

The installation script does the following: installs additional artdaq database products, creates systemd startup scripts, installs and configures mongo database, and starts it up. It uploads a sample artdaq configuration into the ardaq database, reads it back and compares it to the one that was loaded. After that, it starts up webcongigeditor, wgets the default page (to make sure that the majority of plumbing is working), and finally, it stops mongo database and webcongigeditor.  For additional details review the installation script itself and log files. 

---+=artdaq_database.env=
<verbatim>
ARTDAQ_BASE_DIR=/local_volume/db_install_dir
ARTDAQ_DB_UPS_VER=v1_04_84
WEBEDITOR_UPS_VER=v1_01_07
ARTDAQ_UPS_QUAL="e17:prof:s87"
MONGOD_UPS_QUAL="e17:prof"
ARTDAQ_DB_NAME=cern_pddaq_v3x_db
ARTDAQ_DB_PULLPRODUCTS="slf7 artdaq_database-${ARTDAQ_DB_UPS_VER} s87-e17 prof"
ARTDAQ_DB_MANIFESTURL="https://cdcvs.fnal.gov/redmine/projects/artdaq-utilities/repository/database/revisions/${ARTDAQ_DB_UPS_VER}/raw/built-in/manifests/artdaq_database-build-Linux64bit+3.10-2.17-s87-e17-prof_MANIFEST.txt"
https_proxy=https://np04-webgw1.cern.ch:3128
http_proxy=http://np04-webgw1.cern.ch:3128
</verbatim>

---+Restore Artdaq database from a nightly backup.

Artdaq database is backed up nightly on np04-srv-010.cern.ch into the /nfs/back/database/cern_pddaq_v3x_db/backup/[DATETIME]/ directory. 

Setup artdaq_database:
<verbatim>
source /nfs/sw/artdaq/products/setup
setup artdaq_database v1_04_84 -q e17:prof:s87
# cd into the directory with the latest backup
cd /nfs/back/database/cern_pddaq_v3x_db/backup/20180606013002/
</verbatim>
Note: Restoring the database can take 20-40 minutes depending on the performance of the server hardware; e.g. restoring a backup from 06/06/2018 on mu2edaq11 took around 20 minutes.   


To restore the "Online configuration database" run the following commands:
<verbatim>
export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db"
cd cern_pddaq_db
conftool.py importDatabase
</verbatim>

To restore the "Run History database" run the following commands:
<verbatim>
export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db_archive"
cd cern_pddaq_db_archive
conftool.py importDatabase
</verbatim>

-- Main.GennadiyLukhanin - 2017-06-06

Topic revision: r4 - 2020-03-24 - GennadiyLukhanin

CENF

Public webs

- Cern Search
- TWiki Search
- Google Search
CENF All webs

Copyright &© 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback