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: Brian Bruns <brian.bruns AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Tsql hangs during login
  • Date: Wed, 22 Dec 2004 10:27:38 -0500

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
>




Archive powered by MHonArc 2.6.24.

Top of Page