Skip to Content.
Sympa Menu

freetds - RE: [freetds] Tsql hangs during login

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Flickema, Drew W." <drew.flickema AT hp.com>
  • To: <brian AT bruns.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: RE: [freetds] Tsql hangs during login
  • Date: Wed, 22 Dec 2004 11:28:33 -0800

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




Archive powered by MHonArc 2.6.24.

Top of Page