Thanks Alan. I enabled detail module in accounting. details files were created under radacct clients directories. Just wanted to check if any module already available in freeradius to scan these detail files, parse and put attributes in mysql db every 2-3 mins? Thanks, Rams.
-------------- Message: 7 Date: Tue, 18 Aug 2009 15:33:09 +0100 From: Alan Buxey <A.L.M.Buxey@lboro.ac.uk> Subject: Re: accounting through detail module help To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <20090818143309.GA32113@lboro.ac.uk> Content-Type: text/plain; charset=us-ascii
Hi,
At present our radius servers getting traffic of more than 3 million users. We have only two radius servers and one mysql server active. The server crashing whenever more traffic comes. Due to mysql overload and slow I'm planning to use detail module for accounting and then take these details and parse then put in database using program/script. Does this helps? Is there any script already available in freeradius? Does palcing one more radius server and using mysql clustering helps?
use the detail module and let FR deal with handling the detail module.
you can speed up the MySQL using eg batter indexing and better storage engine
alan
------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
End of Freeradius-Users Digest, Vol 52, Issue 81 ************************************************