Date: Mon, 20 Dec 1999 13:24:18 -0500 From: "Troy Settle" <st@i-plus.net> To: "Paul Stewart (Premier Networks)" <paul@premier-networks.com>, <freebsd-isp@FreeBSD.ORG> Subject: RE: Radius Log Tools? Message-ID: <FNEMIHIFMKFBMDBKFDPBIEGDCAAA.st@i-plus.net> In-Reply-To: <385E69C3.607C0E9C@premier-networks.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Paul, One word: SQL (ok, that's an acronym, but you get the picture) There's several patches availiable for cistron radiusd, including one I put together against 1.6.1-STABLE Once you've got your accounting into sql, it's a trivial matter to generate all kinds of reports for many different purposes: - Get users connection information for the day/week/month/year (by username or clid) - Allow users to see how much time they're online - See how many unique users log in per huntgroup - Get stats on connect/disconnect information (depends on your NAS, most don't seem to provide this information through radius) - Quickly determine if people are sharing accounts We've been doing it for a couple years now, and it's become a tool that our helpdesk and billing dept can not live without. You can see my ugly (but very functional) code at: ftp://ftp.i-plus.net/pub/radiusd-cistron-sql/ You can retrieve the 1.6.1 source from: ftp://ftp.freeradius.org/pub/radius/ G'luck, Troy ** -----Original Message----- ** From: owner-freebsd-isp@FreeBSD.ORG ** [mailto:owner-freebsd-isp@FreeBSD.ORG]On Behalf Of Paul Stewart (Premier ** Networks) ** Sent: Monday, December 20, 1999 12:39 PM ** To: freebsd-isp@FreeBSD.ORG ** Subject: Radius Log Tools? ** ** ** Does anyone have or know of any Cistron Radius log tools? ** ** We're looking for ways that a user could tell how much time they've used ** in the current month, last month etc. etc... ** ** Also, for billing purposes we could figure out their hourly usage each ** month when they logged in etc. etc..... ** ** Thanks, ** ** Paul ** ** ** To Unsubscribe: send mail to majordomo@FreeBSD.org ** with "unsubscribe freebsd-isp" in the body of the message ** To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?FNEMIHIFMKFBMDBKFDPBIEGDCAAA.st>