Radacct session delete

[Matthew Newton]

On 24/04/2021 21:01, mohamed almeshal wrote:
> my question is what is the measures and precaution for deleting sessions from radacct .

Use a cron job or similar to tidy entries where acctstoptime is not null 
(i.e. an Accounting-Stop has been received) as they are finished sessions.

You can also remove sessions where acctupdatetime is older than a few 
multiplications of your acct-interval (e.g. maybe anything over a day 
old), as they are sessions where you've probably missed the Stop.

If the NAS is regularly not sending stops or updates then you need to 
fix that.

> it's seems to be dealing with deletion of the session may cause some issue or may not ?

Not really. The standard SQL queries should create a new session on the 
first Interim-Update if the start never arrived (albeit missing some 
information). It may matter if you are querying the data for other 
reasons, such as simultaneous-use or billing.

-- 
Matthew