New accounting database each month

Nicolas Baradakis nbk at
Wed Feb 1 11:16:55 CET 2006

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

More information about the Freeradius-Users mailing list