Acounting problem with SQL and detail files
a.cudbardb at freeradius.org
Wed Feb 12 17:11:15 CET 2014
On 12 Feb 2014, at 15:22, A.L.M.Buxey at lboro.ac.uk wrote:
>>> 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.org>
FreeRADIUS Development Team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 881 bytes
Desc: Message signed with OpenPGP using GPGMail
More information about the Freeradius-Users