Keys in the ODB /Logger/Runlog/SQL subtree

From MidasWiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

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

is created automatically by the MIDAS logger (mlogger) the first time it runs. The user may add other links as desired.

Retrieved from "https://daq00.triumf.ca/MidasWiki/index.php?title=Keys_in_the_ODB_/Logger/Runlog/SQL_subtree&oldid=3161"