Radius accounting file scanning and upload to database

[Ming-Ching Tiew]

From: "Lewis Bergman" <lbergman at wtxs.net>

> This is probably a stupid question but whay not log the accounting 
> directly to the sql via the sql module?
> 

Reasons :-

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.

Also per record logging is way too slow to cope with the speed I am
looking for. I am in fact using the TDS BULK INSERT mechanism for 
insertion. It is much much faster than per record logging.

All in all, I find that logging to database via radius server directly is a 
bad design, more so for a heavy radius server with lots of traffic, and 
worse if it is across the network (WAN!) , due to network instablity, 
database server load conditions etc etc etc.

Cheers