New accounting database each month

Thor Spruyt thor.spruyt at telenet.be
Fri Feb 3 00:03:35 CET 2006


Nicolas Baradakis wrote:
>> Is there a way to configure freeradius to create a new MySQL
>> accounting database each month? (in example: jan_06_radacct,
>> feb_06_radacct, etc). The database should be created the first
>> minute of the first day of each month. This is required for
>> backup/database size.

Run a script each month that takes all records from the month before, do
whatever with them and remove them from the database.
I thought databases are especially friendly for stuff like that...

--
Groeten, Regards, Salutations,

Thor Spruyt
M: +32 (0)475 67 22 65
E: thor.spruyt at telenet.be
W: www.thor-spruyt.com

www.salesguide.be
www.telenethotspot.be




More information about the Freeradius-Users mailing list