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

[Roland.Baldin at telekom.de]

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 at telekom.de<mailto:roland.baldin at 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/