Skip to Content.
Sympa Menu

freetds - RE: AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: AW: [freetds] connect problem to mssql 7.0
  • Date: Tue, 16 Dec 2003 16:59:49 +0100

>
> > B)
> > Confirm that by now you have tried a recent snapshot of
> FreeTDS 0.62,
> > and if so, what's it dated? It's my understanding that
> Freddy fixed for
> > you a possible infinite loop recently; this could change your error
> > from an execution timeout to something else. Or was Freddy just
> >thinking out loud and not actually committing a change? :)
>
> I have to change this also, now I use FreeTDS 0.61.
>

Yes, you have to...

> > D)
> > Is there some reason for using mssql_pconnect() instead of
> > mssql_connect? The non-persistent connections might prove
> to be more
> > reliable - actually they always are in our experience,
> regardless of
> > what kind of database is in use (mysql included).
>
> > Even if you have a good reason for using pconnect, can't you just
> > change it to mssql_connect() for a test and see if it worked?
>
> Mssql_pconnect, we have some queries where we get information
> about customer info, e.g. for customer search, or customer
> offerts, there for I think mssql_pconnect is the right way.
>
> I will try mssql_connect.
>
> Roland
>

Well, using mssql_connect perhaps resolve the problem however it's just
a workaround.

I finally find the time for a complete test
- downloaded apache 1.3.29 and php 4.3.4
- untared apache
- configured and installed apache
./configure --prefix=$HOME/install --enable-module=so --with-port=8081
&& make && make install
- untared php
- configured and installed php
./configure --with-apxs=$HOME/install/bin/apxs --enable-ftp
--with-pear --with-mssql=$HOME/install --prefix=$HOME/install
make && make install
- added .php files to apache
- limited apache processes to 2
- disabled user/group in httpd.conf (so I don't need root access)
- configured server (created a "test" database with "test" user and
"test" password)
- configured server in ~/freetds.conf ("testserver")
- configured dump in ~/freetds.conf ("dump file" as $HOME/freetds.log,
"dump file append" as "yes")
- started apache
- copied your script and changed query ("select name as Name from
sysobjects") and configurations
- launched script some 3/4 times (successfully)
- waited 1/2 hour
- launched script some 3/4 times (successfully)
- waited 1 hour
- launched script some 3/4 times (successfully)

There seem to be no problem at all...

At the same time I open a tsql connect and did query ("select
@@version") waiting 1/2 hour and 1 hour... all successfully, connection
was never broken.

"netstat -anp" always confirm the right connections (when a new httpd
instance init a new connection is opened)

If you can update FreeTDS to CVS/snapshot version and configure using
correct TDS version I'll be glad to see your results...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page