(RADIATOR) SQL Server Connection Handling

[Mike McCauley]

Hi Dan,

OK,

here is a new version of SqlDb.pm that implements a new DisconnectAfterQuery 
flag. This will cause AuthBy SQL and other SQL users to disconnect after 
every SQL 'do' and after every 'getOneRow'.

Let me know how you go.

Cheers.

On Fri, 30 Aug 2002 05:11, Dan Melomedman wrote:
> Mike McCauley wrote:
> > 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.
>
> Here's what happens:
>
> 1) If the server has been writing to MSSQL server frequently, no problems.
> 2) If the server has not written anything over TCP connection to MSSQL
> in quite a long while, the server is blocked. Any subsequent
> requests to the server fail. This is the last thing in the log before a
> block:
>
> Wed Aug 28 18:58:52 2002 707093: DEBUG: do query is: insert into
> failedattempts
> (LoggedAt,User_Name,NAS_IP_Address,Caller_ID,NAS_Port,Failure_Message,
> Active_Handler) values ('2002-08-28
> 18:58:52.000','dan','203.63.154.1','987654321','1234','''Bad
> Password''', 'prodnetilla') .
>
> I suspect a problem may be with FreeTDS libraries, DBD::Sybase, or MSSQL
> server itself. Unfortunately I can't use a different database for
> logging for beauraucratical reasons.
>
> A connect-log-disconnect feature would be a quick fix for this. It would
> also allow some people simple load balancing with round-robin DNS to
> boot.

-- 
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SqlDb.pm
Type: text/x-perl
Size: 9016 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020830/c2a3681e/attachment.bin>