Re: Cannot connect to MS SQL 2008 server from OS X using FreeTDS
Randy Syring <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Paul,
I'd recommend using the |TDSDUMPCONFIG option. It seems to me you
aren't even hitting the server.
|
---------------------------------------------
Randy Syring
Development& Executive Director
Level 12 Technologies <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913
Principled People, Technology that Works
On 04/09/2012 03:14 PM, Paul Wuersig wrote:
> I've also set up iODBC and added the FreeTDS and server information to
> odbc.ini and odbcinst.ini.
>
> Running a python script that uses pyodbc yields the error:
> pyodbc.Error: ('00000', '[00000] [iODBC][Driver Manager]dlopen({SQL
> Server}, 6): image not found (0) (SQLDriverConnect)')
>
>
> [Frediano]
>
> Did you enable OpenSSL or GnuTLS?
>
>
> [Paul]
>
> No, I didn't realize those were potentially necessary. Is there a way to
> query the DB to find out?
>
> [Randy]
>
> <turn on logging!>
>
> [Paul]
>
> $ TDSDUMP=/tmp/freetds.log tsql -H hqnvogl02 -p 1433 -U restuser
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> Password:
> Msg 20017, Level 9, State -1, Server OpenClient, Line -1
> Unexpected EOF from the server
> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
> Adaptive Server connection failed
> There was a problem connecting to the server
>
> --
>
> The salient part of the log is, I believe:
> token.c:312:tds_process_login_tokens()
> util.c:334:tdserror(0x7fe251400b10, 0x7fe251401170, 20017, 36)
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
>
>
> Thanks,
> Paul
>
>
> Full log follows (server and user names redacted in packet):
>
>
> $ cat /tmp/freetds.log
> log.c:190:Starting log file for FreeTDS 0.82
> on 2012-04-09 14:00:52 with debug flags 0x4fff.
> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> iconv.c:197:names for UTF-8: UTF-8
> iconv.c:197:names for UCS-2LE: UCS-2LE
> iconv.c:197:names for UCS-2BE: UCS-2BE
> iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
> iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
> net.c:210:Connecting to 172.20.148.45 port 1433 (TDS version 5.0)
> net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:303:tds_open_socket() succeeded
> util.c:162:Changed query state from DEAD to IDLE
> net.c:779:Sending packet
> 0000 02 00 02 00 00 00 00 00-6d 6f 6e 65 00 00 00 00 |........ XXXX....|
> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0020 00 00 00 00 00 00 04 72-65 73 74 75 73 65 72 00 |.......X XXXXXXX.|
> 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0040 00 00 00 00 00 08 61 70-70 6c 65 00 00 00 00 00 |......XX XXX.....|
> 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 0060 00 00 00 00 05 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 00 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 68 71 6e 76 6f-67 6c 30 32 00 00 00 00 |...XXXXX XXXX....|
> 00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
> 00d0 00 09 00 05 61 70 70 6c-65 00 00 00 00 00 00 00 |.....XXX X.......|
> 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 07 05 00 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
> 01e0 0a 05 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...... ........|
>
> net.c:779:Sending packet
> 0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a.... ........|
> 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-e2 16 00 01 09 00 08 0e |........ ?.......|
> 0050 6d 7f ff ff ff fe 02 09-00 00 00 00 02 68 00 00 |m.????.. .....h..|
> 0060 00 - |.|
>
> token.c:312:tds_process_login_tokens()
> util.c:334:tdserror(0x7fe251400b10, 0x7fe251401170, 20017, 36)
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:389:tdserror: returning TDS_INT_CANCEL(2)
> util.c:162:Changed query state from IDLE to DEAD
> token.c:316:looking for login token, got 0()
> token.c:108:tds_process_default_tokens() marker is 0()
> token.c:111:leaving tds_process_default_tokens() connection dead
> util.c:334:tdserror(0x7fe251400b10, 0x7fe251401170, 20002, 0)
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:389:tdserror: returning TDS_INT_CANCEL(2)
> mem.c:563:tds_free_all_results()
>
>
>
> On 4/6/12 9:52 PM, "Randy Syring"<[email protected]> wrote:
>
>> Google "freetds logging" and dump info about the connection using that
>> info
>> to help diagnose the problem.
>>
>> ---------------------------------------------
>> Randy Syring (sent from my mobile)
>> Development& Executive Director
>> Level 12 Technologies
>> Direct: 502-276-0459
>> Office: 502-212-9913
>>
>> Principled People, Technology that Works
>> On Apr 6, 2012 7:51 PM, "Paul Wuersig"<[email protected]> wrote:
>>
>>> The basic error looks like so:
>>>
>>> $ tsql -H<hostname> -p 1433 -U<user>
>>> Password:
>>> locale is "en_US.UTF-8"
>>> locale charset is "UTF-8"
>>> using default charset "UTF-8"
>>> Error 20017 (severity 9):
>>> Unexpected EOF from the server
>>> OS error 36, "Operation now in progress"
>>> Error 20002 (severity 9):
>>> Adaptive Server connection failed
>>> There was a problem connecting to the server
>>>
>>> This is identical to the error from using tsql to connect to *any* open
>>> port!
>>>
>>> Connecting with "-S<server> -U<user>", or connecting to any closed
>>> port,
>>> produces error 20009:
>>> Error 20009 (severity 9):
>>> Unable to connect: Adaptive Server is unavailable or does not
>>> exist
>>> OS error 61, "Connection refused"
>>>
>>> I can connect to the server just fine using MS SQL Server Management
>>> Studio on Windows XP.
>>>
>>> I've tried other MS-SQL servers, which produce the same errors.
>>>
>>> I've tried FreeTDS 0.82, 0.91, and freetds-0.92.dev.20120312 (latest).
>>> Same errors on all of them (although the errors are printed slightly
>>> differently in 0.82).
>>>
>>> I've tried 0.92 with "MS db-lib source compatibility" enabled, with the
>>> same results.
>>>
>>> The server has an entry in /usr/local/etc/freetds.conf. I've tried tds
>>> version 0, 5.0, 7.0, 7.1, 7.2, and 8.0, with the same results.
>>>
>>> I've Googled this extensively, and I've tried essentially all the things
>>> people have suggested for similar errors.
>>>
>>> This is on a Mac running 10.7.3.
>>>
>>> Suggestions, or things to try, or more information I can give that might
>>> prove fruitful, are all appreciated!
>>>
>>> Thanks,
>>> Paul
>>>
>>>
>>>
>>> -------------------------------------------------------------------------
>>> ----------
>>> This email message is for the sole use of the intended recipient(s) and
>>> may contain
>>> confidential information. Any unauthorized review, use, disclosure or
>>> distribution
>>> is prohibited. If you are not the intended recipient, please contact
>>> the
>>> sender by
>>> reply email and destroy all copies of the original message.
>>>
>>>
>>> -------------------------------------------------------------------------
>>> ----------
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>