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

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

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:

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/

To restore the "Online configuration database" run the following commands:

export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db"
cd cern_pddaq_db
conftool.py importDatabase

To restore the "Run History database" run the following commands:

export ARTDAQ_DATABASE_URI="mongodb://127.0.0.1:27037/cern_pddaq_db_archive"
cd cern_pddaq_db_archive
conftool.py importDatabase

-- GennadiyLukhanin - 2017-06-06