[rrd-users] 1 minute RRD + Mysql + php + UnixTimeStamp + headaches

[Guillermo Javier Nardoni - BUNAR SRL]

Dear List,

 

This is the 1st time I post here, so I hope I'll be as clear as posible.

 

 

We are a WISP from Argentina and we are trying to get a statistic graph from
every CPE installed in client location.

Every CPE is pushing information into a webserver running apache+php. The
data colleted are store into mysql table.

To get data consistent, we use UNIXTIMESTAMP generate by php script with
time() function. 

The function time() is used to generate the rrd file minus 1 sec for the
date of creation ($now = time() - 1).

 

We don't really know why traffic graph generated by Mikrotik are TOTALLY
different from ours. 

Data store on rrd file are "perfect", meaning correct.

 

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. 

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

Traffic generate by our script are 1 minute average

http://ctrlv.in/223602

 

 

Traffic generate by Mikrotik is (5 minutes average):

http://ctrlv.in/223603

 

 

If you want to see our scripts those are in:

Script to update stats on every request from scripts running on cpe. Scripts
running on cpe are cron on 60 secs. -->
http://intranet.ipred.com.ar/update_Stats.php?source=yes

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. --> http://intranet.ipred.com.ar/do_Stats.php?source=yes

 

 

Could please help me to get this work?.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.oetiker.ch/pipermail/rrd-users/attachments/20130809/9cf81ddb/attachment.htm