Radius stale sessions

[Alan DeKok]

On Apr 12, 2019, at 2:46 PM, Renato Sousa <rensousa at gmail.com> wrote:
> 
> Hello everyone,
> 
> I am fine-tuning the radius accountig sql information and noticed that
> there are multiple stale sessions.
> I would like to use a script in cron to delete these sessions but I have a
> question.
> 
> How should I select a session as stale? Time difference (acctstarttime and
> now()) ? Other records with the same mac-address and open sessions
> (acctstoptime is null) ?

  Find all open sessions for a user, and then delete everything but the first session.

  Alan DeKok.