FreeRADIUS-Database version 0.0.2


To install this module type the following:

   perl Makefile.PL     
   # manual intervention is required during this step to
   # provide the user the ability to specify alternate
   # directory information
   make test
   make install

   # if you want to install the utilities

   make scripts 


- This distribution comes with a few management scripts that automate
radacct grouping and aggregation tasks that aid in both database
maintenance and UBB-type tasks

- The configuration file will be installed into the directory you specified 
during 'perl Makefile.PL' stage, or /usr/local/etc by default.

You will need to rename the configuration file from freeradius_database.conf-dist 
to freeradius_database.conf, and then set the config variables to suit your needs.

The configuration file has its own documentation. See

   perldoc FreeRADIUS::freeradius_database.conf 

- Currently, only MySQL has been used in production. The tests use
a dedicated SQLite database.


The daily and monthly aggregation routines require their own
database tables, currently within the actual RADIUS database, and
are for MySQL only.

The schema files are located in src/schema. To implement:

   mysql -u user -p [-h host] radius_db < src/schema/aggregate_daily.sql
   mysql -u user -p [-h host] radius_db < src/schema/aggregate_monthly.sql

... you'd be well advised to make a backup of your RADIUS database first.



There are a few accompanying scripts with this module so you can
get up and running as soon as possible.

Refer to the documentation of these scripts to get a full
understanding of their purpose and usage:

   perldoc aggregate_daily
   perldoc aggregate_monthly
   perldoc update_nas_ip_address
   perldoc archive_radacct

aggregate_daily, aggregate_monthly, and archive_radacct are
designed to be run from cron.

aggregate_daily should be run after midnight, with aggregate_monthly
following the completion of the daily script. It may be prudent
to chain the commands into a single cron entry to ensure
that daily completes prior to the monthly script running.  


See the Makefile.PL file.


Copyright (C) 2012 by Steve Bertrand <>


This library is free software; you can redistribute it and/or modify
it under the same terms as Perl itself, either Perl version 5.8.9 or,
at your option, any later version of Perl 5 you may have available.