Keys in the ODB /Logger/Runlog/SQL subtree
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/Username
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.