Unfortunately not. :( However a couple other technicians from the office will be there for the festivities. Perhaps I'll have them seek you out specifically :)
-Tim -----Original Message----- From: Af [mailto:[email protected]] On Behalf Of Mark - Myakka Technologies Sent: Saturday, January 24, 2015 6:28 PM To: Timothy D. McNabb Subject: Re: [AFMUG] OT - MT usage stats Timothy, Are you going to AF? -- 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 options TDM> on the table right now until I can find one that will do the job of TDM> what we're looking for. TDM> I did investigate this (oops I confused TrafficFlow with an actual TDM> URL, was actually referring to the Accounting) but I thought it TDM> might be problematic due to the limitations of what is displayed. TDM> Each of the counters appear to be tcp connection based a la NTop TDM> and 8192 (the limit) seems like a small number. When you have TDM> webpages that spawn anywhere from 10-15 TCP connections each (and TDM> each entry uses 100 bytes), it can start to add up quick especially TDM> if you have a high customer count pumping through the router. How TDM> do you gauge something like that to poll and maintain usage TDM> accuracy? If I am misinterpreting, please tell me :-) TDM> Also interested in Cameron's take on this issue as well. I can be TDM> 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 TDM> 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 the IP TDM> accounting feature of MT. I've been working on and off of doing TDM> some internal usage monitoring on clients MT's to see what devices TDM> internally are using the bandwidth. I've tried a bunch of TDM> 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=10 TDM> 30009&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. TDM>> I�ve also been investigating TrafficFlow but parsing that data TDM>> could be a coders nightmare (or not, all I know is my eyes bleed TDM>> looking at it). TDM>> � TDM>> Butch � looking to catalog upload and download stats per TDM>> customer IP (non-PPPoE). Passthroughs work as planned but of TDM>> course you have two fields (Src Address and Dst Address). I�m TDM>> not interested in what websites they visited (ie TrafficFlow url) TDM>> so much as the amount of data used. If we can get Up/Down then of TDM>> course we can 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
