(still) running FreeRADIUS Version 1.0.0-pre0 (Debian-package from cvs20040421) with accounting to mysql 3.23.49.
Now while testing/checking accounting data validity I came over another curious thing ;) If no Stop record is ever received/gets lost or whatever, the entry remains with AcctStopTime = '' in the radacct-table - ok so far. What I look for now is to somehow "close" (rather than delete) these sesssion when either some time has passed since the last update and/or a new login happens. I think of using the last AcctSessionTime and insert the AcctStoptime based on this which would be quite safe if I haven't receved any acct-update for let's say 1-2h (checkrad is no option anyway for me because to most NASes I have no access) Is there a "best-practice" way somewhere out here for doing this ? Whats about "deletestalesessions = yes" in sql.conf ? It seems to be prepared to do something like this but I found nothing further in the sources (maybe simply not yet implemented)? I'm aware that this can be done by a regular SQL-query - that's also what I'll look at if there's no smoother way.. Michael - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
