• Created by Unknown User (cal), last modified on Sep 06, 2006

The 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:

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

Note that 'nodeid' is the 'nodeid' of the node in the NODES table.

Once the csv file is created it can be loaded by

$bandsrc/mysql/load-table-from-csv -f filename

An sql command can also be used to enter a monitoring host into the MONHOST table. For example:

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;tlaytcp:tlaytcp=w p lt 8;pathload:thrumin=w p lt 4',
'/var/www/cgi-bin','http://socrates.cacr.caltech.edu/cgi-bin');

The dataToAnalyze field is a specification for the data to be analyzed and how it is to be plotted via GNUPLOT.  The form of it is:

'datafile_suffix:column_heading=gnuplot_spec'.

Datafile suffixes currently existing are: ping, trace, iperf, miperf, pathload, pathchirp, tlaytcp.

  • No labels