From owner-freebsd-questions Fri Nov 5 7:18:25 1999 Delivered-To: freebsd-questions@freebsd.org Received: from Samizdat.uucom.com (samizdat.uucom.com [198.202.217.54]) by hub.freebsd.org (Postfix) with ESMTP id BF59414CF3 for ; Fri, 5 Nov 1999 07:18:21 -0800 (PST) (envelope-from cshenton@uucom.com) Received: (from cshenton@localhost) by Samizdat.uucom.com (8.9.3/8.9.3) id KAA13956; Fri, 5 Nov 1999 10:17:04 -0500 (EST) To: "Ryan Troy" Cc: Subject: Re: Radius Check usage scripts References: User-Agent: SEMI/1.13.3 (Komaiko) FLIM/1.12.5 (Hirahata) Emacs/20.3 (i386-pc-solaris2.7) MULE/4.0 (HANANOEN) MIME-Version: 1.0 (generated by SEMI 1.13.3 - "Komaiko") Content-Type: text/plain; charset=US-ASCII From: Chris Shenton Date: 05 Nov 1999 10:17:04 -0500 In-Reply-To: "Ryan Troy"'s message of "Wed, 3 Nov 1999 12:31:59 -0700" Message-ID: Lines: 25 X-Mailer: Gnus v5.6.45/Emacs 20.3 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 3 Nov 1999 12:31:59 -0700, "Ryan Troy" said: Ryan> Does anyone know of a script that will parse the detail file so Ryan> users can check there time online? I wrote one a while back for something like this -- end-of-month accounting. It's perl: http://www.shenton.org/~chris/nasa-hq/dialup/radius/ I originally wrote for a Livingston dialup, then modified to handle Ascend detail files. You may have to hack it for your format. There are some other tools there, like a web-based user account maintainer. I haven't worked on it in over a year so I'm not prepared to provide much in the way of help. The problem is that parsing a detail file for any reasonably sized population takes too long, especially if you do it on the fly. I've been playing with parsing daily-rotated detail file and jamming the results into a MySQL database. This makes ad hoc queries fast and flexible; very cool. The Cistron RADIUS folks have patches to send detail records directly to an SQL database but I haven't gone that route yet. I probably will when its successor (FreeRADIUS) becomes stable. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message