On Wed, 2006-05-04 at 22:06 +0300, Mordor Networks wrote:
Date: Wed, 05 Apr 2006 11:09:58 -0600 From: Guy Fraser <guy@incentre.net> Subject: Re: How to make FR reset the logs To: freeradius-users@lists.freeradius.org Message-ID: <1144257000.9277.140.camel@sigurd.incentre.net> 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.