<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 http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EstiloCorreo18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EstiloCorreo19
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.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 link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Dear List,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This is the 1st time I post here, so I hope I’ll be as clear as posible.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We are a WISP from Argentina and we are trying to get a statistic graph from every CPE installed in client location.<o:p></o:p></p><p class=MsoNormal>Every CPE is pushing information into a webserver running apache+php. The data colleted are store into mysql table.<o:p></o:p></p><p class=MsoNormal>To get data consistent, we use UNIXTIMESTAMP generate by php script with time() function. <o:p></o:p></p><p class=MsoNormal>The function time() is used to generate the rrd file minus 1 sec for the date of creation ($now = time() – 1).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We don’t really know why traffic graph generated by Mikrotik are TOTALLY different from ours. <o:p></o:p></p><p class=MsoNormal>Data store on rrd file are “perfect”, meaning correct.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As you can see in graphics, ath0 and eth0 are “mirror interfaces” being ath0 the Wireless interface and eth0 the one connected to client network. <o:p></o:p></p><p class=MsoNormal>Data collected by sripts are quite equals but inverted (rx -> tx and viceversa because of the clause above). Even though, graphics are not equals o “related”.<o:p></o:p></p><p class=MsoNormal>Traffic generate by our script are 1 minute average<o:p></o:p></p><p class=MsoNormal><a href="http://ctrlv.in/223602">http://ctrlv.in/223602</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Traffic generate by Mikrotik is (5 minutes average):<o:p></o:p></p><p class=MsoNormal><a href="http://ctrlv.in/223603">http://ctrlv.in/223603</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If you want to see our scripts those are in:<o:p></o:p></p><p class=MsoNormal>Script to update stats on every request from scripts running on cpe. Scripts running on cpe are cron on 60 secs. <span style='font-family:Wingdings'>à</span> <a href="http://intranet.ipred.com.ar/update_Stats.php?source=yes">http://intranet.ipred.com.ar/update_Stats.php?source=yes</a><o:p></o:p></p><p class=MsoNormal>Script to process records store on mysql and generate rrd file, if no exists, then update records into the rrd file and after that, generate graph. <span style='font-family:Wingdings'>à</span> <a href="http://intranet.ipred.com.ar/do_Stats.php?source=yes">http://intranet.ipred.com.ar/do_Stats.php?source=yes</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Could please help me to get this work?.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>