Managing the RADIUS database

[Alan DeKok]

Steve Bertrand wrote:
> Again, I'm not a programmer, so the real developers will likely laugh.

  Why?  If it works... ship it. :)

> The radacct table in the RADIUS database grows at an enormously fast
> rate. Regardless of server resources, trying to search or perform
> actions on this table can be a daunting task.

  Yup.  In some cases, people are required to keep this data for months.

> Much work has gone into the classification system, and user-defined
> 'classes' can be defined dynamically via a standard configuration file.

  Nice!

> I'm looking for data (preferably dumped from mysqladmin, or entire
> tables), that I can throw at this software so I'm not continuously
> working with my own data. Raw data is preferable, but I can work with
> sanitized data. I'm also willing to work with an NDA for testing, and
> will even guarantee that data will be tested in a non-connected
> environment if specified.

  See "radperf" (http://networkradius.com).  It can generate fake login
traffic, including accounting packets.  It's a good tool for automated
testing.

> # Perl HACKERS WHO WILL FIX MY CODE
> 
> ...will receive SVN access to the repo, so long as they are willing to
> accept the fact that I'm not a programmer, and that I have my own
> bugzilla for bugs that I'll want to enter in manually. It will take me
> time to learn the development ropes.

  SVN?  Uh... I'm not as mean as Linus is about it.  But people are
abandoning SVN in droves to move to git.

  The benefit is that you don't have to "give people access".  Just put
a repository on github, let people fork it, and the pull in the changes.

  Or, if you think this is useful to a wider community, we can host it
on freeradius.org, and integrate it with the main releases.

> - relatively full documentation, OO interface etc

  Nice!  Release it early, and get feedback from the community.

> Since I have more than this on the go, I've applied to PAUSE for a new
> top-level namespace (ISP::), but haven't heard back yet. I am seriously
> dedicated to my ISP project, and as such, creating a project that
> fulfills the need of *SPs billing purposes is of utmost importance.

  Leverage the FreeRADIUS name. :)

  Aln DeKok.