Re: How to make FR reset the logs
On Thu, 2006-06-04 at 14:12 -0400, Dennis Skinner wrote: Guy Fraser wrote: vacuum; This is not a MySQL command. You probably want to look at CHECK TABLE, REPAIR TABLE, and OPTIMIZE TABLE. But we are getting off topic here I will note that FreeRADIUS performance had significant improvements once the tables were changed to InnoDB from MyISAM, especially the radacct table as that fills up quick if you don't archive regularly. I said : 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. I prefer PostgreSQL, which is SQL92 compliant and does support the SQL VACUUM command. MySQL database maintenance is of little interest to me, because I do not think it is good for anything but text and blob storage, and I don't need that very often. Since nobody else had attempted to answer the posters question I suggested a possible method he could try, and suggested he learn how to maintain MySQL if he intends on using it. I REALLY do NOT want to get into a flame war over the differences between MySQL and PostgreSQL. I based my sample on SQL standard commands hoping that MySQL would support them, but having suggested that they may not work without specifying why, may have left it open for interpretation. I am sure that for those who know MySQL well it works very well for them, but I don't care to spend the time learning how to do things the MySQL way. I have provided some assistance ensuring that the MySQL and PostgreSQL drivers had the same functionality, and have a MySQL db on the RD machine for that purpose, but do not have any intention on using it for production. The PostgreSQL db I use for my custom Cistron server has operated flawlessly and at high efficiency since it was installed over 5 years ago. Since the Software and Hardware are long in the tooth, I will be upgrading them in the near future. I have been helping with the development of FreeRadius for a couple years, in preparation for this long anticipated upgrade. Once I have a good Management interface I will upgrade. I have spent a few days building some functions and others have been spending considerable time on similar projects, and some of us have agreed to share, our work in order to move this along, so I am hoping to have a new server in place by years end. Good luck, and have a great day. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: How to make FR reset the logs
Hello Thank you all for your replies , i fixed my issue using some scripts that comes with dialup_admin, /bin/ dir , it is working for know , thank you Guy Fraser.My question know , is it possible to send any attribute using dialup_admin to disconnect a user, i have a some handmade bash scripts to do that but it would be great if it can be done with dialup_adim - radius - pppd/pppoe-servers Thanks again - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: How to make FR reset the logs
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?
Wouldn't it be better to move the data to monthly archive
tables, then remove the data and vacuum the table?
This is basically what I currently use, so that when a
customer tries to dispute his charges, we can produce
detailed information very quickly. I currently maintain
3+ years of detail, users can check totals, summaries or
detailed logging for their account from the beginning of
the third year ago {IE Jan 2003} until the previous
logout.
Once I have a similar scheme in place I will be moving
to which ever current version of FreeRadius is available.
I will continue to work toward integrating similar
functionality into FreeRadius, that I developed for
Cistron, allowing dynamic {using xlat} table names. I
currently use this method in my custom version of
Cistron Radius, to generate new logging tables every
month as required. The system I developed has met our
needs for the last 5+ years, but I would prefer to
build support into an open platform {FreeRadius}, so
others can make use of the same advantages, and the
community can enhance and support the project.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: How to make FR reset the logs
Date: Wed, 05 Apr 2006 11:09:58 -0600From: Guy Fraser [EMAIL PROTECTED]Subject: Re: How to make FR reset the logs
To: freeradius-users@lists.freeradius.orgMessage-ID:
[EMAIL PROTECTED]Content-Type: text/plainOn 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
Wouldn't it be better to move the data to monthly archivetables, then remove the data and vacuum the table?If there is a way to do the it would be great This is basically what I currently use, so that when a
customer tries to dispute his charges, we can producedetailed information very quickly. I currently maintain3+ years of detail, users can check totals, summaries ordetailed logging for their account from the beginning of
the third year ago {IE Jan 2003} until the previouslogout.Once I have a similar scheme in place I will be movingto which ever current version of FreeRadius is available.I will continue to work toward integrating similar
functionality into FreeRadius, that I developed forCistron, allowing dynamic {using xlat} table names. Icurrently use this method in my custom version ofCistron Radius, to generate new logging tables every
month as required. The system I developed has met ourneeds for the last 5+ years, but I would prefer tobuild support into an open platform {FreeRadius}, soothers can make use of the same advantages, and the
community can enhance and support the project.Thanks for the info , thus i still have no clue...
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How to make FR reset the logs
hiIs it possible to make FR remove all monthly accounting logs from the database mysql? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: How to make FR reset the logs
Mordor Networks [EMAIL PROTECTED] wrote: Is it possible to make FR remove all monthly accounting logs from the database mysql? No. That's what external cron jobs are for. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
