Keys in the ODB /Logger/Runlog/SQL subtree: Difference between revisions

From MidasWiki
Jump to navigation Jump to search
No edit summary
Line 11: Line 11:




The ODB <span style="color: purple;">''/Logger/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. The The ODB <span style="color: purple;">''/Logger/SQL''</span> subtree will be created by the MIDAS logger ([[mlogger]]) - see [[Logging to a mySQL database]].
The ODB <span style="color: purple;">''/Logger/Runlog/SQL''</span> ODB subtree is a subdirectory of the [[/Logger ODB tree]]. The The ODB <span style="color: purple;">''/Logger/SQL''</span> subtree will be created by the MIDAS logger ([[mlogger]]) - see [[Logging to a mySQL database]].






== Keys in the <span style="color: purple;">''/Logger/SQL subtree</span> ==
== Keys in the <span style="color: purple;">''/Logger/Runlog/SQL subtree</span> ==
The following sections explain the purpose of the keys in this subtree.
The following sections explain the purpose of the keys in this subtree.


Line 25: Line 25:
</div>  
</div>  
   
   
If this key in the [[#top|/Logger/SQL subtree]]  is set, the SQL database will be created.
If this key in the [[#top|/Logger/Runlog/SQL subtree]]  is set, the SQL database will be created.


<br>
<br>
Line 40: Line 40:


If this key in the [[#top|/Logger/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
If this key in the [[#top|/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
[[Keys in the ODB /Logger tree #/Logger/Write data |/Logger/Write data key]].  
[[Keys in the ODB /Logger tree #/Logger/Write data |/Logger/Write data key]].  


Revision as of 18:00, 10 November 2022

Links



The ODB /Logger/Runlog/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.


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/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/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=3135"