Managing the RADIUS database

Steve Bertrand steve at ibctech.ca
Wed Dec 16 01:04:53 CET 2009


Hi all,

I'm curious to know what you use to manage your RADIUS database,
particularly the accounting tables.

For quite some time, I was using severely hacked versions of the
dialup_admin scripts.

Since then, I've written (ie. been writing) an ISP mgmt/accounting
system that relies very heavily on the RADIUS accounting information for
billing and statistics, but only after the data has been aggregated.

During this project, I've also written a basic object-oriented RADIUS
module that now houses the aggregation functionality, including being
able to go back in time to re-aggregate and re-archive.

Because I need to make some functional changes to it, I thought I'd ask
here if others would be interested in such a Perl module (and its
scripts), and if so, I'll extend it with further functionality after
updating the code with the stuff I just didn't know then  ;)

Currently, it uses plain DBI and only supports MySQL, but I'm going to
incorporate much from my other work whereby DBIx::Class is used (to more
easily support multiple dbs), expand on the config file, the installer
and the documentation.

Is using RADIUS accounting stats for billing/logging even done anymore?

Steve







More information about the Freeradius-Users mailing list