23 Nov
2019
23 Nov
'19
6:06 a.m.
thanks Alan Rgds Alex Sent from my iPhone > On 22 Nov 2019, at 19:50, Alan Buxey <alan.buxey@gmail.com> wrote: > > Hi > > When I've had this its because the detail file was not written to correctly > when service killed or server shutdown less gracefully than it should have > been. > > A quick session with vi and the detail.work file will find the culprit > entry and then all will be well > > alan > >> On Thu, 21 Nov 2019, 15:57 Alex Sharaz via Freeradius-Users, < >> freeradius-users@lists.freeradius.org> wrote: >> >> Hi, >> >> I've just upgraded one of my servers to 3.0.2o and have just noticed the >> following radius.log messages, although I'm fairly sure it's got nothing to >> do with the version release. >> >> My FR setup uses buffered-sql to offload sql writes via the details file. >> >> This config works fine on all my other servers ( puppet managed config) but >> on this one I've noticed >> >> >> 1). I see the following messages in the log >> >> Thu Nov 21 15:24:55 2019 : WARNING: (86473) WARNING: Module rlm_sql became >> unblocked\ >> >> >> Thu Nov 21 15:25:53 2019 : Error: Unresponsive child for request 87765, in >> component accounting module sql >> >> >> 2). the buffered-sql process copies contents of file detail into >> detail.work leaving the source to capture subsequent packets.oes >> >> >> An ls -lt shows >> >> -rw------- 1 freerad freerad 31359093 Nov 21 15:51 detail >> -rw------- 1 freerad freerad 101566485 Nov 21 15:51 detail-filebeat >> -rw------- 1 freerad freerad 63282 Nov 21 14:22 detail.work >> -rw------- 1 freerad freerad 211324742 Nov 21 06:24 detail-filebeat.1 >> >> So detail.work hasn't moved since 14:22 >> >> I'm guessing there's something in thre detail.work file causing the sql to >> fail. >> >> >> How can I debug the buffered-sql server to check this out without >> generating 3,000,000 logs for the rest of the server ? >> >> >> Rgds >> >> Alex >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html