OLD Re: SQL consolidation and user logins

Rudy Komsic ( (no email) )
Sat, 22 Aug 1998 19:07:58 -0400

Hi Dale,

I was wondering if it is possible to create Emerald/RadiusNT to have 2
accounting sections. One accounting section for RadiusNT (The Temp section
Like tempcalls and callsonline etc.) and a second for Emerald (Full accounting
access)... This way when a calls consolidation is performed, RadiusNT would
have No problems posting accounting information into the Main connection but
if a calls consolidation flag is detected, it will revert to the secondary
section where it is stored in tempcalls. Then when the calls consolidation is
finished, a check would be performed by the SQL Server to determine if there
are any Information in tempcalls and move them into Calls.

This would then make RadiusNT/Emerald More solid and less headaches. The
RadiusNT could check a table called consolidateflag to see if it is triggered.
If so, then it will automatically dump into Tempcalls... then when the flag
clears, it will check to see if there are any info in tempcalls and move them
over to Calls.

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: August 10, 1998 4:48 PM
Subject: Re: SQL consolidation and user logins

>Mike Miller wrote:
>> We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We
>> keep 2 months accounting for our records. Our database is generally has
>> around 300MB to 400MB of space used to handle this. Every morning at 4AM
>> SQL executive runs a script that deletes all calls records over 2 months
>> old. According to SQL executive, this process has been taking between 12
>> and 15 minutes to complete each night. Our problem is that during the
>> consolidation process, there are periods of time in which no users can log
>> onto the network. The Radius screen itself just freezes on an accounting
>> request until consolidation completes. Originally Radius was installed on
>> the same machine as SQL Server, but because of the login problems we moved
>> it onto a different machine from the SQL server... no luck, still freezes
>> during consolidation. The same copy of Radius is performing authentication
>> and accounting. I suspect that the Calls table is getting locked during
>> the mass delete query, but am not sure if this is causing our problem or
>> not. Has anyone dealt with this? Is there a workaround that will allow us
>> to perform consolidation without locking out logins? Would running two
>> copies of radius on two seperate machines (one for authentication and one
>> for accounting) help or am I heading the wrong direction with this?
>RadiusNT 2.2 uses one connection for both accounting and authentication.
>Therefore, when you delete records from the calls table, it hangs the
>connections until the lock it done (including RadiusNT).
>RadiusNT 2.5 has a different connection for accounting and
>Therefore, when you start deleting a bunch of records, auth continues
>accounting hangs until you are done (not much you can do about that).
>Moral of the story: Upgrade to RadiusNT 2.5. :)
>Dale E. Reed Jr. (daler@iea-software.com)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com