FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Ok,

Out of the frying pan and into the fire...TDS 0.52 has a slight bug in the
freetds.conf handling which means the servername must be all lower
case.  I believe this is fixed in the CVS version, but I am not some place
I can look at the moment.  Try 'desktop' instead of 'DESKTOP' and give it
a go.

Regarding the default port number, 4000 is choosen as a default for
protocol version 5.0, 1433 is choosen for 4.2 or 7.0.  So, if you didn't
specify --with-tdsver in the configure, the default is 5.0 and thus port
4000.  This of course only applys as a fallback if no server entry is
found (such as the lowercase bug here, it is not finding the proper
section of the freetds.conf file).

Cheers,

Brian

On Sun, 23 Sep 2001, Scott Gregory wrote:

> Thanks for your quick response.  I think I have fixed my PWD and
> freetds.conf file. They now look like:
> PWD:
> UID=sa
> PWD=sybase
> SRV=DESKTOP
> DB=freetds
>  
> freetds.conf added:
> [DESKTOP]
>         host = 10.10.10.101
>         port = 1433
>         tds version = 4.2
>  
>  
> Desktop is the name of the machine with the SQL server database.  I have
> once again included a tcpdump when the check is running.  Important IPs
> are 10.10.10.1 (DNS box), 10.10.10.199 (FreeTDS box), 10.10.10.101 (SQL
> Server box).
>  
> You mentioned that 4000 is the compile time default.  If the problem is
> freetds not going to the correct port, how do I change this?
>  
> tcpdump is at the end of the email.
>  
> Thanks again,
>  
> Scott
>  
>  
> On Sun, 23 Sep 2001, Brian Bruns wrote:
>  
> > SRV in the PWD file refers to the symbolic name listed in the
> freetds.conf
> > or interfaces file, not to a host name.
> > 
> > So in this case, it is defaults to using the server name as a host when
> it
> > doesn't find one, however the default port (4000...compile time
> > default) is wrong for your server 
> > 
> > Brian
> > 
>  
> tcpdump:
>  
> 17:19:03.581320 arp who-has 10.10.10.1 tell 10.10.10.199
> 17:19:03.581585 arp reply 10.10.10.1 is-at 0:80:29:ed:d1:43
> 17:19:03.581601 10.10.10.199.1498 > 10.10.10.1.53:  7756+ A? DESKTOP (47)
> 17:19:03.582979 10.10.10.1.53 > 10.10.10.199.1498:  7756* 1/1/1 (100)
> 17:19:03.588059 arp who-has 10.10.10.101 tell 10.10.10.199
> 17:19:03.588473 arp reply 10.10.10.101 is-at 0:60:67:22:94:50
> 17:19:03.588483 10.10.10.199.1238 > 10.10.10.101.4000: S
> 4210426565:4210426565(0) win 16384 <mss 1460> (DF)
> 17:19:03.588920 10.10.10.101.4000 > 10.10.10.199.1238: R 0:0(0) ack

> 4210426566 win 0
> 17:19:03.628279 10.10.10.199.1499 > 10.10.10.1.53:  22236+ A? DESKTOP (47)
> 17:19:03.629424 10.10.10.1.53 > 10.10.10.199.1499:  22236* 1/1/1 (100)
> 17:19:03.634365 10.10.10.199.1239 > 10.10.10.101.4000: S
> 3727191628:3727191628(0) win 16384 <mss 1460> (DF)
> 17:19:03.634784 10.10.10.101.4000 > 10.10.10.199.1239: R 0:0(0) ack
> 3727191629 win 0
> 17:19:03.673366 10.10.10.199.1500 > 10.10.10.1.53:  34356+ A? DESKTOP (47)
> 17:19:03.674589 10.10.10.1.53 > 10.10.10.199.1500:  34356* 1/1/1 (100)
> 17:19:03.679567 10.10.10.199.1240 > 10.10.10.101.4000: S
> 3728083822:3728083822(0) win 16384 <mss 1460> (DF)
> 17:19:03.679975 10.10.10.101.4000 > 10.10.10.199.1240: R 0:0(0) ack
> 3728083823 win 0
> 17:19:03.719186 10.10.10.199.1501 > 10.10.10.1.53:  13096+ A? DESKTOP (47)
> 17:19:03.720343 10.10.10.1.53 > 10.10.10.199.1501:  13096* 1/1/1 (100)
> 17:19:03.725295 10.10.10.199.1241 > 10.10.10.101.4000: S
> 3170400325:3170400325(0) win 16384 <mss 1460> (DF)
> 17:19:03.725709 10.10.10.101.4000 > 10.10.10.199.1241: R 0:0(0) ack
> 3170400326 win 0
> 17:19:03.764898 10.10.10.199.1502 > 10.10.10.1.53:  27664+ A? DESKTOP (47)
> 17:19:03.766032 10.10.10.1.53 > 10.10.10.199.1502:  27664* 1/1/1 (100)
> 17:19:03.771157 10.10.10.199.1242 > 10.10.10.101.4000: S
> 2880386328:2880386328(0) win 16384 <mss 1460> (DF)
> 17:19:03.771604 10.10.10.101.4000 > 10.10.10.199.1242: R 0:0(0) ack
> 2880386329 win 0
> 17:19:03.810390 10.10.10.199.1503 > 10.10.10.1.53:  40856+ A? DESKTOP (47)
> 17:19:03.811513 10.10.10.1.53 > 10.10.10.199.1503:  40856* 1/1/1 (100)
> 17:19:03.816605 10.10.10.199.1243 > 10.10.10.101.4000: S
> 3570813403:3570813403(0) win 16384 <mss 1460> (DF)
> 17:19:03.817018 10.10.10.101.4000 > 10.10.10.199.1243: R 0:0(0) ack
> 3570813404 win 0
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>