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

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 =
NAS-Identifier =
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
Challenge-Response =
Decrypted Password: /EZI+=+>?=
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