Re: Accounting:Calls Table

Dale E. Reed Jr. ( (no email) )
Sat, 27 Dec 1997 06:55:58 -0800

Accounting wrote:
> Ok I am recv Acc packets, however there is one problem. When RadiusNT
> tries to insert data into the Calls Table it wont put the NASIdentifier in
> to the table and as this is part of the Primary Key and a part (i assume)
> of the CallsOnLine Query. Here is the SQL from RadiusNT as you can see
> there is no NASIdentifier or even an IPAddress to fill in to the
> NASIdentifier field thus the error.
> SQL Statement: INSERT INTO Calls
> (CallDate,UserName,NASPort,AcctStatusType,Acct
> DelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,FramedAddress) VALUES
> (Now(
> ),'vivian',20110,1,18,'251993465',1,1,'')
> ODBC: SQLExecDirect Error -1053:
> [Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
> contain
> a Null value.

What does the accounting packet look like right above this that
you receive from the NAS? What kind of NAS do you have?

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |