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@lists.freeradius.org [mailto:freeradius-users-bounces+micobros=gmail.com@lists.freeradius.org] On Behalf Of Santiago Balaguer García Sent: mardi 24 octobre 2006 9:54 To: freeradius-users@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@gmail.com> Reply-To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> To: "'FreeRadius users mailing list'" <freeradius-users@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