Free RADIUS detail log parser

Kevin Kadow (kadokev@ripco.com)
Sun, 2 Feb 1997 01:14:45 -0600 (CST)

I just posted about my improved 'lineparser.pl' to portmaster-users. Basically
this program goes through the detail logs for STOP records, discards any
duplicated entries, and writes one line per call with the important
information- server name and port, username, duration, IP or host, and the
disconnect reason. I'll probably add the port-type and (for ISDN ports) the
calling/called number sometime soon.

It works with all versions of RADIUS and ComOS.

The results can then be passed through 'summarize.pl' which will produce
one line for each user, with totals and averages.

The scripts are at:
http://www.msg.net/utility/PM/

>I wouldnt move the details to the month... i would copy it... and use both.

I actually move the detail files each night at midnight, parse them, and
discard the raw data. This way I spend a couple of minutes each night parsing
the data, instead of an hour or more at the end of the month.

Kind of like balancing your checkbook :-)

> I still need a way to split the master detail file up into seperate months,
> which will not be confused by (as i said before) someone who logs on at the
> 30th of the month at 11pm and logs on at the 1st of the month.. say 2am.
>
> and also how are these times calculated for those calls which go across
> 2 'month' periods.

If you do it in Perl, it's not hard to write the code to handle these
cases- the problem is that many of these decisions are dependant on the
internal policy of the site, and need to be coded to fit your plans...