Re: [Emerald] Annex VSA attributes

Dale E. Reed Jr. ( (no email) )
Mon, 18 Oct 1999 13:33:24 -0700

david leigh wrote:
>
> Hi Dale
>
> I have downloaded the r25vsa_updt.sql script from the ftp site. I edited the
> script (following the same conventions as with the Cisco and ascend vendors
> already in the script) and inserted the Bay Annex attributes. I then tried
> running the script which gave a few errors (I attach the output from the SQL
> query).
>
> Following this I have checked in the Emerald client under the RADIUS tab of
> a subaccount, and also in the Emerald Admin Radius section. In both places I
> seem to have lost all Radius attributes except for Standard values. (Ie
> Cisco and Ascend stuff which used to be there is gone, and the new Bay stuff
> has not been added). I seem to have done something wrong - but am not sure
> how. Is there anything I can do to get the Radius Values restored?

The last set of lines restore them from the old tables:

Insert Into RadConfigs(AccountID, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck)
Select AccountID, RadAttributeID, RadVendorID, RadVendorType, Data,
Value, RadCheck