[Radiuscontext-discuss] Automation of monthly reports...

Mike Cisar mcisar@starmania.net
Thu, 2 May 2002 12:32:50 -0600


Just wondering if anybody might have any easy ways of automating monthly
reporting with RadiusContext.  

Currently we are set up so that our radius log file is automatically
rotated by freeradius each month (named detail-04 for April, detail-05
for May, etc).  Currently we have radiuscontext set up in a cron job to
run a cumulative report for the month once daily (into
/var/www/html/reports-04, reports-05, etc) with a SessionData file of
SessionData-04, -05, etc.  As it stands we have to manually change the
cron job at the start of each month to reflect the new month number in
the files, and of course since I'm not up at midnite to do this, we
always get a little bit of slush over in the reports.  This done with
the idea that at any point in time we can log in and take a peek at the
usage of any client for last month, april of last year, etc. 

What I'm wondering is if it would be easily possible to do something
similar to what freeradius has done in that it automatically (or at
least has the ability to do so when configured to) creates a new detail
file the minute the month rolls over...  or would it be easier for me to
just write a wrapper script around the calls to radiuscontext to
dynamically pass the appropriate directories, session files and detail
file names that way.

Cheers,
>>>>> Mike <<<<< 

P.S.  Also, any thoughts as to the best way of being able to send a
report of their usage for a given time period to a customer?