Ok, that worked but the $m had to be a %m
I had to use a table name of "2003_11" and use "%Y_%m" in the
acct_table1 and acct_table2 because mysql doesn't seem to like tables that
are just numbers. I had to add the "_" to get the mysql portion to work.
Thanks Alan!
Bill
----- Original Message -----
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 10:31 AM
Subject: Re: dynamic table name in sql.conf reflecting the current month
> "Bill" <[EMAIL PROTECTED]> wrote:
> > I'm using the sql.conf file with mysql. Using the default
installation
> > it uses a radius database with a table called radacct. I'm wanting my
> > accounting logs rotated each month in mysql. How can I change the name
of
> > the radacct table to something more dynamic that reflects the month and
year
> > (2003Nov)?
>
> See 'doc/variables.txt' Use one of the macro expansions for dates.
>
> acct_table1 = "%Y$m"
>
> may work. If not, simply change the references in sql.conf:
>
> ${acct_table1} -> to -> %Y$m
>
> That's why the configuration files are text, so they can be edited.
>
> Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
