old 1.16.52

Juergen Weiss ( (no email) )
Wed, 7 Jan 1998 17:09:42 +0100

I think it is about 7 months ago where I installed 1.16.52 using all
defaults. I am doing only accounting to the sample-access-db. Since it
worked from the beginning without problems I never really understood what=
is
happening. So thats why I am still a newbie to radius. Here are my
questions:

1. Will the old "freeware" still supported through this list? If not plea=
se
tell me.

2. Is there a way to modify the sql-statements which are generated throug=
h
radiusNT. If my NAS sends a vendor-specific attribute for accounting, wi=
ll
I be able to save this to the radius7.mdb?

3. I try to setup also authentification. My NAS (Telebit Netblazer 40i) h=
as
a internal test-command. If I do this from my NAS for user test I get goo=
d
responses. But if I dial in following error is shown in -o -x15 debug mod=
e:
---------------------------------------------------
radrecv: Request from host c219d961 code=3D1, id=3D185, length=3D75
User-Name =3D "test"
Challenge-Response =3D "\001\366\302URC\221\245\360m\374]\007M\343H\3=
51"
User-Service =3D Framed-User
Framed-Protocol =3D PPP
NAS-Identifier =3D 194.25.217.97
NAS-Port =3D 53
NAS-Port-Type =3D ISDN
rad_authenticate_ODBC()
Challenge-Response =3D "\001\366\302URC\221\245\360m\374]\007M\343H\3=
51"
Decrypted Password: V?4?=DB=A68=F4,P=B1=FC}?n?
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login=3D'test' =
or
sa.She
ll=3D'test') AND ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and ma.Ac=
tive<>0

Freeing SQL Statement...
LOG: User: test Not found

User: test Not found
Sending Reject of id 185 to c219d961 (merkur)

Response Time: 62

----------------------------------------------------

This is what I get when using the NAS test-command:

----------------------------------------------------
radrecv: Request from host c219d961 code=3D1, id=3D101, length=3D68
User-Name =3D "test"
Password =3D "\367\301H\317\256\011\257\274\031V\357\001n\025\035C"
User-Service =3D 8
NAS-Identifier =3D 194.25.217.97
NAS-Port =3D 0
NAS-Port-Type =3D 5
rad_authenticate_ODBC()
Password =3D "\367\301H\317\256\011\257\274\031V\357\001n\025\035C"
Decrypted Password: test
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login=3D'test' =
or
sa.She
ll=3D'test') AND ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and ma.Ac=
tive<>0

Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND
rc.AccountI
D=3D1

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From
RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=3Drc.RadAttributeID AND
rc.Accou
ntType=3D'PPP'

Framed-Protocol =3D PPP (1)
User-Service =3D Framed-User (2)
Session-Timeout =3D 7200 (7200)
Freeing SQL Statement...
Sending Ack of id 101 to c219d961 (merkur)
Framed-Protocol =3D PPP
User-Service =3D Framed-User
Session-Timeout =3D 7200

Response Time: 62

-----------------------------------------------------------------

I think it depends on CHAP / PAP.

Can anybody help me?

TIA
Juergen