<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>Import old data to rrdtool</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Comic Sans MS">Hello,</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">I have some text files with old monitoring data, which should be insered to rrdtool DB and showed with graphics.</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">The files have this form: (timestamp art_avg art_min art_max)</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">===============================</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189585215 0 0 2</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189585515 0 0 3</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189585815 0 0 3</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189586115 5 0 6</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189586415 0 0 2</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189586715 1 1 3</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189587015 7 1 14</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189587315 0 0 2</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189587615 0 0 3</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189587915 0 0 2</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189588215 1 1 4</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189588515 0 0 3</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189588815 0 0 2</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189589115 0 0 1</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1189589415 0 0 21</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">…</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">=================================</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">I created a DB for these data using:</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">rrdtool create test.rrd --start 1188597600\</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> -s 300 DS:art_avg:GAUGE:180:U:U \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> DS:art_min:GAUGE:180:U:U \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> DS:art_max:GAUGE:180:U:U \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> RRA:AVERAGE:0.5:1:8640 \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> RRA:AVERAGE:0.5:1:8640 \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> RRA:AVERAGE:0.5:1:8640</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">========================================</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">I then inserted the data in form:</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">Timestamp:art_avg:art_min:art_max with the command rrdtool update</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">I tried to get the graph with: (for month september 2007)</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">/usr/bin/rrdtool graph test.png \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> -s "00:00 09/01/07" -e "23:59 09/30/07" \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> -v "ZGS Average Response Time" -w 1000 -h 450 -t " ZGS AJA " \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> DEF:art_avg=test.rrd:art_avg:AVERAGE \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> DEF:art_min=test.rrd:art_min:AVERAGE \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> DEF:art_max=test.rrd:art_max:AVERAGE \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> COMMENT:" " \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> LINE1:art_avg#00FFFF:"Average Response Time" \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> LINE1:art_min#FF00FF:"Min Response Time" \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> LINE1:art_min#00FF00:"Max Response Time" \</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS"> COMMENT:" \j"</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">But the graph is empty!!!!</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">When I run </FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">rrdtool fetch test.rrd AVERAGE I get several line like:</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">=================================</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191242100: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191242400: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191242700: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191243000: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191243300: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191243600: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191243900: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191244200: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191244500: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191244800: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191245100: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191245400: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191245700: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">1191246000: nan nan nan</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">==================================</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">Can you tell me please why the graphs are empty</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">Thank you in advance!</FONT>
</P>
<P><FONT SIZE=2 FACE="Comic Sans MS">Cheers,</FONT>
<BR><FONT SIZE=2 FACE="Comic Sans MS">Hicham</FONT>
</P>
<BR>
<BR>
</BODY>
</HTML>