Re: Logging to database?

Zak Wolfinger ( (no email) )
Thu, 23 Apr 1998 12:46:54 -0500

OK, I think I'm getting closer here. Here is the sample
output of my -x15 debug:

Resp Time: 40 Auth: 0/0 -> 0 Acct: 0/8/0 -> 8
radrecv: Request from host d0d10541 code=4, id=15,
length=131
Acct-Session-Id = "22000B44"
User-Name = "goofy"
NAS-IP-Address = 208.209.5.65
NAS-Port = 7
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Connect-Info = "26400 LAPM/V42BIS"
NAS-Port-DNIS = "6754200"
Caller-Id = "2192661669"
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.209.5.81
Acct-Delay-Time = 606

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASPort,NASPo
rtType,AcctStatusType,AcctAuthentic,UserService,FramedProtoc
ol,FramedAddress,Acc
tDelayTime) VALUES
(Now(),'22000B44','goofy',7,0,1,1,2,1,'208.209.5.81',606)

ODBC: SQLExecDirect Error -1053:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Index or
primary key can't contai
n a null value.

Resp Time: 40 Auth: 0/0 -> 0 Acct: 0/9/0 -> 9

I notice the the names of the parameters sent back by the
Livingston PM3 (ComOS 3.7.2c3) don't match the names that
RadiusNT is using. Is that a problem? Also, I can't find
anywhere to set an accounting delay on the PM3 to stop the
multiple accting records. Can you advise on that or should
I check with Livingston?

Zak Wolfinger - zak@cyberlink.com
Systems Admin - CyberLink, Inc.
(888) PLUG-IN-2