Re: [Emerald] ODBC error

Dale E. Reed Jr. ( (no email) )
Sat, 17 Jul 1999 20:33:37 -0700

John Troher wrote:
>
> Nope, I think you are wrong on this. This error says that it is RadLogs.
> that the duplicate happened in. My NAS's will give a user 3 tries on the
> username and password but if all 3 fail for the same reason it is only put
> in the radlogs once per call. The last two attempts error out as duplicate
> entries into radlogs

Sorry, you are right. The Primary Key on the RadLogs table only puts
the
same error for the same user in once per minute for the user. This is
specifically designed to prevent your radlogs from getting filled with
duplicate entries (like the one you list above).

> John
>
> "Dale E. Reed Jr." wrote:
>
> > "Michael Vincent K. Pozon - CompE" wrote:
> > >
> > > guys ,
> > > i found out why some users are not listed in the online windows
> > > becoz of this error :
> > >
> > > ODBC Error:23000:2627:
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY K
> > > int 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.
> > >
> > > Question :
> > > how do i fix this error ?
> >
> > What kind of terminal server are you using? This means that
> > RadiusNT things it already received the accounting record. However,
> > some terminals servers (notably USR) reuse Acct-Session-IDs to
> > quickly, which can cause the above problem.
> >
> > The only way to help prevent this is to add the username to the
> > Primary Key in the Calls table.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________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