New accounting database each month
Hi, 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. Thanks! Edo
You could create an external script. Probably will be easier than modifying the FreeRADIUS source. Keep radacct for the current table and create a script that copies that DB over to say "jan06_radacct". The script could be easily run from Cron. Eduardo Bejar wrote:
Hi,
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.
Thanks!
Edo
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Richard Marriner II Maingear.Net Sr. Network Consultant I.T. Consulting richard@maingear.net www.maingear.net
Eduardo Bejar 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.
It seems difficult to have different databases, but it's easy to have different tables each month. You could try acct_table = "%m_%Y_radacct" in raddb/sql.conf. -- Nicolas Baradakis
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@telenet.be W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be
participants (4)
-
Eduardo Bejar -
Nicolas Baradakis -
Rich Marriner -
Thor Spruyt