OK - that made the calls table/query start working, but I'm
still not seeing anything in the RadLog table. Here is the
debug output:
Resp Time: 7321 Auth: 0/0 -> 0 Acct: 3/0/0 -> 3
radrecv: Request from host d0d10541 code=4, id=53,
length=155
Acct-Session-Id = "22000B44"
User-Name = "goofy"
NAS-Identifier = 208.209.5.65
NAS-Port = 7
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 7232
Acct-Authentic = RADIUS
Connect-Info = "24000 LAPM/V42BIS"
Acct-Input-Octets = 863363
Acct-Output-Octets = 9376123
NAS-Port-DNIS = "6754200"
Caller-Id = "2192661669"
Acct-Terminate-Cause = User-Request
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.209.5.81
Acct-Delay-Time = 0
SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,NASPortType,AcctStatusType,AcctSessionTime,AcctAuth
entic,AcctInputOctet
s,AcctOutputOctets,UserService,FramedProtocol,FramedAddress,
AcctDelayTime) VALUE
S
(Now(),'22000B44','goofy','208.209.5.65',7,0,2,7232,1,863363
,9376123,2,1,'208.
209.5.81',0)
SQL Statement: UPDATE CallsOnline Set UserName='goofy',
AcctStatusType=2, CallD
ate=Now(), FramedAddress='OCPM3-1-14.cyberlink.com' WHERE
NASIdentifier='208.20
9.5.65' and NASPort=7
Sending Accounting Ack of id 53 to d0d10541 (OCPM3-1)
Resp Time: 121 Auth: 0/0 -> 0 Acct: 4/0/0 -> 4
Zak Wolfinger - zak@cyberlink.com
Systems Admin - CyberLink, Inc.
(888) PLUG-IN-2