Re: [RadiusNT] HELP Yes
Dale E. Reed Jr. ( (no email) )
Wed, 28 Jul 1999 10:48:37 -0700
Greg wrote:
>
> > >
> > > Is it possible that you have some old records in your database with
> > > an AcctSessionID of some of the new ones? I've seen this happen on
> > > larger databases where the calls table was allowed to sit for quite
> > > a while and either the gear was upgraded (in which some reset their
> > > SessionIDs on an upgrade) or was given the IP of an retired piece of
> > > equipment and now they are clashing.
> > >
>
> Yes it looks like that is what is happening. I ran a script to pull the
> AcctSessionID for the last month then looked ar an error today and it had the ID
> from July 6th. How can I fix this it looks like it is only two of our Ascend's that
> have the problem.
Basically, you can either clear the records out of your calls
table, or update the existing record adding something to the beginnning
or end. For example:
Update Calls
Set AcctSessionID = 'xxx' + AcctSessionID
Where SubString(AcctSessionID,1,3) <> 'xxx'
and NASIdentifier is '1.2.3.4'
--
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