Tracker Databases

Tracker Databases

FNAL Planes Database

The database for the plane construction at FNAL (not in mu2e_tracker_prd).

Importing

To import to mu2e_tracker_prd:

ssh -XY username@mu2egpvmXX.fnal.gov
cd /mu2e/app/users/username/
git clone https://github.com/Mu2e/TrackerHardwareDB
cd TrackerHardwareDB/python
python3 create_imported_fnal_planesdb.py path/to/fnal/planesdb

This will create two .sql files. You will need mu2e_tracker_admin privileges to then do

cd ../sql
psql -h ifdb08 -p 5459 mu2e_tracker_prd < create_imported_fnal_planesdb.sql
psql -h ifdb08 -p 5459 mu2e_tracker_prd < insert_imported_fnal_planesdb.sql

The information can then be viewed using the panel QC viewer below.

Panel QC Database

The panel QC database that is stored in mu2e_tracker_prd

Viewer

Installation

To install the panel QC viewer:

ssh -XY username@mu2egpvmXX.fnal.gov
cd /mu2e/app/users/username/
git clone https://github.com/Mu2e/TrackerHardwareDB
cd TrackerHardwareDB/panel-qc-viewer/
npm install

Running

To run the panel QC viewer:

ssh -L 3000:localhost:3000 -XY username@mu2egpvmXX.fnal.gov
cd /mu2e/app/users/username/TrackerHardwareDB/panel-qc-viewer
npm start

Then you can open a browser and go to localhost:3000 on your local machine

To run on a different port you can type:

 PORT=XXXX npm start