<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texto de globo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.TextodegloboCar
{mso-style-name:"Texto de globo Car";
mso-style-priority:99;
mso-style-link:"Texto de globo";
font-family:"Tahoma","sans-serif";}
span.EstiloCorreo19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EstiloCorreo20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=ES-AR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal>Hello list.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have an issue building graphs using mysql as backend.<o:p></o:p></p><p class=MsoNormal>I use a php script to obtain and generate the graph but there are gaps between values and I don’t know why.<o:p></o:p></p><p class=MsoNormal>Could you please help me?.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>$DS_BASE="sql//mysql/host=myhost/dbname=cotelser/username=myuser/password=mypass/rrdminstepsize=300/rrdfillmissing=0//tbl_DetNASSNMPStats/UNIXTIMESTAMP/IFACE_IN_OCTETS/derive/ID=15/NRORENGLON=9";<o:p></o:p></p><p class=MsoNormal>$DS_BASE2="sql//mysql/host=myhost/dbname=cotelser/username=myuser/password=mypass/rrdminstepsize=300/rrdfillmissing=0//tbl_DetNASSNMPStats/UNIXTIMESTAMP/IFACE_OUT_OCTETS/derive/ID=15/NRORENGLON=9";<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>$command = 'rrdtool graph rrd/test1.png ' . <o:p></o:p></p><p class=MsoNormal> '--slope-mode ' .<o:p></o:p></p><p class=MsoNormal> '--title "INTERFAZ: " ' .<o:p></o:p></p><p class=MsoNormal> '--imgformat=PNG ' . <o:p></o:p></p><p class=MsoNormal> '--start=-1day ' .<o:p></o:p></p><p class=MsoNormal> '--lazy ' .<o:p></o:p></p><p class=MsoNormal> '--height=120 ' .<o:p></o:p></p><p class=MsoNormal> '--width=800 ' . <o:p></o:p></p><p class=MsoNormal> '-l 0 ' .<o:p></o:p></p><p class=MsoNormal> '--vertical-label "byes/sec" ' .<o:p></o:p></p><p class=MsoNormal> '"DEF:in='.$DS_BASE.':max:AVERAGE:step=300" ' . <o:p></o:p></p><p class=MsoNormal> '"DEF:out='.$DS_BASE2.':max:AVERAGE:step=300" ' . <o:p></o:p></p><p class=MsoNormal> '"CDEF:int_m=in,1024,/" ' .<o:p></o:p></p><p class=MsoNormal> '"AREA:in#32cd32:Tráfico Entrante" ' . <o:p></o:p></p><p class=MsoNormal> '"LINE1:in#336600" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:in:MAX: Max\\: %5.1lf %s" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:in:AVERAGE: Avg\\: %5.1lf %S" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:in:LAST: Current\\: %5.1lf %Sbytes/sec\\n" ' .<o:p></o:p></p><p class=MsoNormal> '"CDEF:out_m=out,1024,/" ' . <o:p></o:p></p><p class=MsoNormal> '"CDEF:out_f=out,-1,*" ' . <o:p></o:p></p><p class=MsoNormal> '"AREA:out_f#4169E1:Tráfico Saliente" ' .<o:p></o:p></p><p class=MsoNormal> '"LINE1:out_f#0033cc" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:out:MAX: Max\\: %5.1lf %s" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:out:AVERAGE: Avg\\: %5.1lf %S" ' .<o:p></o:p></p><p class=MsoNormal> '"GPRINT:out:LAST: Current\\: %5.1lf %Sbytes/sec\\n" ' .<o:p></o:p></p><p class=MsoNormal> '"HRULE:0#000000"';<o:p></o:p></p><p class=MsoNormal>echo "$command<br>";<o:p></o:p></p><p class=MsoNormal>$salida = shell_exec($command);<o:p></o:p></p><p class=MsoNormal>print_r($salida);<o:p></o:p></p><p class=MsoNormal>exit();<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This script generate a command to execute vía shell_exec (I did run it through Linux Shell also) which generate the next graphic.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As you can see, there are gaps in some situations.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Also I paste a key,value pair for every record used to graphic this picture.<o:p></o:p></p><p class=MsoNormal><span style='font-size:13.5pt;color:black'>UNIXTIMESTAMP: 1421469602 - VALUE: 2147483647<br>UNIXTIMESTAMP: 1421469901 - VALUE: 2147483647<br>UNIXTIMESTAMP: 1421470201 - VALUE: 163540881<br>UNIXTIMESTAMP: 1421470501 - VALUE: 518975306<br>UNIXTIMESTAMP: 1421470802 - VALUE: 857284793<br>UNIXTIMESTAMP: 1421471101 - VALUE: 1102831558<br>UNIXTIMESTAMP: 1421471401 - VALUE: 1386037303<br>UNIXTIMESTAMP: 1421471701 - VALUE: 1681176534<br>UNIXTIMESTAMP: 1421472002 - VALUE: 1952529044<br>UNIXTIMESTAMP: 1421472301 - VALUE: 2147483647<br>UNIXTIMESTAMP: 1421472601 - VALUE: 2147483647<br>UNIXTIMESTAMP: 1421472901 - VALUE: 2147483647<br>UNIXTIMESTAMP: 1421473201 - VALUE: 2847086150<br>UNIXTIMESTAMP: 1421473503 - VALUE: 3019834879<br>UNIXTIMESTAMP: 1421473801 - VALUE: 3154089687<br>UNIXTIMESTAMP: 1421474101 - VALUE: 3313917332<br>UNIXTIMESTAMP: 1421474401 - VALUE: 3443161047<br>UNIXTIMESTAMP: 1421474701 - VALUE: 3610549796<br>UNIXTIMESTAMP: 1421475001 - VALUE: 3775192078<br>UNIXTIMESTAMP: 1421475301 - VALUE: 3998976505<br>UNIXTIMESTAMP: 1421475605 - VALUE: 4142620562<br>UNIXTIMESTAMP: 1421475901 - VALUE: 4219497371<br>UNIXTIMESTAMP: 1421476201 - VALUE: 149205835<br>UNIXTIMESTAMP: 1421476501 - VALUE: 350459967<br>UNIXTIMESTAMP: 1421476801 - VALUE: 579857427<br>UNIXTIMESTAMP: 1421477101 - VALUE: 883366629<br>UNIXTIMESTAMP: 1421477401 - VALUE: 1150197757<br>UNIXTIMESTAMP: 1421477701 - VALUE: 1386002856<br>UNIXTIMESTAMP: 1421478001 - VALUE: 1597852870<br>UNIXTIMESTAMP: 1421478302 - VALUE: 1781209246<br>UNIXTIMESTAMP: 1421478601 - VALUE: 1944855343<br>UNIXTIMESTAMP: 1421478901 - VALUE: 2096223907<br>UNIXTIMESTAMP: 1421479201 - VALUE: 2246867064<br>UNIXTIMESTAMP: 1421479501 - VALUE: 2395748762<br>UNIXTIMESTAMP: 1421479801 - VALUE: 2546890705<br>UNIXTIMESTAMP: 1421480104 - VALUE: 2698891644<br>UNIXTIMESTAMP: 1421480401 - VALUE: 2892023127<br>UNIXTIMESTAMP: 1421480704 - VALUE: 3082356421<br>UNIXTIMESTAMP: 1421481004 - VALUE: 3288155090<br>UNIXTIMESTAMP: 1421481301 - VALUE: 3441384994<br>UNIXTIMESTAMP: 1421481601 - VALUE: 3597207322<br>UNIXTIMESTAMP: 1421481902 - VALUE: 3758453120<br>UNIXTIMESTAMP: 1421482201 - VALUE: 3919084229<br>UNIXTIMESTAMP: 1421482501 - VALUE: 4096616627<br>UNIXTIMESTAMP: 1421482801 - VALUE: 4257022849<br>UNIXTIMESTAMP: 1421483101 - VALUE: 140837180<br>UNIXTIMESTAMP: 1421483403 - VALUE: 319734182<br>UNIXTIMESTAMP: 1421483701 - VALUE: 473114575<br>UNIXTIMESTAMP: 1421484002 - VALUE: 632862515<br>UNIXTIMESTAMP: 1421484301 - VALUE: 796121296<br>UNIXTIMESTAMP: 1421484601 - VALUE: 964809387<br>UNIXTIMESTAMP: 1421484902 - VALUE: 1148885775<br>UNIXTIMESTAMP: 1421485201 - VALUE: 1340724450<br>UNIXTIMESTAMP: 1421485501 - VALUE: 1510426906<br>UNIXTIMESTAMP: 1421485801 - VALUE: 1672762026<br>UNIXTIMESTAMP: 1421486101 - VALUE: 1833660454<br>UNIXTIMESTAMP: 1421486401 - VALUE: 2000054024<br>UNIXTIMESTAMP: 1421486702 - VALUE: 2170478736<br>UNIXTIMESTAMP: 1421487001 - VALUE: 2348985619<br>UNIXTIMESTAMP: 1421487302 - VALUE: 2530266606<br>UNIXTIMESTAMP: 1421487601 - VALUE: 2707468520<br>UNIXTIMESTAMP: 1421487901 - VALUE: 2882867518<br>UNIXTIMESTAMP: 1421488202 - VALUE: 3058331663<br>UNIXTIMESTAMP: 1421488501 - VALUE: 3237064639<br>UNIXTIMESTAMP: 1421488801 - VALUE: 3424502252<br>UNIXTIMESTAMP: 1421489101 - VALUE: 3610244468<br>UNIXTIMESTAMP: 1421489401 - VALUE: 3793405766<br>UNIXTIMESTAMP: 1421489701 - VALUE: 3976739496<br>UNIXTIMESTAMP: 1421490001 - VALUE: 4157790682<br>UNIXTIMESTAMP: 1421490301 - VALUE: 56957366<br>UNIXTIMESTAMP: 1421490601 - VALUE: 281365154<br>UNIXTIMESTAMP: 1421490902 - VALUE: 541138427<br>UNIXTIMESTAMP: 1421491202 - VALUE: 775899755<br>UNIXTIMESTAMP: 1421491501 - VALUE: 969448849<br>UNIXTIMESTAMP: 1421491801 - VALUE: 1165840242<br>UNIXTIMESTAMP: 1421492101 - VALUE: 1346287570<br>UNIXTIMESTAMP: 1421492401 - VALUE: 1532634307<br>UNIXTIMESTAMP: 1421492701 - VALUE: 1726925850<br>UNIXTIMESTAMP: 1421493001 - VALUE: 1935266997<br>UNIXTIMESTAMP: 1421493301 - VALUE: 2132479236<br>UNIXTIMESTAMP: 1421493601 - VALUE: 2418598555<br>UNIXTIMESTAMP: 1421493901 - VALUE: 2668012842<br>UNIXTIMESTAMP: 1421494201 - VALUE: 2958853623<br>UNIXTIMESTAMP: 1421494501 - VALUE: 3265133479<br>UNIXTIMESTAMP: 1421494801 - VALUE: 3558062074<br>UNIXTIMESTAMP: 1421495102 - VALUE: 3829675920<br>UNIXTIMESTAMP: 1421495401 - VALUE: 4084555672<br>UNIXTIMESTAMP: 1421495701 - VALUE: 78633730<br>UNIXTIMESTAMP: 1421496001 - VALUE: 382331566<br>UNIXTIMESTAMP: 1421496301 - VALUE: 657710825<br>UNIXTIMESTAMP: 1421496601 - VALUE: 941660841<br>UNIXTIMESTAMP: 1421496901 - VALUE: 1213210320<br>UNIXTIMESTAMP: 1421497201 - VALUE: 1475879261<br>UNIXTIMESTAMP: 1421497501 - VALUE: 1743942697<br>UNIXTIMESTAMP: 1421497801 - VALUE: 2003987636<br>UNIXTIMESTAMP: 1421498102 - VALUE: 2289107091<br>UNIXTIMESTAMP: 1421498401 - VALUE: 2626095136<br>UNIXTIMESTAMP: 1421498701 - VALUE: 2941401863<br>UNIXTIMESTAMP: 1421499001 - VALUE: 3296357481<br>UNIXTIMESTAMP: 1421499301 - VALUE: 3680401747<br>UNIXTIMESTAMP: 1421499601 - VALUE: 15281329<br>UNIXTIMESTAMP: 1421499901 - VALUE: 1004388863<br>UNIXTIMESTAMP: 1421500201 - VALUE: 1974741676<br>UNIXTIMESTAMP: 1421500503 - VALUE: 2423377515<br>UNIXTIMESTAMP: 1421500801 - VALUE: 3232744005<br>UNIXTIMESTAMP: 1421501101 - VALUE: 4202117490<br>UNIXTIMESTAMP: 1421501401 - VALUE: 795603226<br>UNIXTIMESTAMP: 1421501701 - VALUE: 1119767570<br>UNIXTIMESTAMP: 1421502001 - VALUE: 1417586215<br>UNIXTIMESTAMP: 1421502301 - VALUE: 1750636875<br>UNIXTIMESTAMP: 1421502601 - VALUE: 2139728168<br>UNIXTIMESTAMP: 1421502901 - VALUE: 2470713359<br>UNIXTIMESTAMP: 1421503201 - VALUE: 2922428132<br>UNIXTIMESTAMP: 1421503502 - VALUE: 3335567528<br>UNIXTIMESTAMP: 1421503801 - VALUE: 3785892189<br>UNIXTIMESTAMP: 1421504101 - VALUE: 4228676311<br>UNIXTIMESTAMP: 1421504401 - VALUE: 331388945<br>UNIXTIMESTAMP: 1421504701 - VALUE: 764924219<br>UNIXTIMESTAMP: 1421505002 - VALUE: 1204256800<br>UNIXTIMESTAMP: 1421505301 - VALUE: 1717595824<br>UNIXTIMESTAMP: 1421505602 - VALUE: 2174414145<br>UNIXTIMESTAMP: 1421505901 - VALUE: 2634345504<br>UNIXTIMESTAMP: 1421506201 - VALUE: 3024961984<br>UNIXTIMESTAMP: 1421506501 - VALUE: 3418545235<br>UNIXTIMESTAMP: 1421506802 - VALUE: 3870011170<br>UNIXTIMESTAMP: 1421507101 - VALUE: 121419749<br>UNIXTIMESTAMP: 1421507401 - VALUE: 415119114<br>UNIXTIMESTAMP: 1421507701 - VALUE: 860254523<br>UNIXTIMESTAMP: 1421508001 - VALUE: 1253701591<br>UNIXTIMESTAMP: 1421508301 - VALUE: 1623451936<br>UNIXTIMESTAMP: 1421508601 - VALUE: 2099075694<br>UNIXTIMESTAMP: 1421508901 - VALUE: 2489394523<br>UNIXTIMESTAMP: 1421509201 - VALUE: 2773178955<br>UNIXTIMESTAMP: 1421509501 - VALUE: 3025765226<br>UNIXTIMESTAMP: 1421509802 - VALUE: 3169789154<br>UNIXTIMESTAMP: 1421510101 - VALUE: 3293893656<br>UNIXTIMESTAMP: 1421510401 - VALUE: 3501327040<br>UNIXTIMESTAMP: 1421510701 - VALUE: 3616569085<br>UNIXTIMESTAMP: 1421511001 - VALUE: 3763864086<br>UNIXTIMESTAMP: 1421511301 - VALUE: 3891109607<br>UNIXTIMESTAMP: 1421511601 - VALUE: 4059469680<br>UNIXTIMESTAMP: 1421511901 - VALUE: 4190154426<br>UNIXTIMESTAMP: 1421512201 - VALUE: 44752674<br>UNIXTIMESTAMP: 1421512501 - VALUE: 207039803<br>UNIXTIMESTAMP: 1421512801 - VALUE: 464080535<br>UNIXTIMESTAMP: 1421513101 - VALUE: 733679564<br>UNIXTIMESTAMP: 1421513401 - VALUE: 1138309604<br>UNIXTIMESTAMP: 1421513701 - VALUE: 1549205422<br>UNIXTIMESTAMP: 1421514001 - VALUE: 1877765262<br>UNIXTIMESTAMP: 1421514302 - VALUE: 2244994976<br>UNIXTIMESTAMP: 1421514601 - VALUE: 2528873289<br>UNIXTIMESTAMP: 1421514901 - VALUE: 2871665733<br>UNIXTIMESTAMP: 1421515201 - VALUE: 3196772650<br>UNIXTIMESTAMP: 1421515501 - VALUE: 3519659879<br>UNIXTIMESTAMP: 1421515801 - VALUE: 3803297056<br>UNIXTIMESTAMP: 1421516101 - VALUE: 4274859249<br>UNIXTIMESTAMP: 1421516401 - VALUE: 454189140<br>UNIXTIMESTAMP: 1421516701 - VALUE: 854902646<br>UNIXTIMESTAMP: 1421517001 - VALUE: 1268136408<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:13.5pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:black'>Could it be the difference of 1 to 3 seconds in the unixtimestamp field value which fill it with zeros in the graph?.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:black'>Thank in advance.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'>I hope you can help solve this.<o:p></o:p></span></p><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:black'>Guillermo Nardoni</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>