Decreasing connection time (Session-Timeout)

[Graeme Lee]

micobros wrote:
> 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 :) 
>   
What db are you using?  If you are using postgresql, you can use this as 
an example:

http://lists.cistron.nl/pipermail/freeradius-users/2005-January/040297.html

It's not hard.  I actually have a stored procedure & trigger in the db 
which does exactly what you're after (for dialup) which I should be able 
to post tomorrow.

g


> 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
>>     
>
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>