Changes between Version 10 and Version 11 of Tutorials/a0Basic/Tutorial3

Timestamp:

Jan 17, 2006, 5:39:12 PM (19 years ago)

Author:

faiyaz

Comment:

—

Tutorials/a0Basic/Tutorial3

@@ -4 +4 @@
 It is important to understand how measurements were collected and organized to be able to interpret them. The [wiki:OML ORBIT Measurement Framework] provides tools to insert points to tap available information and to effectively collect that information in a timely manner. And after the experiment is done, the user would get access to the exprimenet database generated. In general, the results of the experiment is in one [http://www.mysql.com MySQL] database. Different participating nodes populate different tables of this database. Usually, user would like to post-process or visualize those raw measurements for further analysis.
 
-A number of different tools are available to interpret experimental results.  The choice of tools depends upon availability and the nature of the measurements. '''Excel and Matlab connections from your local laptop to our database server may be blocked by the firewall. Hence, until we are working on figuring out a proxy service to expose these databases based on user credentials, please use the Perl script approach.'''
+A number of different tools are available to interpret experimental results.  The choice of tools depends upon availability and the nature of the measurements. '''Excel and Matlab connections from your local laptop to our database server may be blocked by the firewall. Hence, until we are working on figuring out a proxy service to expose these databases based on user credentials, please use any of the following approaches.'''
 
+== MySQL Client ==
+
+The easiest way to access your data is by manipulating the database directly with the MySQL Client.  From gateway.orbit-lab.org (or any of the consoles), you may access your database by issuing the following commands from the command line:
+
+{{{
+$ mysql -h idb1 -u orbit -p
+Enter password:
+Welcome to the MySQL monitor.  Commands end with ; or \g.
+Your MySQL connection id is 153 to server version: 4.1.15-Debian_1-log
+
+Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
+
+mysql> use   <DB NAME>;
+
+}}}
+
+Standard MySQL queries can then be made to manipulate your data.  A brief tutorial on how to use MySQL can be found [http://dev.mysql.com/doc/refman/4.1/en/index.html here].
+
+At the moment, all experiment databases share the same user and password;  "orbit".  The database name is your experiment ID and is displayed by the nodehandler in the first few lines of your experiment run.  It will look something like this:
+{{{
+ INFO init: Experiment ID: sb5_2006_01_17_11_45_23
+}}}
 
 == Using Perl scripts ==