The MTD construction DB - CMSROMA/MTDDB GitHub Wiki

The MTD construction DB is under the responsibility of [email protected]. It is part of the CMS construction DB managed centrally. The structure of the DB is common to all subdetectors.

The DB operations allows users to browse or provide data, depending on their role.

At least for the moment, data can only be accessed from within the CERN network. If you are outside the CERN network you need to setup a proxy as described, e.g., here: https://security.web.cern.ch/recommendations/en/ssh_browsing.shtml

Due to a lack of support on DCA (see below), we switched to OMS to show data stored in the DB. The system is still in development, though working rather well, and can be accessed pointing your browser to [[http://vocms0183.cern.ch][http://vocms0183.cern.ch]]. Then, select MTD as subsystem. You need a setup an ssh tunnel, if outside CERN. Refer to the documentation above.

Instruction for operators and shifters are here

The information provided here is intended to explain the general process of registering a part, from the point of view of atomic operations.

Use registerMTDPart.pl to register parts in the DB. The script takes arguments, from which it generates an XML file, which is then transferred to the dbloader-mtd.cern.ch machine, where it is interpreted, and DB is populated. The transfer is made using ssh on a dedicated port (50022). An ssh tunnel is needed from outside CERN.

The script actually produces two XML files: xxx.xml and cond-xxx.xml. The latter contains data collected during registration, such as pdata and/or operator comments. They must be transferred in the right order (xxx.xml first).

Users must be authorised to upload data to the dbloader (please contact [email protected] for that must declare you as belonging to the CERN e-group cms-mtd-db in https://e-groups.cern.ch/e-groups/).

The operations needed to create the ssh tunnel are managed by the registerMTDPart.py script. The information below are intended as a documentation of the process.

The ssh tunnel needed to upload data to the dbloader can be created as follows:

ssh -L 50022:dbloader-mtd.cern.ch:22 <your-cern-username>@lxplus.cern.ch

The XML files are copied onto the db-loader machine as follows:

scp -P 50022 -oNoHostAuthenticationForLocalhost=yes registerMatrixBatch.xml <your-cern-username>@localhost:/home/dbspool/spool/mtd/cmsr/<new-name>.xml
scp -P 50022 -oNoHostAuthenticationForLocalhost=yes cond-registerMatrixBatch.xml <your-cern-username>@localhost:/home/dbspool/spool/mtd/cmsr/<new-name>.xml

The content of the files is then automatically loaded into the DB. Logs of the operations can be found on db-loader:

ssh -p 50022 <your-cern-username>@localhost ls /home/dbspool/logs/mtd/cmsr

You can then retrieve them or just look at their content as

ssh -p 50022 <your-cern-username>@localhost cat /home/dbspool/logs/mtd/cmsr/<new-name>.xml

Numbering of matrices according to a mail exchanged between R. Paramatti, M. Lucchini and G. Organtini type #1: 3.75 mm type #2: 3.00 mm type #3: 2.40 mm Consistent with market survey. Type #1 is the innermost type (eta=0).