Can I delete "stopped" records from the FreeRadius table radacct directly with SQL?
Hi, I am new to this mailing list and I am very existing about to get in touch with you. We are using in one of our IoT services the FreeRadius server and we are happy with it. During the last year the tables radacct and radpostauth got really big. Unfortunately I cannot stop the radius server and do some cleanup. I have to do it during operation. My question is: Can I delete the records for which acctstoptime IS NOT NULL form the radacct table and can I delete records from radpostauth table without any problems to the current productive system? I scanned the network about it very much but unfortunately and I couldn’t find some hint about it ☹ Maybe you can help. Regards, Roland ____________________________________________________ DEUTSCHE TELEKOM IOT GMBH Squad IoT Creators Roland Baldin IoT Engineer Pascalstr. 11, 10587 Berlin, Germany +49 (160)70 33 606 roland.baldin@telekom.de<mailto:roland.baldin@telekom.de> https://iot.telekom.com/en https://iotcreators.com/en/ LIFE IS FOR SHARING. The compulsory statement can be found here: https://iot.telekom.com/en/compulsory-statement We care – Enabling more sustainability and participation. Further information on the Telekom Sustainability Initiative: https://wecare.telekom.com/en/label/
On 30/07/2021 11:28, Roland.Baldin@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
Hi Matthew, many many thanks for the response. Regards, Roland -----Ursprüngliche Nachricht----- Von: Freeradius-Users <freeradius-users-bounces+roland.baldin=telekom.de@lists.freeradius.org> Im Auftrag von Matthew Newton Gesendet: Freitag, 30. Juli 2021 12:39 An: freeradius-users@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@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
participants (2)
-
Matthew Newton -
Roland.Baldin@telekom.de