Re: [RadiusNT] "no attributes" error

Josh Hillman ( (no email) )
Fri, 15 Sep 2000 13:41:54 -0400

From: "Josh Hillman" <admin-maillist@talstar.com>
> 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)?

I found it referenced also in the RadCheckDNIS sp, so I fixed the length in
there. I'll test it out later and see if that fixed it.

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

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