Re: [Emerald] Radius Error

Dale E. Reed Jr. ( (no email) )
Wed, 10 May 2000 14:09:59 -0700

Kenneth Gustav Eitenmiller Jr wrote:
>
> ----- Original Message -----
> From: "Dale E. Reed Jr." <daler@iea-software.com>
> To: <emerald@iea-software.com>
> Sent: Wednesday, May 10, 2000 13:23
> Subject: Re: [Emerald] Radius Error
> >
> > 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,
> Well, we are running 6.5
> I can go to the Enterprise Manager, the drill down to the tables in the
> emerald database...
> Change the Calls table name...
> Then "manage" the table....
> In the advanced options, everything is greyed out...
> I am logged on as sa....
>
> Now what do I do?

For 6.5, right click Edit over the calls table. Click the Advanced
option,
and then say remove on the primary key/identity tab. Then you can
re-create
the key with the fields as listed above.

-- 

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