FreeTDS Development Group

["Flickema, Drew W." <drew.flickema AT hp.com>]

Thank you for the explanation, perfect.  I discovered port 2048 was
available for TCP connections.



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Brian Bruns
Sent: Wednesday, December 22, 2004 7:28 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Tsql hangs during login


Port 445 is SMB (so called named pipes), FreeTDS doesn't support this
networking option and is unlikely to until there is a good LGPL (or
other compatibly licensed) smb library for *nix.

You'll probably want to use port 1039 under SQL 2k.  If that doesn't
work, get your admin to configure the server for TCP connections.

Brian

On Tue, 21 Dec 2004 16:52:59 -0800, Flickema, Drew W.
<drew.flickema AT hp.com> wrote:
> 
> I am running stable version 0.62.4 on Debian (woody).  I have the 
> unixODBC and unixODBC-dev packages installed.  I am attempting to 
> connect to SQLserver 8.0
> 
> >From the {prefix}/bin directory I run tsql as
> ./tsql -H db -p 445 -U sa
> 
> Here is the output
> 
> locale is "C"
> locale charset is "ANSI_X3.4-1968"
> Password:
> 
> And it hangs here forever after typing the correct 
> password.....finally will timeout and yield
> 
> Msg 20004, Level 9, State 0, Server OpenClient, Line 0
> Read from SQL server failed.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server
> 
> The login user/pass pair is correct as I have verified it several 
> times using the Microsoft SQL client tools, DBAMgr2K, or WinSQL.  If I

> use one of these three apps to connect to the db server, netstat on my

> Windows box shows that I have established a connection to remote port 
> 445.  nmap results of the remote host also shows port 445 as open.
> 
> Forcing tsql to port 1433 yields the following.....
> 
> locale is "C"
> locale charset is "ANSI_X3.4-1968"
> Password:
> src/tds/login.c: tds_connect: xx.xx.x.xx:1443: Connection refused Msg 
> 20009, Level 9, State 0, Server OpenClient, Line 0 Server is 
> unavailable or does not exist. There was a problem connecting to the 
> server
> 
> Telnet xx.xx.x.x 445
> Trying xx.xx.x.xx...
> Connected to xx.xx.x.xx.
> Escape character is '^]'.
> 
> /tmp/freetds.log
> Starting log file for FreeTDS 0.62.4
>         on 2004-12-21 16:09:13 with debug level 99.
> names for ISO-8859-1: ISO-8859-1
> names for UTF-8: UTF-8
> names for UCS-2LE: UCS-2LE
> names for UCS-2BE: UCS-2BE
> iconv to convert client-side data to the "ANSI_X3.4-1968" character 
> set 16:09:13.089734 tds_iconv_info_init: converting 
> "US-ASCII"->"UCS-2LE" 16:09:13.090939 tds_iconv_info_init: converting 
> "ISO-8859-1"->"UCS-2LE" 16:09:13.091005 Connecting to xx.xx.x.xx port 
> 445, TDS 8.0. 16:09:13.125617 tds_put_string converting 9 bytes of 
> "{localhostname}" 16:09:13.125720 tds_put_string wrote 18 bytes 
> 16:09:13.125751 tds_put_string converting 8 bytes of "sa" 
> 16:09:13.125783 tds_put_string wrote 16 bytes 16:09:13.125818 
> tds_put_string converting 4 bytes of "TSQL" 16:09:13.125851 
> tds_put_string wrote 8 bytes 16:09:13.125879 tds_put_string converting

> 3 bytes of "db" 16:09:13.125911 tds_put_string wrote 6 bytes
> 16:09:13.125939 tds_put_string converting 11 bytes of "TDS-Library"
> 16:09:13.125971 tds_put_string wrote 22 bytes
> 16:09:13.126000 tds_put_string converting 10 bytes of "us_english"
> 16:09:13.126061 tds_put_string wrote 20 bytes
> 16:09:13.126091 tds_put_string wrote 0 bytes
> 16:09:13.126195 tds_process_login_tokens()
> 16:33:47.137506 goodread: errno=104, "Connection reset by peer"
> 16:33:47.137692 tds_client_msg: #20004: "Read from SQL server
failed.".
> Connection state is now 0.
> 16:33:47.137766 looking for login token, got  0()
> 16:33:47.137798 tds_process_default_tokens() marker is 0()
> 16:33:47.137829 leaving tds_process_default_tokens() connection dead
> 16:33:47.137878 tds_client_msg: #20014: "Login incorrect.".
Connection
> state is now 4.
> 
> Export TDSDUMPCONFIG=/tmp/tnsdump.log
> 
> Starting log file for FreeTDS 0.62.4
>         on 2004-12-21 16:09:13 with debug level 99. 16:09:13.072179 
> Attempting to read conf files. 16:09:13.072244 ...$FREETDSCONF not 
> set.  Trying $FREETDS/etc. 16:09:13.072275 ...$FREETDS not set.  
> Trying $HOME. 16:09:13.073464 Found conf file 
> '/usr/local/freetds/etc/freetds.conf'
> (default).
>  Reading section 'db'.
> 16:09:13.073528 Looking for section global.
> 16:09:13.073634 ... Found section global.
> 16:09:13.073664 Got a match.
> 16:09:13.073695 option = 'tds version' value = '8.0'. 16:09:13.073757 
> option = 'dump file' value = '/tmp/freetds.log'. 16:09:13.073793 
> option = 'debug level' value = '10'. 16:09:13.073840 option = 'text 
> size' value = '64512'. 16:09:13.073906 ... Found section db.
> 16:09:13.073992 Looking for section db.
> 16:09:13.074059 ... Found section global.
> 16:09:13.074157 ... Found section db.
> 16:09:13.074185 Got a match.
> 16:09:13.074213 option = 'host' value = 'xx.xx.x.xx'.
> 16:09:13.074242 Found host entry xx.xx.x.xx.
> 16:09:13.074292 IP addr is xx.xx.x.xx.
> 16:09:13.074345 option = 'port' value = '445'.
> 16:09:13.074380 option = 'tds version' value = '8.0'.
> 16:09:13.074451 ...Success.
> 16:09:13.074505 tds_config_login:474: client_charset is
ANSI_X3.4-1968.
> 
> When I built freetds, I only provided the --prefix option
> 
> Thanks for your suggestions,
> Drew Flickema
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org 
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds