Mike, I haven't really looked into this, as I've only run the mysql accounting for a couple months, and we need the data much longer to reconcile with some of our providers. I'm planning on doing it by hand with a simple sql statment based on AcctStartTime or AcctStopTime for the time being. I have seen reference to dialup_admin being able to handle this as well. I've not yet had time to investigate dialup_admin though.
I'm sure I've missed alot of the DB nuances, as I'm an SA, not a DBA. But it gets the job done. :) dave On Thu, 21 Nov 2002 10:13:39 -0800 "Mike Denka" <[EMAIL PROTECTED]> wrote: > > > Thanks to Dave and Kostas for the feedback. Sounds > great. So now I'm > wondering how you age the accounting data if it all goes > to a mysql db. > You would certainly not want to keep accounting data > indefinitely. So > what process do you guys use to throw out the old stuff > to make way for > the new? (Forgive me if this is obvious in the context > of databases - > I'm really not a very literate database guy). > > Thanks again, > > Mike > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
