SQL Error when RadiusNT authenticates using Access 97

Danny Sinang ( (no email) )
Sat, 28 Jun 1997 21:49:23 -0000

I am using RadiusNT 1.16.60 on NT4 w/ SP3.

I ran RadiusNT w/ the -x15 -o option and I was authenticated when I dialed
in. Problem is, there also appeared the following error:

----------------------------------------------------------------------------

--------------------------------------------------------
INSERT INTO Calls ( CallDate, AcctStatusType, UserName ) Values ( Now(), 1,
'sinang' )

ODBC SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 97 Driver ]
Index or primary key can't contain a null value.
Sending Accounting Ack of id 3 to 7f000001 (localhost)

----------------------------------------------------------------------------

---------------------------------------------------------

So I looked into the Calls table and saw that 4 fields ( NASIdentifier,
NASPort, AcctSessionID, AcctStatusType ) were declared as primary keys.

However, as the error message shows, only one of them - AcctStatusType -
gets assigned a value.

Is this a bug or is there something I missed ?

And by the way, I also noticed that if I failed to configure RadiusNT
correctly ( in ODBC mode ) and I :

1.try dialing in, and
2. no authentication takes place, and
3. I terminate the connection try ( from the client side ), and
4. I try to dial in again

I run out of buffers !! What's wrong here ?

- Danny Sinang