AW: Can I delete "stopped" records from the FreeRadius table radacct directly with SQL?

[Roland.Baldin at telekom.de]

Hi Matthew,

many many thanks for the response.

Regards, Roland

-----Ursprüngliche Nachricht-----
Von: Freeradius-Users <freeradius-users-bounces+roland.baldin=telekom.de at lists.freeradius.org> Im Auftrag von Matthew Newton
Gesendet: Freitag, 30. Juli 2021 12:39
An: freeradius-users at lists.freeradius.org
Betreff: Re: Can I delete "stopped" records from the FreeRadius table radacct directly with SQL?

On 30/07/2021 11:28, Roland.Baldin at telekom.de wrote:
> My question is: Can I delete the records for which acctstoptime IS NOT 
> NULL form the radacct table

Sure. Usual practise would be to archive (or delete) records where acctstoptime IS NOT NULL and where it is over a day old, or so.


> and can I delete records from radpostauth table without any problems to the current productive system?

Yes, it's just a log.

-- 
Matthew
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html