Working with Visual Foxpro and RadiusNT

Marlon Reinaldo Cardoso ( marlon@globonet.com.br )
Tue, 22 Apr 97 17:44:00 PDT

I did a mirror of the example database which came with Radius NT 1.16.60 =
in Microsoft Visual FoxPro 3.0, (I use also the Visual Foxpro ODBC driver=
5.0 from Microsoft), I put the same names on the tables, I did the same =
relationships, I even indexed on the same fields, but when I try to run =
the Radius I got:

D:\radius>radius -x15

RadiusNT 1.16.60 2/7/97 Copyright (c) 1996 IEA Software, Inc.
All Rights Reserved, Worldwide

Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.

0) EncryptPasswords: 0
1) IgnoreCase: 0
2) ReqAcctAuth: 0
3) Mode: 2
4) Options: 0
5) Debug: 0
6) ODBCDatasource: Radius
7) DataDirectory: d:\radius\
8) AcctDirectory: d:\radius\acct\
9) UsersFile: users
10) Username:
11) Password:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Allocating ODBC Henv...
Allocating ODBC Connect...
Making ODBC Connection...
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadA=
ttribut
es ra Where rv.RadAttributeID =3D ra.RadAttributeId

odbc_read_client_info()
Allocating Statement...

SQL Statement: Select Server, IPAddress, Secret From Servers

Client:localhost :127.0.0.1 :localhost

Client:200.231.198.165 :200.231.198.165:testing123

Allocating Statement...
Accounting Column 0: 'nasidentifier'
Accounting Column 1: 'nasport'
Accounting Column 2: 'acctsessionid'
Accounting Column 3: 'acctstatustype'
Accounting Column 4: 'calldate'
Accounting Column 5: 'username'
Accounting Column 6: 'acctauthentic'
Accounting Column 7: 'userservice'
Accounting Column 8: 'loginservice'
Accounting Column 9: 'loginhost'
Accounting Column 10: 'acctdelaytime'
Accounting Column 11: 'acctsessiontime'
Accounting Column 12: 'framedprotocol'
Accounting Column 13: 'framedaddress'
Accounting Column 14: 'acctinputoctets'
Accounting Column 15: 'acctoutputoctets'
Accounting Column 16: 'acctinputpackets'
Accounting Column 17: 'acctoutputpackets'
Accounting Column 18: 'nasporttype'
Accounting Column 19: 'clientportdnis'
config_init(): dict_valfind(Lifetime-In-Days) not found.

Loading users...
radius: attribute name Password not found
radius: Parse error -95 for user test
LOG: radius: Parse error -95 for user test

0 users loaded!

Radius NT is ready to receive requests!

So, I read in a old message that the "config_init(): dict_valfind(Lifetim=
e-In-Days) not found." is not a problem at all, but the:

"radius: attribute name Password not found
radius: Parse error -95 for user test
LOG: radius: Parse error -95 for user test

0 users loaded!"

I really think that's a problem, I supose that Radius doesn't use a SQL =
command to take the information about the attributes and its values (besi=
de the fact that you see the commands after "Allocating Statments"), am =
I right??? If so Is the restriction of Visual Foxpro on a maximum of 10 =
characters to the index file causing this problem, please if somebody can=
help me on this, I will really appreciate, I didn't sleep the last two =
nights working on it.

Thanks in advance, and please forgive if I did some mistakes in english.

Marlon Cardoso

marlon@globonet.com.br