Radius accounting file scanning and upload to database

Ming-Ching Tiew mingching.tiew at redtone.com
Tue Dec 27 09:12:35 CET 2005



Actually I was told by the development of such thing ( ie decoupled SQL logging )
in the radius server some time ago, that is a good thing but I am currently using 
my own relay logging and it is already very stable and very fast ( using bulk insert ),
it just suffers the limitation that it is one day late, and thus I have these questions :-

 The radius server method, I believe is also based on scanning a directory
 of files, how does it handle files which are still growing ( ie unfinished files ) ?
 Or it is assuming that the files have been completed ( ie there are no files
which are still active ! ) ?

Cheers

----- Original Message ----- 
From: "Alan DeKok" <aland at ox.org>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Saturday, December 24, 2005 1:38 AM
Subject: Re: Radius accounting file scanning and upload to database 


> "Ming-Ching Tiew" <mingching.tiew at redtone.com> wrote:
> > I am logging to MSSQL and I have tried in the past to do it directly,
> > I find that the stability is POOR and reliability is NOT ACCEPTABLE.
> > For example, the sql driver does not reconnect upon failure. I tried fixing
> > it myself but I also faced other weird problems which are difficult to 
> > troubleshoot.
> 
>   See rlm_sql_log in the 1.1.0-pre0 image.  It should help.
> 
>   Alan DeKok.
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 






More information about the Freeradius-Users mailing list