Skip to Content.
Sympa Menu

freetds - Re: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Stefan Carstens" <s.carstens AT coolspot.de>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 + PHP 4.0.6 + freetds 0.53 during queries
  • Date: Sat, 10 Nov 2001 11:18:22 +0100


Thank you, I'll take it and send you the results as soon as possible, at
least on tuesday.


----- Original Message -----
From: "Brian Bruns" <camber AT ais.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Saturday, November 10, 2001 3:32 AM
Subject: [freetds] Re: Problem with MSSQL Server 2000 SP1 / Apache 1.3.20 +
PHP 4.0.6 + freetds 0.53 during queries


>
> Ok, I've added some code to help debug this. Grab a copy from CVS. In
> the freetds.conf file turn on the option 'dump file append' like so:
>
> [global]
> ...
> dump file = /tmp/freetds.log
> dump file append = yes
> ...
>
> Change /tmp/freetds.log to wherever you need to put it. If you have
> multiple databases and only want to do this for one, then put it in the
> database section instead.
>
> This will cause all apache children to append onto the same log file.
>
> Now, in addition to the normal caveat of passwords showing up (I'm working
> on a patch for that one by the way), the peformance hit of opening the
> log file every time we need to write to it is unknown but likely will have
> some impact. Also, the log file is likely to grow quite large.
>
> So, what I would recommend is to flip the switch, stress test it until it
> breaks, then revert the conf file and send me the resultant logs off-list.
> Then we should be able to better trace what is causing the problem.
>
> Also, send me the pid number of the crashed child.
>
> Cheers,
>
> Brian
>
> On Fri, 9 Nov 2001, Stefan Carstens wrote:
>
> > Hi out there,
> > The problem occurs only sometimes but it does an entry in the apache
error_log
> >
> > Error: 104 (Connection reset by peer) TDS: Write failed in
tds_write_packet"
> >
> > If we use pconnect, the problems comes up more often, than with the use
of a "normal" connect !
> > The webserver is a Mandrake Linux 8.0 System, Apache 1.3.20 + PHP 4.0.6
with FreeTDS 0.53.
> >
> > PHP was configured this way :
> >
./configure --with-apxs --enable-versioning --enable-trans-sid --without-mys
ql --enable-track-vars --enable-sysvsem --enable-sysvshm --enable-
> >
sockets --with-zlib=/usr/local/ --with-apxs --with-curl=/usr/local/lib --wit
h-sybase=/usr/local/sqlserver
> >
> > Apache was compiled with support for SSL.
> >
> > FreeTDS was compiled
with --prefix=/usr/local/sqlserver --with-tdsver=7.0
> >
> > The MS SQL Server is a 2000 SP1 running on a 2000 Server SP2.
> >
> > Both maschines are IBM xSeries 330 with 2 x PIII 866 and 512 MB RAM.
> >
> >
> > MS's Query Analyzer runs perfectly, so all other tools do, only the
combination mentioned above make problems.
> >
> > Thanks in advance,
> > Stefan
> >
> >
> > ---
> > You are currently subscribed to freetds as: [camber AT ais.org]
> > To unsubscribe, forward this message to
$subst('Email.Unsub')
> >
>
>
>
>
>
> ---
> You are currently subscribed to freetds as: [s.carstens AT coolspot.de]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page