Just an idea while messing around with duplicate accountings in mysql: Wouldn't it be more "logical" to change the insert/update-commands in sql.conf to log the real start&stop-time of the session with regarding start/stop-delay instead of the packet-timestamp %S ? Because otherwise any query against the accounting-data has to calculate (AcctStartTime-AcctStartDelay) As LoginTime and AcctStopTime-AcctStopDelay IMHO it's much more likely to query login/logout-times than how long the packet took to reach the database (which is still possible with AcctStart/StopDelay)
I can make/change the queries and post them, just wanted to poll some opinions or maybe I've overlooked something this change might break up with.. Michael - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
