RE: [RadiusNT] VSA

Clancy Knaup ( (no email) )
Mon, 15 Mar 1999 08:08:02 -0600

When I use that PROCEDURE my PPP fails to connect, I get no attribute in the
log file.

Clancy

P.S. I am useing Plat for accounting

-----Original Message-----
From: radiusnt-request@iea-software.com
[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Sunday, March 14, 1999 8:55 PM
To: radiusnt@iea-software.com
Subject: Re: [RadiusNT] VSA

Clancy Knaup wrote:
>
> However if I run RadGetATConfigs 'TEST' I Get; How do I remove all of the
> reset of the extra RadAttrubute 26

The RadGetATConfigs proc had an error in some release. Double-click
the proc in your Emerald Database, and check the table matching. I
believe the problem is the second to last line was incorrectly
"ra.RadVendorType=ra.RadVendorTpe", where the second one should have
been rc. Here is the correct proc:

CREATE PROCEDURE RadGetATConfigs @AccountType varchar(15) AS
Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID,
rc.RadVendorType, rc.RadCheck
>From RadATConfigs rc, RadAttributes ra
Where ra.RadAttributeID=rc.RadAttributeID
AND ra.RadVendorID = rc.RadVendorID
AND ra.RadVendorType = rc.RadVendorType
AND rc.AccountType=@AccountType

--

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html

For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html