Re: Radius & ODBC & SQL

Dale E. Reed Jr. ( (no email) )
Thu, 3 Apr 1997 10:18:11 -0800 (PST)

On Thu, 3 Apr 1997, Philip Thomas wrote:

> How do I look that up?

Do the same thing you did below, except rather than use radlogin,
actually log into your terminal server.

> Dale E. Reed Jr. wrote:
> >
> > Philip Thomas wrote:
> >
> > This looks perfectly fine. Auth went good. What does RadiusNT
> > show for a NAS auth request?
> >
> > > Ok Dale here is what I got when I used radlogin with the radius -x15
> > >
> > > radrecv: Request from host 7f000001 code=1, id=1, length=0
> > > NAS-Identifier = 127.0.0.1
> > > NAS-Port = 0
> > > User-Name = "hello"
> > > Password = "(\342\250\331#\013\320-\275\030\357\005;\300\267\271"
> > > rad_authenticate_ODBC()
> > > Password = "(\342\250\331#\013\320-\275\030\357\005;\300\267\271"
> > > Decrypted Password: hellos
> > > Allocating Statement...
> > >
> > > SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue),
> > > maExpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
> > > sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma,
> > > SubAccounts sa Where (sa.Login='hello' or sa.Shell='hello') AND
> > > ma.CustomerID=sa.CustomerID
> > > and sa.Active<>0 and ma.Active<>0
> > >
> > > Database Password: hellos
> > > Freeing SQL Statement...
> > > Allocating Statement...
> > >
> > > SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
> > > RadConfigs rc, RadAttributes ra Where
> > > ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=9
> > >
> > > Freeing SQL Statement...
> > > Loading radius defaults for this type...
> > > Allocating Statement...
> > > Allocating Statement...
> > >
> > > SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
> > > RadATConfigs rc, RadAttributes ra Where
> > > ra.RadAttributeID=rc.RadAttributeID AND rc.AccountType='PPP'
> > >
> > > User-Service = 2 (2)
> > > Framed-Protocol = 1 (1)
> > > Freeing SQL Statement...
> > > Sending Ack of id 1 to 7f000001 (localhost)
> > > User-Service = Framed-User
> > > Framed-Protocol = PPP
> > >
> > > Response Time: 375
> >
> > --
> > Dale E. Reed Jr. (daler@iea.com)
> > _________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.emerald.iea.com
> >
> > ----------------------------------------------------------
> > RadiusNT Mailing List listserver@emerald.iea.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com
>
>