Access Database File

Webmaster ( (no email) )
Wed, 7 May 1997 18:22:50 -0500

The access database file that came with radius does not seem to be working
for me. I have tried everything I know with ODBC and Access. The data the
sql is calling for is simple enough, it should be able to find atleast the
test user.

radius -x15 -o -R31 is what I use to start radius (atleast most of my
tries)

I can tell It is reading the access file because the server ip is showing
up when radius starts.

But when I log in I get this:

radrecv: Request from host d0c90e1a code=1, id=196, length=139
User-Name = "test"
Challenge-Response =
"\001h\034^`6\260\300\271W\355\326\313\302\376\344\331"
NAS-Identifier = 208.201.14.26
NAS-Port = 29
User-Service = Framed-User
Framed-Protocol = PPP
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Received unknown attribute 32
Acct-Session-Id = "00000049"
NAS-Port-Type = Async
rad_authenticate_ODBC()
Challenge-Response =
"\001h\034^`6\260\300\271W\355\326\313\302\376\344\331"
Decrypted Password: /÷¬EZ¤I+=»¦¬+>?=
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='test' or sa.Shell='test') AND ma.CustomerID=sa.CustomerID
and sa.Active<>0 and ma.Active<>0

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

User: test Not found
Sending Reject of id 196 to d0c90e1a (netserver1)

If I copy the sql statement into access I get the information I need. But
I just can't get it though radius.

Please help
Linda