We have talked about this before. Here is what I have done. I went into
Enterprise Manager to the Database-table-calls and in the Default for
NASPort I typed 9999 and exited out. It asked to save, which I said
yes.... then I went back and the default shows (9999). I have three
entries for the last month (3 out of probable 1000 logins) and the rest are
just running rampant.... I physically see the default is set, yet I wonder
is there a script that can be run that reports the default value? If so I
would like to run this and make sure.
At 06:31 PM 5/29/98 -0400, you wrote:
>Make sure that you have the default value for NASPort in the _calls_ table.
> I personally set it to (9999) in order for it to have a default. This
>should clear this up quite nicely from my experience.
>
>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
>>
>
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329