wow....this is weird.
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
