Re: [Emerald] Radius Error

Dale E. Reed Jr. ( (no email) )
Wed, 10 May 2000 10:40:02 -0700

> Kenneth Gustav Eitenmiller Jr wrote:
>
> Awhile back I had some help setting up a session time limit for our
> dialup customers:
>
> Radius Attribute
> Session Time
> 28800
>
> This cut people off after 8 hours...
>
> Ever since then my "online" and user concurancy is all screwed up.
> I am get many "over log in limit" cases in my radius log...
>
> This is the error I get running radius -x15
>
> ODBC Error: 23000: 2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server] Violation of Primary
> Key constraint 'pk_calls': Attempt to insert duplicate key in object
> 'calls'.
>
> I have had to turn off concurancy control to allow my customers to
> connect...
>
> Does ANYONE have ANY ideas???

What type of terminal server are you using? Sometimes, they DO send
duplicate ASIDs, for different sessions. I had to add the Username
and port into the primary key for the calls table to work around
the reuse of ASIDs, before.

-- 

Dale E. Reed Jr. Emerald and RadiusNT/X__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart