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: Tue, 24 Jul 2001 10:42:45 -0600

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


<<winmail.dat>>




Archive powered by MHonArc 2.6.24.

Top of Page