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/