Dear ML, were running several radius-servers with Freeradius 0.8.1 or later. Now our mysql.radacct table requires to start a mysql_optimize_table, because selecting on this table takes longer and longer...
A mysql_optimize locks the table, so that it isn't possible to access this table during optimize which means that all acoounting data will be lost. That's not the solution i want to, so i wrote a script which strips off mysql support from radiusd by changing radiusd.conf. All accounting data is now logged to detailfile only and none of the accounting-packets will be lost on optimize, i thought. This works quiet good, so i'm able to resend accounting-packets to radiusd after optimize had finished. But during the mysql_optimize logging to detailfile takes so much time that radiusd is discarding each request due to live request. Our Problem is, that we don't have a radius-proxy which could be instruct to send the accounting-data to a other radius-server while the first is in maintainance. Has anyone a solution for this scenario? We have to optimize our radacct table, which takes round about 15 minutes, and we don't want to loose accounting-data.... Thanks a lot, Marc Prenger - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
