Renato, But, if you do a select() for all opened sessions for %{User-Name} removing the first result it could be enough. ps: Sometimes the NAS don't send the Acct-Stop, than can't be good to use it as a parameter. Boa sorte, On Fri, Apr 12, 2019 at 9:47 AM Renato Sousa <rensousa@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) ?
Regards,
Renato L. Sousa - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html