Re: Radius & ODBC & SQL

Philip Thomas ( phil@saturnnet.com )
Thu, 03 Apr 1997 07:51:27 -0800

How do I look that up?

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