On Fri, 20 Sep 2002 11:40:53 -0400 (EDT)
Mike Hendrix wrote:
I have a question about moving accounting data out of a SQL database. We
are planning on running freeradius 0.7.1 on RH 7.3 using mySQL for
accounting. What do people do here to move the old accounting data out
of the radacct
I have a question about moving accounting data out of a SQL database. We
are planning on running freeradius 0.7.1 on RH 7.3 using mySQL for
accounting. What do people do here to move the old accounting data out of
the radacct table in such a way that you don't loose any new accounting
Some suggestions:
1) Setup the sql query so that it inserts into the radacct_MM table, or
something similar. You can do this by using 'radacct_%Y%m' for the table
name. One problem with this would be at the end of the month when a new
table is used, the accounting stop records won't
I wrote a script to import rad detail files into the SQL table. Kinda
rough around the edges, but it's a start.
You can get the script at:
http://users.2z.net/rpuhek/scripts_public/radius/detail2db.pl
--Rich
Mike Hendrix wrote:
I have a question about moving accounting data out of a SQL