Re: [Emerald] Radius Error

Dale E. Reed Jr. ( (no email) )
Wed, 10 May 2000 11:23:27 -0700

Kenneth Gustav Eitenmiller Jr wrote:
>
> > 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.
>
> 3com Total Control...
> How do you add the Username and port into the primary key for the calls
> table to work around the reuse of ASIDs?
>
> This is not a sometimes thing... This is like 50%+ of our logins...

I was going to say USR, but was hoping not. <VBG>

What I do is rename the calls table (to prevent someone from
inserting a record while you do this), and then use Enterprise
manager to change the key on the calls table. For 7.0, you select
design on the calls table, ctrl-click the following columns:

AcctSessionID
NASIdentifier
NASPort
Username
AcctStatusType

The key is to make suer AcctSessionID is the FIRST column in
the key to get best performance. NAS Port is optional (although
it can help) and never put CallDate in the key.

Then save the changes and rename the table back.

-- 

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