Skip to Content.
Sympa Menu

freetds - [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: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Tsql hangs during login
  • Date: Tue, 21 Dec 2004 16:52:59 -0800


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




Archive powered by MHonArc 2.6.24.

Top of Page