Hello Fabrizio - On Fri, 12 May 2000, [EMAIL PROTECTED] wrote: > > I'm using a national roaming service with a proxy radius that forwards me > all @domain.it requests. > Sometimes their access-servers or radius, don't send me the STOP accounting > record, so i often have dead sessions on my radonline db. > When the user tries to authenticate again, it reaches his MaxSession of 1, > and i've no snmp access on the access-servers, so i've modified my > radonline db adding a "calling_station_id", and now I need a PreAuthHook > that deletes this kind of dead sessions only if calling_station_id on the > radonline db is the same of the radius auth request. > I'm using a mysql db... someone has a module like this because i'm not so > skilled with perl and dbi ? > I would suggest that you simply specify a "DeleteQuery" to your SessionDatabase SQL clause that matches on the calling_station_id to remove the dead session. The DeleteQuery is called every time an Access-Accept is received, expressly for this purpose. Have a look at section 6.6.4 in the Radiator 2.15 reference manual. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.