(RADIATOR) SQL Server Connection Handling

[Mike McCauley]

On Wed, 28 Aug 2002 08:32, Hugh Irvine wrote:
> Hello Dan -
>
> I would have to suggest that you use a more sensible database.

Of course that there might be other reasons that prevent you from doing that.

I am a bit puzzled though: I would normally expect Radiator to attempt to 
reconnect and have another go after failing to execute that query the first 
time?

Perhaps if you send more the the trace file we might see if that is happening?

Cheers.

>
> 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.

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X etc etc

===
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.