Radius Log file analysis

Skeeve Stevens (skeeve@skeeve.net)
Sun, 2 Feb 1997 10:33:45 +1100 (EST)

-----BEGIN PGP SIGNED MESSAGE-----

Greetings all,

I have a client who wants to be able to look up the hours that each
dialup user used each month.... not an unreasonable request ;)

He also wants users to be able to go to a webpage and be able to see
how many hours they have used so far for the current month.... also not an
unreasonable request.

I am not sure how to do the following:

o scan the logfile for one users transactions for a single 'month'
o split the logfile into seperate months
o also what would happen if a record goes over a 2 month
period? ie they log on at 11pm on the 30th, log off next month

The interface for users to lookup their own times is easy.... the cgi to count
the number of ours for the current month, maybe also previous months... it would
be good to let them choose.... also an overview of how much every month since
theyve joined...

Does anyone have any scripts, perl or C or anything which can do any or some
of the above? I would be most appreciative... thanx

---------------------------------------------------------------------
| Skeeve Stevens - MyInternet personal.url: http://www.skeeve.net/ |
| email://skeeve@skeeve.net/ work.url: http://www.myinternet.net/ |
| phone://612.9869.3334/ mobile://0414.SKEEVE/ [753-383] |
---------------------------------------------------------------------
| Join the Internet Society of Australia - http://www.isoc-au.org.au/ |
| Member of the Communications Taskforce of the Domain Name Authority |
---------------------------------------------------------------------

-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

iQEVAgUBMvPS1IfSc39gYMGJAQHuvgf/fqZQZMVgJEpLDEjQ5kdFSn2GZAB/CsUD
e7NlCw01LI0OftZSzlc4RCRYasyfzFUl0OddzgnpKeS4Dio3ArK7pD3aAzamp04f
hvDY/MOHiCLXtxHUW48PevBJvNY7yenIwt43WJCDB3bSBJ6xMyeCseCmJ2hyyIoQ
/rxwZuCnI6LtR+OL0ThdiV0OMcietfIjYhZ+dkWTm7TKdBVVtX+7F4DHCtsVxIqu
IItibKQytUhv4jhCqDX6z54fN96jr2WLpwgc/pzi7VtVSKOV91KtMnoU4rs+Z+zr
yXJiOIJTlP6kPNtAQTIl0Pp5+RvqgY0UQFvbCi3AaU151WCLxqqHfQ==
=q+sN
-----END PGP SIGNATURE-----