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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
On Behalf Of Santiago Balaguer García
Sent: mardi 24 octobre 2006 9:54
To: [email protected]
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" <[EMAIL PROTECTED]>
Reply-To: FreeRadius users mailing list
<[email protected]>
To: "'FreeRadius users mailing list'"
<[email protected]>
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
