Version 7 by Connie Logg
on Sep 06, 2006 14:47.

<< Changes from 6 to 7
compared with
Current by Connie Logg
on Sep 06, 2006 15:26.

 
Key
These lines were removed. This word was removed.
These lines were added. This word was added.

View page history


There are 1 changes. View first change.

 The [MONHOST |http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#MONHOST]table contains the information required by a monitoring host. Note that the entry in the NODES table for a monitoring host must be fully populated. The MONHOST table can be populated by creating a csv file, or by logging into MySQL and using the 'INSERT into MONHOST ....' command.
  
 Note that in case of a csv file, each node must have its infomation contained on one line, and the csv file must be a UNIX flat file (not a DOS file). For example:
 {noformat}
 TABLENAME=MONHOST
 #nodeid,srcDir,reportsDir,webPath,siteName,daysToAnalyze,dataToAnalyze,cgiDir,cgiPath
 ##caltech - The following must be on one line
 2,/home/iepm/v3src,/home/iepm/public_html,http://socrates.cacr.caltech.edu,
 IEPM-BW @ CACR.CALTECH.EDU,28,
 ping:avg=w i lt 1;ping:min=w i lt 0;abwe:avdbcap=w p lt 5;abwe:avabw=w p lt12;abwe:avxtr=w p lt 8,
 /var/www/cgi-bin,http://socrates.cacr.caltech.edu/cgi-bin
 {noformat}
 Note that 'nodeid' is the 'nodeid' of the node in the NODES table.
  
 Once the csv file is created it can be loaded by
 {code}
 $bandsrc/mysql/load-table-from-csv -f filename
 {code}
 An sql command can also be used to enter a monitoring host into the MONHOST table. For example:
 {code}
 INSERT into MONHOST (nodeid,srcDir,reportsDir,webPath,siteName,daysToAnalyze,dataToAnalyze,cgiDir,cgiPath)
 values (2,'/home/iepm/v3src','/home/iepm/public_html','http://socrates.cacr.caltech.edu',
 'IEPM-BW @ CACR.CALTECH.EDU',28,
  'ping:avg=w i lt 1;ping:min=w i lt 0;abwe:avdbcap',
  'ping:avg=w i lt 1;ping:min=w i lt 0;tlaytcp:tlaytcp=w p lt 8;pathload:thrumin=w p lt 4',
 '/var/www/cgi-bin','http://socrates.cacr.caltech.edu/cgi-bin');
 {code}
 The dataToAnalyze field is a specification for the data to be analyzed and how it is to be plotted via GNUPLOT.&nbsp; The form of it is:
  
 'datafile_suffix:column_heading=gnuplot_spec'.
  
 Datafile suffixes currently existing are: ping, trace, iperf, miperf, pathload, pathchirp, tlaytcp.