RFC 2866 - Accounting ON / Accounting OFF packets

Phil Mayers p.mayers at imperial.ac.uk
Fri Mar 14 12:29:41 CET 2008


A.L.M.Buxey at lboro.ac.uk wrote:
> Hi,
> 
>> Quite. I believe you'll probably run into problems with MyISAM if you've 
>> got a loaded RADIUS server. It's taken around 6 months for serious issues 
>> to occur. We switched over to some new more 'chatty' firmware on our access 
>> points, and that seemed to push it over the edge. Database equivalent of 
>> gridlock, all connections used, authentications starting to fail, not 
>> pretty.
>>
>> Disabled SQL based Accounting for now as the data is used more for show 
>> anyway. Building InnoDB database based around the FR2 schemas.
> 
> we hit a similar wall - and decided to stop doing 'live live live!'
> accounting - use the SQL_LOG and sqlrelay tool to insert the
> accounting updates into the DB as quickly as they can behind the

I can second this. It's an EXCELLENT solution.

It also means your radius servers keep going (and catch up) if the 
database goes away.

We also run a local read-only SQL server on each radius server to do 
group lookups etc.



More information about the Freeradius-Users mailing list