Skip to Content.
Sympa Menu

freetds - Re: FreeTDS 0.52 MSSQL connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ryan D. Hatch" <Ryan AT alpinenetworking.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS 0.52 MSSQL connection problem
  • Date: Fri, 27 Jul 2001 12:54:31 -0600

Title: [freetds] Re: FreeTDS 0.52 MSSQL connection problem
Does anybody have any ideas? This is killing me. I need help!
 
 
Thanks in advance,
Ryan
-----Original Message-----
From: Ryan D. Hatch [mailto:bounce-freetds-133965 AT franklin.oit.unc.edu]On Behalf Of Ryan D. Hatch
Sent: Tuesday, July 24, 2001 10:43 AM
To: TDS Development Group
Subject: RE: [freetds] Re: FreeTDS 0.52 MSSQL connection problem

wow....this is weird.
 
 
so i recompiled tds (using ftp://freetds.internetcds.com/pub/freetds/freetds.snapshot.tgz) into a different dir, then recompiled php to include tds (in the new dir), and here is what happens.
 
if i try to connect to baer-test, it works fine. doing a netstat tells me this:
tcp        0      0 ns1:49971 10.0.0.24:ms-sql-s   ESTABLISHED
 
which should be good...right?
 
anyway,
 
I change the ip of baer-test in interfaces to be 10.0.0.22 (our test database server -- development linux box can hit it just fine using freetds .51 or .52)
I stop http
do a netstat (wait till all of the 10.0.0.24 connections die)
    tcp        0      0 ns1:49963 10.0.0.24:ms-sql-s   TIME_WAIT
they die
start http
go to site
view data that only
netstat
tcp        0      0 ns1:49971 10.0.0.24:ms-sql-s   ESTABLISHED
 
my mssq_pconnect is calling the interface called baer-test! when i change it to another interface, i get a page cannot be displayed error.
 
Ideas?
 
Ryan
-----Original Message-----
From: Brian Bruns
Sent: Tue 7/24/2001 5:21 AM
To: TDS Development Group
Cc:
Subject: [freetds] Re: FreeTDS 0.52 MSSQL connection problem

Well, it definately should not be caching.  Please try a recent CVS
snapshot as there were some bugs in the interfaces file stuff with 0.52.

For those interested, some of the code was moved and getservbyname() was
unitentially called before all the values from gethostbyname() were copied
off, and since the socket stuff uses a static are to return these values,
it worked on some machine and not others...

Brian

On Tue, 24 Jul 2001, Ryan D. Hatch wrote:

> I am running RH 7.1 with Apache 1.3.20, PHP 4.0.6, and FreeTDS 0.52 and
> I have compiled with the following configure command;


> ./configure --prefix=/opt/freetds-.052 --with-tdsver=4.2


> I have an interfaces file that looks like this,

> #
> JDBC
>         query tcp tds5.0 192.138.151.39 4444
>         master tcp tds5.0 192.138.151.39 4444
> myserver
>         query tcp ether 127.0.0.1 4000
>         master tcp ether 127.0.0.1 4000

> baer-test
>         query tcp tds4.2 10.0.0.24 1433
> baer
>         query tcp tds4.2 10.0.0.24 1433
> anyway, here is the problem i am having. when I try to connect to baer
> with tds (using php with mssql_pconnect("baer", "sa", "password")), i am
> unable to do so. However, when I try from a Windows box (connecting to
> that database with the same info), it works just fine. Also, when I try
> with my old version of tds .51 on another box, it too also works....

> but it gets better.

> It appears that it is caching some tds connection information. When
> specify "baer-test", it does work. When I change the interfaces file to
> reflect a different IP for baer-test, it continues to send login
> information, data, etc. to the old IP of baer-test. Even when I restart
> apache i am having this problem.

> Any ideas?


> Thanks in advance,

> Ryan
> ÿÿØ¢æ«yË«­éí—+.nÇ+‰·¶‡ëyë]±«ÿýƦmêÿj+ÿ¢¸ÿN‹§²æìr¸›{÷诫vØb²g¬±¨¶‰^j÷ÿ~·žµÛÿ×m½àÏß­©ä–)ÿ¢+ÿºwÿ
>


---
You are currently subscribed to freetds as: [Ryan AT alpinenetworking.com]
To unsubscribe, forward this message to leave-freetds-133965U AT franklin.oit.unc.edu




Archive powered by MHonArc 2.6.24.

Top of Page