Steve Bertrand wrote:
I'm curious to know what you use to manage your RADIUS database, particularly the accounting tables.
"cron", and custom Perl 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.
That would make about 4 admin systems, I think. It would be good to consolidate them. We could then replace the un-maintained "dialup-admin" with a newer, and maintained version.
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 ;)
Yes. If it's useful, we'll add it to the main FreeRADIUS repository.
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?
Many, many, people use it. But a lot of people have "historical" solutions that they are used to, so they don't develop newer solutions. Alan DeKok.