On Jan 19, 2020, at 8:26 AM, CESAR MURILO DA SILVA JUNIOR <cesarsj@unipam.edu.br> wrote:
Are sessions recorded in the detail logs only after being recorded in the radacct and radpostauth table?
They're recorded in the order they occur in the config files: detail sql "detail" runs before "sql".
I caused a lock on these tables and my boss asked me to retrieve the start and end times of the session by details, but there are only the records from before the transaction that caused the table locks.
It's difficult to say what's going on with that little information. If the SQL database is locked, then the "sql" module will be unable to write records to it. And then FreeRADIUS may end up locking, or dropping packets. Solution: don't take the SQL database down. Alan DeKok.