Keys in the ODB /Logger/Runlog/SQL subtree
Links
The ODB /Logger/Runlog/SQL ODB subtree is a subdirectory of the /Logger ODB tree. The ODB /Logger/Runlog/SQL subtree will be created by the MIDAS logger (mlogger) - see Logging to a mySQL database.
Keys in the /Logger/Runlog/SQL subtree
The following sections explain the purpose of the keys in this subtree.
Create Database
- Type: BOOL
- Default: "n"
If this key in the /Logger/Runlog/SQL subtree is set, the SQL database will be created.
Write Data
- Type: BOOL
- Default: "n"
If this key in the /Logger/Runlog/SQL subtree is set , the data will be written to the SQL database, provided the MIDAS logger (mlogger) is also set to write the data - see /Logger/Write data key.
Hostname
- Type: STRING
- Default: "localhost"
This key in the /Logger/SQL subtree contains the name of the host where the SQL database is located.
Username
- Type: STRING
- Default: "root"
This key in the /Logger/SQL subtree contains the username for access to the SQL Database.
Password
- Type: STRING
- Default:
This key in the /Logger/SQL subtree contains the (encoded) password for access to the SQL Database.
Database
- Type: STRING
- Default: <experiment name>
This key in the /Logger/SQL subtree contains the name of the SQL Database (predefined as the name of the experiment in ODB Key /Experiment/Name).
Table
- Type: STRING
- Default: "Runlog"
This key in the /Logger/SQL subtree contains the name of the table in the SQL Database.
Links BOR
- Type: DIR
This directory in the /Logger/Runlog/SQL subtree contains links to parameters in the ODB that are to be saved in the SQL Database at Begin-of-run. The links
- Start time ( linked to /Runinfo/Start time)
- Run number ( linked to /Runinfo/Run number)
are created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.
Links EOR
- Type: DIR
This directory in the /Logger/Runlog/SQL subtree contains links to parameters in the ODB that are to be saved in the SQL Database at End-of-run. The link
- Stop time ( linked to /Runinfo/Stop time )
is created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.