Parse error -98 - Text File & ODBC

Albert Churba ( (no email) )
Wed, 11 Jun 1997 19:20:12 -0400

I'm trying to setup RadiusNT and Emerald. I have successfully =
configured: the service, created a working text file "users", configured =
the MAX4004, enabled accounting to the "details" file, configured the =
ODBC (system DSN), and basic configuration of the Emerald ISP package. =
Help from the list has been great! :) I would love to see better bound =
formal documentation so I can RTFM. :)

The problem:

I'm lazy and a bad typist. Until ALL of the data entry is complete and =
verified in the SQL database, in terms of the MBR's, I need to use the =
"users" file in conjunction with the ODBC source. The "users" file loads =
fine when used by itself. As soon as I enable the ODBC connection with =
the text file, RadiusNT returns: Parse error -98 for user XX. This being =
the first entry in the "users" file.

In a previous message thread, I saw a suggestion to check for the TAB =
character. I have checked and all formatting is correct. The funny thing =
is that the "users" file load fine by itself.

Can anyone help please?

TIA,
Albert

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RadiusNT Output messages:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Combination of text & ODBC:
------------------------------------------
C:\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: 65
5) Debug: 15
6) ODBCDatasource: Emerald
7) DataDirectory: C:\Radius
8) AcctDirectory: C:\Radius\Acct
9) UsersFile: Users
10) Username: xx
11) Password: xx
12) AuthPort: 1645
13) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Emerald'...
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, =
RadAttribut
es ra Where rv.RadAttributeID =3D ra.RadAttributeId

odbc_read_client_info()
Allocating Statement...

SQL Statement: Select Server, IPAddress, Secret From Servers

Client:MAX1:x.x.x.x:xx
Client:Dopey:x.x.x.x:xx
Client:Dopey-old:x.x.x.x:
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: 'UserService'
Accounting Column 7: 'AcctDelayTime'
Accounting Column 8: 'AcctSessionTime'
Accounting Column 9: 'FramedProtocol'
Accounting Column 10: 'FramedAddress'
Accounting Column 11: 'AcctInputOctets'
Accounting Column 12: 'AcctOutputOctets'
Accounting Column 13: 'AcctTerminateCause'
Accounting Column 14: 'NASPortType'
Accounting Column 15: 'NASPortDNIS'

Loading users...
radius: Parse error -98 for user XX
0 users loaded!

Radius NT is ready to receive requests!

Just the user file returns:
-----------------------------------
C:\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: 0
4) Options: 1
5) Debug: 15
6) ODBCDatasource: Emerald
7) DataDirectory: C:\Radius
8) AcctDirectory: C:\Radius\Acct
9) UsersFile: Users
10) Username: xx
11) Password: xx
12) AuthPort: 1645
13) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
Client:xx
Client:xx
Client:xx
Client:xx

Loading users...
User:1
..
..
User:44
44 users loaded!

Radius NT is ready to receive requests!

Just the ODBC returns:
----------------------------------
C:\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: 1
4) Options: 65
5) Debug: 15
6) ODBCDatasource: Emerald
7) DataDirectory: C:\Radius
8) AcctDirectory: C:\Radius\Acct
9) UsersFile: Users
10) Username: xx
11) Password: xx
12) AuthPort: 1645
13) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Emerald'...
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, =
RadAttribut
es ra Where rv.RadAttributeID =3D ra.RadAttributeId

odbc_read_client_info()
Allocating Statement...

SQL Statement: Select Server, IPAddress, Secret From Servers

Client:MAX1:x.x.x.x:xx
Client:Dopey:x.x.x.x:xx
Client:Dopey-old:x.x.x.x:
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: 'UserService'
Accounting Column 7: 'AcctDelayTime'
Accounting Column 8: 'AcctSessionTime'
Accounting Column 9: 'FramedProtocol'
Accounting Column 10: 'FramedAddress'
Accounting Column 11: 'AcctInputOctets'
Accounting Column 12: 'AcctOutputOctets'
Accounting Column 13: 'AcctTerminateCause'
Accounting Column 14: 'NASPortType'
Accounting Column 15: 'NASPortDNIS'

Radius NT is ready to receive requests!