Brian Lube
MPInet
At 05:19 PM 5/29/98 -0500, you wrote:
> I know the problem is that I need to add a default value for the NASPort.
>I have tried and tried to do this in SQL Enterprise Manager, yet every time
>I enter the default value, stop and restart radius it never sees that and
>then I get bombarded with these request. It is like this feature is a
>Borg.... "resistance is futile....".
>
> This is slowing down the response time and causing the Calls Online table
>not to update properly as sometimes the server will be trying to process
>these request for several minutes before the other packets will get through.
>
>
>radrecv: Request from host cff25105 code=4, id=223, length=109
> User-Name = "xxxxxxxxxxxxx"
> NAS-Identifier = 207.242.xxx.xxx
> Acct-Status-Type = Start
> Acct-Session-Id = "xxxxxxxxxxxxx39694"
> Acct-Delay-Time = 170280
> Acct-Authentic = Local
> User-Service = Shell-User
> NAS-Port-Type = 5
> Login-Service = Telnet
> Login-TCP-Port = 1519
> Login-Host = 207.120.51.28
>
> SQL Statement: INSERT INTO Calls
(CallDate,UserName,NASIdentifier,AcctStatusT
>e,AcctSessionId,AcctDelayTime,UserService,NASPortType) VALUES
>(GetDate(),'xxxxxxxxxxxxx','207.242.xxx.xxx',1,'xxxxxxxxxxx',170280,6,5)
>
>ODBC Error:23000:233:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in
table Ca
>s may not be null.
>
>
>Resp Time: 170 Auth: 0/0 -> 0 Acct: 1940/3110/42 -> 5092
>Michael J. Whisenant
>Vice-President, Operations
>AIRnet Internet Services, Inc.
>ph: (256) 704-4692 fax: (256) 704-2329
>