Can I retrieve session logs not registered in radacct?
Hello Are sessions recorded in the detail logs only after being recorded in the radacct and radpostauth table? 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. Att *César Murilo da Silva Júnior* *Téc. Oper. Monit. Computadores Help Desk | Redes e Segurança* *UNIPAM - Centro Universitário de Patos de Minas* *T1: 34 3823 0131 | T2: 34 3823 0120 | T3: 34 3823 0356 | C: 34 9 9220 5680* *cesarsj@unipam.edu.br <cesarsj@unipam.edu.br>* <https://www.unipam.edu.br/index.php/> <https://www.facebook.com/unipam> <https://www.instagram.com/unipamnet/?hl=pt> <https://twitter.com/UNIPAMNET> <https://www.youtube.com/user/CanalUNIPAM> <https://www.linkedin.com/school/centro-universit-rio-de-patos-de-minas---unipam/> <https://api.whatsapp.com/send?phone=5534999776622>
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.
participants (2)
-
Alan DeKok -
CESAR MURILO DA SILVA JUNIOR