On Wed, 2006-05-04 at 22:06 +0300, Mordor Networks wrote: > Date: Wed, 05 Apr 2006 11:09:58 -0600 > From: Guy Fraser <[EMAIL PROTECTED]> > Subject: Re: How to make FR reset the logs > To: freeradius-users@lists.freeradius.org > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain > > On Wed, 2006-05-04 at 06:15 +0300, Mordor Networks wrote: > > hi > > Is it possible to make FR remove all monthly accounting logs from > the > > database "mysql"? > > Yikes, why would you want to do that? > > Thanks for your reply . i have pppoe-server with FR and mysql and > dialup_admin , and 600 user , so i have a lot of traffic and logs > daily/monthly
I don't use MySQL very often so do not know for sure if this would work, but here goes a simple example : select * into radacct_old from radacct where AcctStopTime < '2006-04-01 00:00:00' ; delete from radacct where AcctStopTime < '2006-04-01 00:00:00' ; vacuum; If you intend on using MySQL you will need to learn how to use it. There are many functions and some may help you do what you want. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
