I'm sorry if you already discuss this issue, but I searched for a
solution and could not find it.
We have a 3Com total control with 1 Hyper ARC, Authentication is working
but Accounting is not.
RadiusNT complains Field 'Calls.CallerID' can't be a zero-length
string.
On table calls I have callerid column empty, and accounting works just
fine when I try
c:\radlogin test test START ... STOP
NASIdentifier NASPort AcctSessionId AcctStatusType CallDate UserName
AcctDelayTime AcctSessionTime FramedAddress AcctInputOctets
AcctOutputOctets NASPortType ClientPortDNIS CallerID ConnectInfo
127.0.0.1 0 177627 1 8/5/98 3:05:56 PM test
127.0.0.1 0 178350 2 8/5/98 3:06:03 PM test 180
On table ServerPorts
--------------------
ServerID Port IPAddress MaxSessionTime CostPerMinute UserName
AcctStatusType CallDate FramedAddress
1 0 0 0 test 2 8/5/98 3:06:03 PM
2 1024 192.168.250.3 0 0 0
After a while even authentication requests times out, because of
accounting requests, that keep repeating for ever, the only way to fix
is reboot the 3Com box.
logfile:
--------
Thu Aug 06 10:49:48 1998: ODBC Error:S1000:-3702:
[Microsoft][ODBC Microsoft Access 97 Driver] Field 'Calls.CallerID'
can't be a zero-length string.
Thu Aug 06 11:43:11 1998: ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain a Null value.
debug -x25:
-----------
0) Mode: 1
1) IgnoreCase: 0
2) TrimName: 0
3) ReqAcctAuth: 0
4) AllowMalformed: 1
5) Proxy: 0
6) Options: 138
7) Debug: 0
8) LogFile:
9) AcctLogFile:
10) ODBCDatasource: Radius
11) Username:
12) Password:
13) AcctODBCDatasource:
14) AcctUsername:
15) AcctPassword:
16) DataDirectory: d:\servicos\radius
17) AcctDirectory: d:\servicos\radius
18) UsersFile: Users
21) IPAddress: 172.16.1.1
Resp Time: 15 Auth: 3/11 -> 14 Acct: 1/116/0 -> 117
radrecv: Request from host c8fc5c04 code=4, id=16, length=286
User-Name = "test"
NAS-Identifier = 192.168.250.3
Acct-Status-Type = Stop
Acct-Session-Id = "df556d81"
Acct-Delay-Time = 840
Acct-Authentic = RADIUS
User-Service = Framed-User
NAS-Port-Type = Async
NAS-Port = 1025
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Caller-Id = ""
NAS-Port-DNIS = "1968"
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Vendor-Specific = ""
Framed-Protocol = PPP
Framed-Address = 192.168.250.10
Vendor-Specific = ""
Received unknown attribute 51
Received unknown attribute 50
Acct-Session-Time = 5677
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 247104
Acct-Output-Octets = 12539273
Acct-Input-Packets = 9717
Acct-Output-Packets = 14691
SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusType,AcctSessionId,AcctDelayTime,NASPortType,NASPort,CallerId,FramedAddress,AcctSessionTime,AcctInputOctets,AcctOutputOctets)
VALUES
(Now(),'colegio','192.168.250.3',2,'df556d81',840,0,1025,'','192.168.250.10',5677,247104,12539273)
ODBC Error:S1000:-3702:
[Microsoft][ODBC Microsoft Access 97 Driver] Field 'Calls.CallerID'
can't be a zero-length string.
Resp Time: 312 Auth: 3/11 -> 14 Acct: 1/357/0 -> 358
radrecv: Request from host c8fc5c04 code=4, id=1, length=87
User-Name = "root"
NAS-Identifier = 192.168.250.3
Acct-Status-Type = Start
Acct-Session-Id = "root1"
Acct-Delay-Time = 0
Acct-Authentic = Local
User-Service = Shell-User
NAS-Port-Type = 5
Login-Service = Telnet
Login-TCP-Port = 1085
Login-Host = 200.252.92.1
SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusTyp
e,AcctSessionId,AcctDelayTime,NASPortType) VALUES
(Now(),'root','192.168.250.3',
1,'root1',0,5)
ODBC Error:23000:-1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain
a Null value.
Resp Time: 15 Auth: 1/0 -> 1 Acct: 1/358/0 -> 359
3Com box:
---------------
ACCOUNTING SETTINGS:
Use_Servers: ONE
Primary Server is: 172.16.1.1
Primary Server Port is: 1646
Secondary Server is: 0.0.0.0
Secondary Server Port is: 1646
Retransmission Timeout: 60
Max Retranmissions: 0
Accounting Start Time: CONNECTION
Status is:
ENABLED
THANK YOU FOR HELP !
Regards,
JR