Timothy, I was polling every 5-7 minutes. Also, I was doing this at each mikrotik at each tower and not trying to do it at an edge router.
At the end of the day I've convinced myself if I miss a few packets the earth would not end. Never had a customer call me up to tell me they thought they were use more than I was reporting. -- Best regards, Mark mailto:[email protected] Myakka Technologies, Inc. www.MyakkaTech.com Proud Sponsor of the Myakka City Relay For Life http://www.RelayForLife.org/MyakkaCityFL Please Donate at http://main.acsevents.org/site/TR/RelayForLife/RFLFY12FL?team_id=1030009&pg=team&fr_id=37555 ------ Friday, January 23, 2015, 2:51:07 PM, you wrote: TDM> I'd be interested in this if you're willing to share. All TDM> options on the table right now until I can find one that will do TDM> the job of what we're looking for. TDM> I did investigate this (oops I confused TrafficFlow with an TDM> actual URL, was actually referring to the Accounting) but I TDM> thought it might be problematic due to the limitations of what is TDM> displayed. Each of the counters appear to be tcp connection based TDM> a la NTop and 8192 (the limit) seems like a small number. When TDM> you have webpages that spawn anywhere from 10-15 TCP connections TDM> each (and each entry uses 100 bytes), it can start to add up TDM> quick especially if you have a high customer count pumping TDM> through the router. How do you gauge something like that to poll TDM> and maintain usage accuracy? If I am misinterpreting, please tell TDM> me :-) TDM> Also interested in Cameron's take on this issue as well. I TDM> can be hit up offlist for both at [email protected]. And I really TDM> appreciate the shares :-) TDM> Regards, TDM> -Tim TDM> -----Original Message----- TDM> From: Af [mailto:[email protected]] On Behalf Of Mark - Myakka Technologies TDM> Sent: Thursday, January 22, 2015 5:42 PM TDM> To: Timothy D. McNabb TDM> Subject: Re: [AFMUG] OT - MT usage stats TDM> Timothy, TDM> On the wireless side pre-radius I wrote some code that uses TDM> the IP accounting feature of MT. I've been working on and off of TDM> doing some internal usage monitoring on clients MT's to see what TDM> devices internally are using the bandwidth. I've tried a bunch TDM> of different things, but keep coming back to the IP Accounting. TDM> It is just easy to deal with. TDM> -Turn it on, set the buffer to the max (8k I think) TDM> -Write a PHP or PERL script to do a WGET or some other web page grab every few minutes. TDM> -Parse the data TDM> -Update SQL Table TDM> -- TDM> Best regards, TDM> Mark mailto:[email protected] TDM> Myakka Technologies, Inc. TDM> www.MyakkaTech.com TDM> Proud Sponsor of the Myakka City Relay For Life TDM> http://www.RelayForLife.org/MyakkaCityFL TDM> Please Donate at TDM> http://main.acsevents.org/site/TR/RelayForLife/RFLFY12FL?team_id=1030009&pg=team&fr_id=37555 TDM> ------ TDM> Thursday, January 22, 2015, 7:00:52 PM, you wrote: TDM>> Ya we�re doing that now on PPPoE clients. The PPPoE server sends TDM>> interm accounting at the interval specified. However what I am TDM>> looking specifically for non-PPPoE statically-assigned clients. TDM>> There are several different types of scripts spread across the web TDM>> ad nauseam but nothing that gives me what I�m looking for. I�ve TDM>> also been investigating TrafficFlow but parsing that data could be TDM>> a coders nightmare (or not, all I know is my eyes bleed looking at TDM>> it). TDM>> � TDM>> Butch � looking to catalog upload and download stats per customer TDM>> IP (non-PPPoE). Passthroughs work as planned but of course you have TDM>> two fields (Src Address and Dst Address). I�m not interested in TDM>> what websites they visited (ie TrafficFlow url) so much as the TDM>> amount of data used. If we can get Up/Down then of course we can TDM>> create a cumulative field as well. TDM>> � TDM>> -Tim TDM>> � TDM>> From: Af [mailto:[email protected]] On Behalf Of Adam Moffett TDM>> Sent: Thursday, January 22, 2015 3:51 PM TDM>> To: [email protected] TDM>> Subject: Re: [AFMUG] OT - MT usage stats TDM>> � TDM>> � TDM>> I don't exactly have an answer.....but maybe a direction to TDM>> look.� MT has RADIUS support for DHCP.� The intent is to TDM>> authenticate based on the DHCP client's MAC address.....does that TDM>> support RADIUS accounting?� If so then pair that with FreeRADIUS TDM>> and I think you can get usage stats into SQL that way. TDM>> Was wondering if anyone had come up with a nifty-keeno way to TDM>> export usage counters to a SQL database? Trying not to re-invent TDM>> the wheel, just modify it with 22�s on spinners or something TDM>> fancy. Currently mapping that information through mangle rules, TDM>> however Passthroughs are an option as well. TDM>> � TDM>> -Tim TDM>> � TDM>> � TDM> --- TDM> This email is free from viruses and malware because avast! TDM> Antivirus protection is active. TDM> http://www.avast.com --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
