Re: [RadiusNT] "no attributes" error

Josh Hillman ( (no email) )
Fri, 15 Sep 2000 13:30:35 -0400

Dale, I spoke too soon. Are there other stored procedures that reference
something similar to @AccountType field in the RadGetATConfigs that might
still be set to varchar(15)?

Josh

----- Original Message -----
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <radiusnt@iea-software.com>
Sent: Friday, September 15, 2000 1:16 PM
Subject: Re: [RadiusNT] "no attributes" error

> Ahhh I had a feeling it might have been related to the length somewhere.
I
> changed it in the stored procedure from 15 to 20 and although I haven't
> tested it, I'm guessing that's all it took to fix the problem. I changed
> the AccountType column in SubAccounts and AccountTypes from 15 to 20 a
while
> back. It gets a little difficult sifting through dozens of AccountType
> names, trying to remember what all of the abbreviations mean.
>
> Thanks,
> Josh
>
> ----- Original Message -----
> From: "Dale E. Reed Jr." <daler@iea-software.com>
> To: <radiusnt@iea-software.com>
> Sent: Friday, September 15, 2000 1:07 PM
> Subject: Re: [RadiusNT] "no attributes" error
>
>
> > Josh Hillman wrote:
> > >
> > > I have two AccountTypes set up in Emerald that have the exact same
> radius
> > > attributes configured for each one in RadiusNT Admin, but when someone
> dials
> > > up, one of the two account types results with a connection failure.
The
> > > error that's logged is "no attributes". This would make sense to me
if
> > > there were no radius default configured for that account type, but
there
> > > are. Any idea what would cause this?
> >
> > Check your RadGetATConfigs stored proc. The size of the parameter
> > is 15, but the DSL name is 17 characters.
> >
> > > RadATConfigID AccountType RadAttributeID Data Value
> > > ------------- -------------------- -------------- ------------ -----
> > > 238 DSL Res. 512/128k 6 Framed-User 2
> >
> > CREATE PROCEDURE RadGetATConfigs @AccountType varchar(15) AS
> >
> > There the name is getting truncated to 15 and no match. Modify the
> > length
> > to > 17 (20?) and then it should work.
> >
> > --
> >
> > 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
> >
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart