...
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:
No Format |
---|
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/privatedir,/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
Code Block |
---|
$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:
Code Block |
---|
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.