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 �
