At 06:07 PM 5/29/98 -0500, you wrote:
>Brian,
>
> 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
>
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329