Use of buffered-sql for logging auth data to db

Alex Sharaz alex.sharaz at york.ac.uk
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

A

On 17 October 2016 at 11:33, Alex Sharaz <alex.sharaz at york.ac.uk> 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 leicester.ac.uk> wrote:
>
>> On Mon, Oct 17, 2016 at 11:10:39AM +0100, Alex Sharaz wrote:
>> > >It renames the file to "detail.work" 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. detail.work 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 leicester.ac.uk>
>>
>> Systems Specialist, Infrastructure Services,
>> I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
>>
>> For IT help contact helpdesk extn. 2253, <ithelp at le.ac.uk>
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list
>> /users.html
>>
>
>


More information about the Freeradius-Users mailing list