FreeTDS 0.52 MSSQL connection problem

Ryan D. Hatch Ryan at alpinenetworking.com
Tue Jul 24 12:42:45 EDT 2001


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
	

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8054 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20010724/8cd46386/attachment.bin 


More information about the FreeTDS mailing list