I have a perl script combined with a mysql database that uses the MT api to get the usage data and store in a DB. It checks for resets as well so it doesn't "set the clock back" if the power goes out or you upgrade your router. You could put it on a cron job and run it as often as you like.
Cameron On Thu, Jan 22, 2015 at 6:00 PM, Timothy D. McNabb <[email protected]> wrote: > Ya we’re doing that now on PPPoE clients. The PPPoE server sends interm > accounting at the interval specified. However what I am looking > specifically for non-PPPoE statically-assigned clients. There are several > different types of scripts spread across the web ad nauseam but nothing > that gives me what I’m looking for. I’ve also been investigating > TrafficFlow but parsing that data could be a coders nightmare (or not, all > I know is my eyes bleed looking at it). > > > > Butch – looking to catalog upload and download stats per customer IP > (non-PPPoE). Passthroughs work as planned but of course you have two fields > (Src Address and Dst Address). I’m not interested in what websites they > visited (ie TrafficFlow url) so much as the amount of data used. If we can > get Up/Down then of course we can create a cumulative field as well. > > > > -Tim > > > > *From:* Af [mailto:[email protected]] *On Behalf Of *Adam Moffett > *Sent:* Thursday, January 22, 2015 3:51 PM > *To:* [email protected] > *Subject:* Re: [AFMUG] OT - MT usage stats > > > > > > I don't exactly have an answer.....but maybe a direction to look.� MT > has RADIUS support for DHCP.� The intent is to authenticate based on the > DHCP client's MAC address.....does that support RADIUS accounting?� If so > then pair that with FreeRADIUS and I think you can get usage stats into SQL > that way. > > Was wondering if anyone had come up with a nifty-keeno way to export usage > counters to a SQL database? Trying not to re-invent the wheel, just modify > it with 22�s on spinners or something fancy. Currently mapping that > information through mangle rules, however Passthroughs are an option as > well. > > � > > -Tim > > � > > >
