sql - best practices

[Marcin]

2015-04-09 20:12 GMT+02:00 Arran Cudbard-Bell <a.cudbardb at freeradius.org>:

>
> > On 9 Apr 2015, at 13:13, Marcin <marcin at nicram.net> wrote:
> >
> > That, what is proper way? I'm not profesionalist so please understand me.
>
> Set the interim update period to something like 15 minutes.
>
>
> https://github.com/FreeRADIUS/freeradius-server/blob/v3.1.x/raddb/mods-config/sql/main/mysql/schema.sql#L28
>
> Write a cron job to close out sessions, either using radclient to fake
> stop messages, or just by setting acctstoptime to NOW()) where (NOW() -
> <interim period>) > acctupdatetime.
>
>

that is what i do now on other remote location.



> Run it every 5 minutes.
>
> Don't use the delete_stale_sessions option, it likely doesn't do what you
> want.
>
>
>
Ok, if proffesionalists say that using database is the most proper way to
deal with it, that i won't be discuss.

Thanks for help



-- 
Pozdrawiam
Marcin / nicraM