Re: Re: accounting through detail module help
Thanks Alan.
But we have two accounting sections in default and buffered-sql. Do i need to enable sql module only in buffered-sql? And place buffered-sql in defualt 'accounting' section. am Confused...
Thanks, Rams.
------------------------------
Message: 2 Date: Tue, 18 Aug 2009 23:29:47 +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: <20090818222947.GD32575@lboro.ac.uk> Content-Type: text/plain; charset=us-ascii
Hi,
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?
sites-available/buffered-sql ?
just ensure that the sql stuff is configured correctly...link/copy it into sites-enabled and restart the daemon
alan
------------------------------
Thanks Alan. sorry for posting again. But we have two accounting sections in default and buffered-sql. Do i need to enable sql module only in buffered-sql? And place buffered-sql in defualt 'accounting' section. am Confused...which file section will be processed. Thanks, Rams.
------------------------------
Message: 2 Date: Tue, 18 Aug 2009 23:29:47 +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: <20090818222947.GD32575@lboro.ac.uk> Content-Type: text/plain; charset=us-ascii
Hi,
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?
sites-available/buffered-sql ?
just ensure that the sql stuff is configured correctly...link/copy it into sites-enabled and restart the daemon
alan
------------------------------
Hi, ** *default { *preacct { preprocess acct_unique suffix files } accounting { if(Acct-Status-Type == 'Stop') { detail } radutmp attr_filter.accounting_response Acct-Type Status-Server { } * }* ////////////////////////// *buffered-sql {* preacct { preprocess acct_unique files } accounting { sql } * } * Which accounting section needs to be activated? Does this configuration correct? Please help. Thanks, Rams.
Message: 2
Date: Tue, 18 Aug 2009 23:29:47 +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: <20090818222947.GD32575@lboro.ac.uk> Content-Type: text/plain; charset=us-ascii
Hi,
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?
sites-available/buffered-sql ?
just ensure that the sql stuff is configured correctly...link/copy it into sites-enabled and restart the daemon
alan
------------------------------
hi, the default server will call detail the buffered-sql should call the actual SQL module to do the work. this means default server spews packet data to detail file, the buffered-sql then reads that data and chucks into SQL alan
participants (2)
-
Alan Buxey -
ramesh p