I'd be interested in this if you're willing to share. All options on the table right now until I can find one that will do the job of what we're looking for.
I did investigate this (oops I confused TrafficFlow with an actual URL, was actually referring to the Accounting) but I thought it might be problematic due to the limitations of what is displayed. Each of the counters appear to be tcp connection based a la NTop and 8192 (the limit) seems like a small number. When you have webpages that spawn anywhere from 10-15 TCP connections each (and each entry uses 100 bytes), it can start to add up quick especially if you have a high customer count pumping through the router. How do you gauge something like that to poll and maintain usage accuracy? If I am misinterpreting, please tell me :-) Also interested in Cameron's take on this issue as well. I can be hit up offlist for both at [email protected]. And I really appreciate the shares :-) Regards, -Tim -----Original Message----- From: Af [mailto:[email protected]] On Behalf Of Mark - Myakka Technologies Sent: Thursday, January 22, 2015 5:42 PM To: Timothy D. McNabb Subject: Re: [AFMUG] OT - MT usage stats Timothy, On the wireless side pre-radius I wrote some code that uses the IP accounting feature of MT. I've been working on and off of doing some internal usage monitoring on clients MT's to see what devices internally are using the bandwidth. I've tried a bunch of different things, but keep coming back to the IP Accounting. It is just easy to deal with. -Turn it on, set the buffer to the max (8k I think) -Write a PHP or PERL script to do a WGET or some other web page grab every few minutes. -Parse the data -Update SQL Table -- 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 ------ 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> � --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
