Re: How to stop this?

Dale E. Reed Jr. ( (no email) )
Tue, 15 Sep 1998 22:50:38 -0700

Edit the calls table (design). Click on the NAS-Port entry and at
the bottom for the default value enter 9999 and save the design.
That will correct the problem.

Scott Lagos wrote:
>
> Running RADIUS 2.2 against a Access Database. Can any one recommend how I
> might go about stopping this type of situation...besides not logging in to
> the PM3? I don't see what would be the null value? (IP numbers have been
> changed for privacy)
>
> Resp Time: 360 Auth: 96/11 -> 107 Acct: 120/1519/0 -> 1639
> radrecv: Request from host 8cba6805 code=4, id=220, length=85
> Acct-Session-Id = "1D000474"
> User-Name = "admin"
> NAS-Identifier = 999.999.999.9
> Acct-Status-Type = Stop
> Acct-Session-Time = 31
> Acct-Authentic = Local
> User-Service = Shell-User
> Login-Service = Telnet
> Login-Host = 998.998.998.998
> Acct-Delay-Time = 223332
>
> SQL Statement: INSERT INTO Calls
> (CallDate,AcctSessionId,UserName,NASIdentifier
> ,AcctStatusType,AcctSessionTime,AcctAuthentic,UserService,LoginService,Login
> Host
> ,AcctDelayTime) VALUES
> (Now(),'1D000474','admin','999.999.999.999',2,31,2,6,0,'998
> .998.998.998',223332)
>
> ODBC: SQLExecDirect Error -1053:
> [Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
> contain
> a Null value.

-- 

Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com