I am have installed radiusnt 1.16.60 and have had it running in text only
mode without accounting for some time. It is running on a Dual Pent. 133Mhz
PC. And I have converted the Radius7.mdb to a Office 97 Version. When I
activated the ODBC for Authentication and Accounting I get an application
error ( even if I use the radius7.mdb that is still in Office 95 format I
get the same error)
This is the complete process that it goes through from start up
Authentication to the error
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) AuthPort: 1645
3) ReqAcctAuth: 0
4) AcctPort: 1646
5) Mode: 1
6) Options: 127
7) Debug: 15
8) ODBCDatasource: Radius
9) DataDirectory: c:\radius
10) AcctDirectory: c:\radius\acct
11) UsersFile: users
12) Username:
13) Password:
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Allocating ODBC Henv...
Allocating ODBC Connect...
Making ODBC Connection...
MS Access Mode Enabled
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type From RadAttributes
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttributes ra Wher
e rv.RadAttributeID = ra.RadAttributeId
odbc_read_client_info()
Allocating Statement...
SQL Statement: Select Server, IPAddress, Secret From Servers
Client::207.1.181.5:sam
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'
Radius NT is ready to receive requests!
radrecv: Request from host cf01b505 code=1, id=54, length=76
User-Name = "detter"
Password = "W\217\313\272\233\021\265C\335U+e\235\315I\262"
NAS-Identifier = 207.1.181.5
NAS-Port = 1
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "W\217\313\272\233\021\265C\335U+e\235\315I\262"
Decrypted Password: sam
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, sa.TimeLef
t, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='detter' or sa.She
ll='detter') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0
Database Password: sam
LOG: Your Account is Expired.
Your Account is Expired.
Sending Reject of id 54 to cf01b505 ()
Response Time: 313
radrecv: Request from host cf01b505 code=4, id=42, length=108
Acct-Session-Id = "010000E3"
User-Name = "test"
NAS-Identifier = 207.1.181.5
NAS-Port = 1
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 385
Acct-Authentic = RADIUS
Acct-Input-Octets = 54447
Acct-Output-Octets = 18792
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 207.1.181.70
Acct-Delay-Time = 6802
Allocating Statement...
SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIdenti
fier,NASPort,N
ASPortType,AcctStatusType,AcctSessionTime,AcctAuthentic,AcctInputOctets,Acct
OutputOctets,U
serService,FramedProtocol,FramedAddress,AcctDelayTime) VALUES
(Now(),'010000E3','test','20
7.1.181.5',1,0,2,385,1,54447,18792,2,1,'207.1.181.70',6802)
ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to
the table were
not successful because they would create duplicate values in the index,
primary key,
Response Time: 250
radrecv: Request from host cf01b505 code=4, id=41, length=90
Acct-Session-Id = "010000E3"
User-Name = "test"
NAS-Identifier = 207.1.181.5
NAS-Port = 1
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 207.1.181.70
Acct-Delay-Time = 7187
Allocating Statement...
SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIdenti
fier,NASPort,N
ASPortType,AcctStatusType,AcctAuthentic,UserService,FramedProtocol,FramedAdd
ress,AcctDelay
Time) VALUES (Now(),'010000E3','test','207.1.181.5',1,0,1,1,2,1,'207.1.181.7
0',7187)
ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to
the table were
not successful because they would create duplicate values in the index,
primary key,
Response Time: 219
radrecv: Request from host cf01b505 code=4, id=39, length=108
Acct-Session-Id = "010000E2"
User-Name = "test"
NAS-Identifier = 207.1.181.5
NAS-Port = 1
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 76
Acct-Authentic = RADIUS
Acct-Input-Octets = 1035
Acct-Output-Octets = 859
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 207.1.181.71
Acct-Delay-Time = 7357
Allocating Statement...
SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIdenti
fier,NASPort,N
ASPortType,AcctStatusType,AcctSessionTime,AcctAuthentic,AcctInputOctets,Acct
OutputOctets,U
serService,FramedProtocol,FramedAddress,AcctDelayTime) VALUES
(Now(),'010000E2','test','20
7.1.181.5',1,0,2,76,1,1035,859,2,1,'207.1.181.71',7357)
Freeing SQL Statement...
Allocating Statement...
At this point I get the folowing
Radius.exe Application Error The instruction at 0x00419353 referenced
memory at 0xcf01b547 The memory could not be read.
The only option that it gives me is to click OK and when I do Radius
stops.
It looks like it is locking up on what ever it does after inserting the
info in the calls table. Also it looks like it is tring to use a default
account and I dont't want it to so I dont't have one setup.
Darryl Etter
Computer Services Network
1217 S. Kansas
Topeka, Ks 66612
Voice Phone : (913)233-8154