Use of buffered-sql for logging auth data to db

Alex Sharaz alex.sharaz at
Mon Oct 17 17:46:01 CEST 2016

Question - can you use the FR 3.0.x control interface to get some form of
status of any db pools being used, or even any errors generated when
writing to a DB ?

Failing that, guess I could grep radius.log looking for specific text
strings relating to
 Error: rlm_sql (sql): Last connection attempt failed, waiting 30 seconds
before retrying


On 17 October 2016 at 11:33, Alex Sharaz <alex.sharaz at> wrote:

> o.k. think things have caught up with themselves, detail file now doing
> what I'd expect
> A
> On 17 October 2016 at 11:16, Matthew Newton <mcn4 at> wrote:
>> On Mon, Oct 17, 2016 at 11:10:39AM +0100, Alex Sharaz wrote:
>> > >It renames the file to "" before reading so that the
>> > >detail writer doesn't add to the end of the file while it's being
>> > >processed. So you'll occasionally see both files.
>> >
>> > Ermmm always seeing both files. timestamp changing, file
>> > never disappears or changes size.
>> Maybe behaviour changed from v2 to v3, here (these servers still
>> on v2 :-( ) the .work file appears and vanishes every second or
>> two.
>> But sounds like it's doing the right thing. Is it actually broken,
>> or are the records making their way into the database?
>> If not, try adding e.g. a new "detail" instance in the
>> buffered-sql virtual server to see what it's reading, or use a
>> debug_request and run in debug mode to make sure it's picking up
>> the data.
>> Matthew
>> --
>> Matthew Newton, Ph.D. <mcn4 at>
>> Systems Specialist, Infrastructure Services,
>> I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
>> For IT help contact helpdesk extn. 2253, <ithelp at>
>> -
>> List info/subscribe/unsubscribe? See
>> /users.html

More information about the Freeradius-Users mailing list