Decreasing connection time (Session-Timeout)

[micobros]

Using triggers is a good idea too... 

The problem is that I don't know how to make stored routines. I could learn,
but I need this little *demo* station to work for this afternoon :) 

For now, I'll simply make a little php script executed every 10 minutes to
check the radacct table. And subtract the time elapsed from the
Session-Timeout attribute... 


Cheers,
 
mico
 
"The only way to get rid of a temptation is to yield to it."
(Oscar Wilde)

> -----Original Message-----
> From: freeradius-users-bounces+micobros=gmail.com at lists.freeradius.org
> [mailto:freeradius-users-bounces+micobros=gmail.com at lists.freeradius.org]
> On Behalf Of Santiago Balaguer García
> Sent: mardi 24 octobre 2006 9:54
> To: freeradius-users at lists.freeradius.org
> Subject: RE: Decreasing connection time (Session-Timeout)
> 
>   The best way to update your DB with the new session-timeout value is to
> CREATE A TRIGGER in your database when a STOP request is sent by your NAS.
> In this STOP request you have all information you need. I supposed your
> hotspot has activated accounting option.
> 
>   The option of executing an external script when user finalizes not is a
> very good solution.
> With the solucion I exposed you have a sincronous DB data.
> 
> 
> >From: "micobros" <micobros at gmail.com>
> >Reply-To: FreeRadius users mailing list
> ><freeradius-users at lists.freeradius.org>
> >To: "'FreeRadius users mailing list'"
> ><freeradius-users at lists.freeradius.org>
> >Subject: RE: Decreasing connection time (Session-Timeout)
> >Date: Tue, 24 Oct 2006 09:24:33 +0200
> >
> >In SQLCounter documentation they say "This module NEVER does any database
> >INSERTs or UPDATEs."
> >
> >I can in fact grab the time elapsed and all kind of other information.
> But
> >my main problem is to update my database with the new time.
> >
> 
> _________________________________________________________________
> Descubre la descarga digital con MSN Music. Más de un millón de canciones.
> http://music.msn.es/
> 
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html