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@ox.org> To: "FreeRadius users mailing list" <freeradius-users@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@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