Keys in the ODB /Logger/Runlog/SQL subtree
Links
The ODB /Logger/SQL ODB subtree is a subdirectory of the /Logger ODB tree. The The ODB /Logger/SQL subtree will be created by the MIDAS logger (mlogger) - see Logging to a mySQL database.
/Logger/SQL/Create Database
- Type: BOOL
- Default: "n"
If this flag is set, the SQL database will be created.
/Logger/SQL/Write Data
- Type: BOOL
- Default: "n"
If this flag 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.
/Logger/SQL/Hostname
- Type: STRING
- Default: "localhost"
The name of the host where the SQL database is located.
/Logger/SQL/Username
- Type: STRING
- Default: "root"
Username for access to the SQL Database.
/Logger/SQL/Password
- Type: STRING
- Default:
(Encoded) Password for access to the SQL Database.
/Logger/SQL/Database
- Type: STRING
- Default: <experiment name>
Name of the SQL Database (predefined as the name of the experiment in ODB Key /Experiment/Name).
/Logger/SQL/Table
- Type: STRING
- Default: "Runlog"
Name of the Table in the SQL Database.
/Logger/SQL/Links BOR
- Type: DIR
This directory contains links to parameters in the ODB that are to be saved in the SQL Database at Begin-of-run. The links
- Run number ( linked to /Runinfo/Run number )
- Start time ( linked to /Runinfo/Start time)
are created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.
/Logger/SQL/Links EOR
- Type: DIR
This directory 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.