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 TDM> sends interm accounting at the interval specified. However what I TDM> am looking specifically for non-PPPoE statically-assigned TDM> clients. There are several different types of scripts spread TDM> across the web ad nauseam but nothing that gives me what I�m TDM> looking for. I�ve also been investigating TrafficFlow but parsing TDM> that data could be a coders nightmare (or not, all I know is my TDM> eyes bleed 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 not TDM> interested in what websites they visited (ie TrafficFlow url) so TDM> 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 TDM> FreeRADIUS 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 TDM> to export usage counters to a SQL database? Trying not to TDM> re-invent the wheel, just modify it with 22�s on spinners or TDM> something fancy. Currently mapping that information through TDM> mangle rules, 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
