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: [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
