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,'209.16.226.104')
>
> 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. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com