FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

I'd reccomend turning on logging (see the User Guide under advanced 
configurations and append mode), to see what is going on when it happens.  
If you can grab the pid of the apache child, you can match that up in the 
log.

Brian

On Sun, 7 Jul 2002 cris-freetds AT dsnet.net wrote:

> I've been having some inexplicable problems on one of my new boxes running
> PHP 4.2.1 and FreeTDS 0.53. It is a newly configured box running Linux 2.4
> and Apache 1.3.12.
> 
> My PHP is configured as follows:
> 
> './configure' '--with-pgsql' '--with-apxs=/usr/local/apache/bin/apxs'
> '--with-mysql' '--enable-sessions' '--with-xml'
> '--with-sybase=/usr/local/freetds'
> 
> FreeTDS is configured as follows:
> 
> ./configure --with-tdsver=4.2
> 
> Note that I initially compiled with 7.0 and had even worse luck. We don't
> need any of the enhanced features of 7.0 (like varchar>255, etc) for this
> so it doesn't matter.
> 
> We have several nearly identical configured machines connecting via
> FreeTDS 0.53 to SQL Server 7 via LAN successfully. I have another newly
> configured box running Apache 1.3.26, everything else (including configure
> lines) the same. This box is also failing.
> 
> The problem is that connections are frequently timing out, causing the
> page to exceed max execution time. Reloading after a failure generally
> fixes the problem, so its intermittent, about 50% of the time. It appears
> the common thread between the two servers is PHP 4.2.1. I fell back on an
> older version of FreeTDS to verify it was still acting up, and it in fact
> was. I saw plenty of threads in rhe archive about people having various
> problems with PHP 4.2.1 and FreeTDS, but I didn't catch anything like this
> - intermittent timeouts.
> 
> I've checked the obvious things such as network connectivity, reverse DNS,
> etc, and everything seems to be okay. Any ideas?
> 
> Thanks,
> 
> Cris
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>