Acounting problem with SQL and detail files

Arran Cudbard-Bell a.cudbardb at
Wed Feb 12 17:11:15 CET 2014

On 12 Feb 2014, at 15:22, A.L.M.Buxey at wrote:

> Hi,
>>> I am looking for redundancy, if SQL does not work I can count on detail files. If the SQL problem blocks the whole FreeRADIUS server I think there is a problem of design (might be resolved in later version?).
> use buffered-sql instead of plain SQL - then it will store to a file and SQL doesnt 
> do anything inline.

Yes, though it's a mite slow, so if you have even moderate numbers 
of accounting requests it gets overloaded rather quickly.

It really needs to be fixed, I took a look at it but after reading up on 
POSIX locking... Wow that's one truly awfully, completely broken set of 

There is essentially, no way to do byte range locks on a file, and have
the lock states reflected internally within the process.

There's a nice article about it here:

Arran Cudbard-Bell <a.cudbardb at>
FreeRADIUS Development Team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <>

More information about the Freeradius-Users mailing list