(RADIATOR) SQL Server Connection Handling

[Hugh Irvine]

Hello Dan -

I would have to suggest that you use a more sensible database.

This mail is copied to Mike for his comments.

regards

Hugh


On Wednesday, August 28, 2002, at 01:13 AM, Dan Melomedman wrote:

> Mike McCauley wrote:
>> Its a first for me too.
>> I could conceive of a 'DisconnectAfterQuery' flag that would 
>> disconnect after
>> every SQL query was finished, but Im reluctant to add it since I dont 
>> think
>> it would be widely useful, and when it was used it would significantly 
>> slow
>> things down.
>
> Performance is not an issue for us right now, since we barely get a few
> dozen authentications per day.
>
>> Do I understand from the below that you are connecting to MS-SQL from 
>> Radiator
>> running on a FreeBSD box?
>>
>> We havent heard of similar behaviour, even from FreeBSD to MS-SQL. It 
>> is
>> possible that using keep-alives or similar might alleviate the problem?
>>
>> Cheers.
>
> The problem is our MS SQL Server 7.0 (yuck!), service pack 2 drops 
> connections if
> they're idle for a long enough time:
>
> Tue Aug 13 09:39:24 2002: ERR: do failed for 'insert into failedattempts
> (LoggedAt,User_Name,NAS_IP_Address,Caller_ID,NAS_Port,Failure_Message,
> Active_Handler) values ('2002-08-13 
> 09:39:24.000','soconnell','10.0.2.201','',
> '29374','''Bad Password''','prodnetilla')': Server message number=10018 
> severity=9 state=0 line=0
> server=OpenClient text=The connection was closed
>
> I am just looking for a a quick work-around. MS' site actually has a 
> blurb about configuring time-outs
> for DB connections, but we couldn't find such an option at least for our
> service pack.
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.