[freetds] TSQL times out

Joel West joel at joelwest.com
Thu Aug 19 12:42:32 EDT 2004


I think Im dealing with a Gonzo MSSQL admin mostly..

I am now getting:

[root at yaknars bin]# ./tsql -H FS6PARIS -S 192.168.100.2 -p 1433 -U 
ss_userid
locale is "en_US"
locale charset is "ISO-8859-1"
Password:
src/tds/login.c: tds_connect: 192.168.100.2:4000: 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



On Thu, 19 Aug 2004, James Vanns wrote:

> I don't know if this helps but is the server using domain or local
> authentication? Have you setup freetds.conf up to reflect the correct
> authentication mechanism?
>
> Regards
>
> Jim
>
> On Thu, 2004-08-19 at 16:33, Joel West wrote:
>> I need to qualify that I have confirmed the user name and password.
>>
>> On Thu, 19 Aug 2004, Joel West wrote:
>>
>>> I am using an RPM version of freetds to connect to an MS SQL databse from a
>>> redhat linux box:
>>>
>>> The RPMs are:
>>>
>>> freetds-0.62.1-1
>>> freetds-devel-0.62.1-1
>>> freetds-unixodbc-0.62.1-1
>>>
>>>
>>> In the freetds.conf:
>>>
>>> # A typical Microsoft SQL Server 7.0 configuration
>>> [MyServer70]
>>>        host = 192.168.100.2
>>>        port = 1433
>>>        tds version = 4.2
>>>
>>>
>>> I can telnet to the server port 1433
>>>
>>> I tried to diagnose a PERL problem with tsql:
>>>
>>> Using tsql I get:
>>>
>>> [root at yaknars etc]# tsql -H 192.168.100.2 -p 1433 -U ss_username
>>> locale is "en_US"
>>> locale charset is "ISO-8859-1"
>>> Password:
>>> Msg 18456, Level 14, State 1, Server , Line 0
>>> Login failed for user 'ss_username'.
>>> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
>>> Login incorrect.
>>> There was a problem connecting to the server
>>>
>>> And the log file:
>>>
>>> Starting log file for FreeTDS 0.62.1
>>> 	on 2004-08-19 06:03:18 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 "ISO-8859-1" character set
>>> 06:03:18.881908 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
>>> 06:03:18.881955 Connecting to 192.168.100.2 port 1433, TDS 4.2.
>>> Sending packet @ 06:03:18.882356
>>> 0000 02 00 02 00 00 00 00 00-79 61 6b 6e 61 72 73 00 |........ yaknars.|
>>> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0020 00 00 00 00 00 00 07 73-73 5f 75 73 65 72 6e 61 |.......s s_userna|
>>> 0030 6d 65 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |me...... ........|
>>> 0040 00 00 00 00 00 0b 73 73-5f 75 73 65 72 6e 61 6d |......ss _usernam|
>>> 0050 65 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |e....... ........|
>>> 0060 00 00 00 00 0b 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
>>> 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 02 00 |........ ........|
>>> 0090 00 00 00 00 54 53 51 4c-00 00 00 00 00 00 00 00 |....TSQL ........|
>>> 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 00b0 00 00 04 31 39 32 2e 31-36 38 2e 31 30 30 2e 32 |...192.1 68.100.2|
>>> 00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 00d0 00 0d 73 73 5f 75 73 65-72 6e 61 6d 65 00 00 00 |..ss_use rname...|
>>> 00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>>> 01d0 00 0b 04 02 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
>>> 01e0 0a 00 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
>>> 01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|
>>>
>>>
>>> Sending packet @ 06:03:18.882805
>>> 0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... ........|
>>> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f |........ .....iso|
>>> 0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... ........|
>>> 0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
>>> 0040 00 00 00 03 00 00 00 00-00 00 00 00             |........ ....|
>>>
>>>
>>> 06:03:18.882902 tds_process_login_tokens()
>>> Received header @ 06:03:18.883449
>>> 0000 04 01 00 44 00 00 01 00-                        |...D....|
>>>
>>>
>>> Received packet @ 06:03:18.883488
>>> 0000 aa 30 00 18 48 00 00 01-0e 24 00 4c 6f 67 69 6e |0..H... .$.Login|
>>> 0010 20 66 61 69 6c 65 64 20-66 6f 72 20 75 73 65 72 | failed  for user|
>>> 0020 20 27 73 73 5f 75 73 65-72 6e 61 6d 65 27 2e 00 | 'ss_use rname'..|
>>> 0030 00 00 00 fd 02 00 00 00-00 00 00 00             |....... ....|
>>>
>>>
>>> 06:03:18.883560 looking for login token, got  aa(ERROR)
>>> 06:03:18.883588 tds_process_default_tokens() marker is aa(ERROR)
>>> tds_get_string: reading 36 from wire to give 36 to client.
>>> 06:03:18.883708 looking for login token, got  fd(DONE)
>>> 06:03:18.883752 tds_process_default_tokens() marker is fd(DONE)
>>> 06:03:18.883787 tds_process_end: more_results = 0
>>> 		was_cancelled = 0
>>> 		error = 1
>>> 		done_count_valid = 0
>>> 06:03:18.883825 tds_process_end() state set to TDS_IDLE
>>> 06:03:18.883849 leaving tds_process_login_tokens() returning 0
>>> 06:03:18.883959 tds_client_msg: #20014: "Login incorrect.".  Connection state
>>> is now 2.
>>>
>>
>> ______________________________________________________________________
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> --
> James Vanns BSc (Hons) MCP
> Senior Software Engineer (Linux / C & C++)
> Canterbury Christ Church University College
> Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list