Many thanks for the responses, think SQL is the way forward and then query the database. Cheers Paulo -----Original Message----- From: Matthew Newton [mailto:mcn4@leicester.ac.uk] Sent: 25 September 2012 14:39 To: FreeRadius users mailing list Subject: Re: Reporting from logs Hi, On Tue, Sep 25, 2012 at 02:00:10PM +0100, Leal, Paulo wrote:
Just wondering what kind of reporting you have managed to get out from the FreeRadius logs, we wanted some user friendly reports with user numbers, success and failed attempts, what realms were used and numbers, even possibly bandwidth consumed per user. Daily, weekly and monthly reports.
We use hand-crafted linelog in carefully placed locations in the config so that we end up with a single line in a log file for each of auth accept, auth reject, acct start, acct update and acct stop. Each line is tab-separated and has fields in the same place so, for example, User-Name is always in column 7. We then have a nightly cron job that awk/greps stats out of this daily log file, as well as a custom web interface that lets us easily grep data out in real time. The best way to go is probably SQL, but this works well and is plenty fast enough for us without having the added complexities of a database running as well. Having said that, all logs are now rad-relayed to a central RADIUS server for the web site, so I could safely get a non-resilient database running there for querying. Just haven't had time or the need yet. Cheers, Matthew -- Matthew Newton, Ph.D. <mcn4@le.ac.uk> Systems Architect (UNIX and Networks), Network Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html