> I wonder if this has been asked already or not.... How does one regularly > purge old records after a specified time from the sql database (radacct > table)? TIA
I use Postgres for the database and have a perl script which runs every few minutes which goes through radacct, finds any records which are no longer online (e.g. Acct-Status = STOP) and writes some info from radacct to a table called callhistory along with some other info (such as calculated usage charges). It then cleans up the radacct records after writing the callhistory. I do _not_ use indexes on radacct as there is such a high volume of update/delete that i found better performance by dropping all indexes.o regards, Jared. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
