...
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.