FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2012/10/10 Todd Brush <brush.todd AT gmail.com>:
> Tremendous thank you goes out to those that have helped me!
>
> Correcting my "It's TDSVER, not TDSERVER" error below, I found that I then
> had to play with the TDS Versions until I found one that worked. I THEN
> discovered that the EasySoft isql and tsql binaries handle domain
> authentication differently than the version I am using with unixODBC and
> FreeTDS. I had to adjust my syntax slightly to escape the interpreted
> backslash, required to specify the Windows domain account.
>
> I was able to successfully run tsql by issuing the following command:
>
> $TDSVER=7.1 /[path/to]/tsql -H [mssqlservername.dnssuffiix.com] -p 1433 -U
> [windowsdomain]\\[domainuseraccount]
>
> I did notice via Wireshark that my domain credentials are passed in clear
> text. Is this avoidable?
>

Only password is encrypted. If you need to encrypt even username and
domain you should consider SSL! But it require TDS 7.2 (that is mssql
2005 at least).

>
> After updating my DSN with "TDS_Version=7.1" I was also able to get isql to
> run successfully by issuing the command:
>
> $ [/path/to]/isql -v [DSN in odbc.ini]
> [windowsdomain]\\[domainuseraccount] [domainpassword]
>
> If I include the user credentials in the DSN in odbc.ini, it still fails
> (though now shows the correct TDS Version now in the log). I will have to
> play with the syntax within odbc.ini to get this to work, or make

We do not support such configurations! No UID/PWD on odbc.ini.

Frediano

> environment variables for them to be used on the command line, to obfuscate
> my credentials. Again, a Wireshark shows these credentials as being sent
> clear text over the network.
>
>
> Any thoughts on above, please let me know. Otherwise, thank you again
> everyone for the assistance!
>
>
>
>
>
> On Wed, Oct 10, 2012 at 12:28 PM, Frediano Ziglio <freddy77 AT gmail.com>wrote:
>
>> 2012/10/10 Todd Brush <brush.todd AT gmail.com>:
>> > Thank you, it looks like my login packet is accepted, but immediately
>> > thereafter, the connection drops. Is there anything on the freetds side
>> > that has to be configured for SSL to allow domain authentication to the
>> > MSSQL Server ?
>> >
>> > (username, target server (host & ip), password, and local machine
>> replaced
>> > in commands and log results in [BRACKETS])
>> >
>> >
>> > using TDSDUMP I found the following errors:
>> >
>> >
>> >
>> > $isql -v ServerManager
>> > [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>> > [01000][unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
>> > [01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
>> > [ISQL]ERROR: Could not SQLConnect
>> >
>> > $less /tmp/freetds.log
>> > log.c:196:Starting log file for FreeTDS 0.91
>> >         on 2012-10-10 11:50:21 with debug flags 0x4fff.
>> > iconv.c:330:tds_iconv_open(0x628320, UTF-8)
>> > iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
>> > iconv.c:187:local name for UTF-8 is UTF-8
>> > iconv.c:187:local name for UCS-2LE is UCS-2LE
>> > iconv.c:187:local name for UCS-2BE is UCS-2BE
>> > iconv.c:349:setting up conversions for client charset "UTF-8"
>> > iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
>> > iconv.c:391:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
>> > iconv.c:394:tds_iconv_open: done
>> > net.c:205:Connecting to [IPADDRESS] port 1433 (TDS version 5.0)
>>
>> 5.0 means only Sybase
>>
>> > net.c:270:tds_open_socket: connect(2) returned "Operation now in
>> progress"
>> > net.c:310:tds_open_socket() succeeded
>> > util.c:156:Changed query state from DEAD to IDLE
>> > net.c:741:Sending packet
>> > 0000 02 00 02 00 00 00 00 00-** ** ** ** ** ** ** ** ** **  |........
>> > [LOCALMACHINE]|
>> > 0010 63 74 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0020 00 00 00 00 00 00 0a 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0040 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0060 00 00 00 00 00 32 39 34-34 00 00 00 00 00 00 00 |.....294 4.......|
>> > 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0080 00 00 00 04 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
>> > 0090 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 00b0 00 00 00 ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
>> > |...[MSSQLSERVER]|
>> > 00c0 32 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |....... ........|
>> > 00d0 00 0e 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 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 02 05 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 01e0 00 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:741: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:328:tds_process_login_tokens()
>> > util.c:331:tdserror(0x625440, 0x628320, 20017, 115)
>> > odbc.c:2270:msgno 20017 20003
>> > util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>> > util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>> > util.c:156:Changed query state from IDLE to DEAD
>> > token.c:337:looking for login token, got  0()
>> > token.c:122:tds_process_default_tokens() marker is 0()
>> > token.c:125:leaving tds_process_default_tokens() connection dead
>> > login.c:466:login packet accepted
>> > util.c:331:tdserror(0x625440, 0x628320, 20002, 0)
>> > odbc.c:2270:msgno 20002 20003
>> > util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>> > util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>> > mem.c:615:tds_free_all_results()
>> > error.c:412:odbc_errs_add: "Unable to connect to data source"
>> > error.c:585:SQLError((nil), 0x6270e0, (nil), 0x7fffe70138e0,
>> > 0x7fffe70138f4, 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:517:SQLGetDiagRec(2, 0x6270e0, 1, 0x7fffe70138e0, 0x7fffe70138f4,
>> > 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:566:SQLGetDiagRec: "[FreeTDS][SQL Server]Unexpected EOF from the
>> > server"
>> > error.c:585:SQLError((nil), 0x6270e0, (nil), 0x7fffe70138e0,
>> > 0x7fffe70138f4, 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:517:SQLGetDiagRec(2, 0x6270e0, 1, 0x7fffe70138e0, 0x7fffe70138f4,
>> > 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:566:SQLGetDiagRec: "[FreeTDS][SQL Server]Adaptive Server
>> connection
>> > failed"
>> > error.c:585:SQLError((nil), 0x6270e0, (nil), 0x7fffe70138e0,
>> > 0x7fffe70138f4, 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:517:SQLGetDiagRec(2, 0x6270e0, 1, 0x7fffe70138e0, 0x7fffe70138f4,
>> > 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:566:SQLGetDiagRec: "[FreeTDS][SQL Server]Unable to connect to
>> data
>> > source"
>> > error.c:585:SQLError((nil), 0x6270e0, (nil), 0x7fffe70138e0,
>> > 0x7fffe70138f4, 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > error.c:517:SQLGetDiagRec(2, 0x6270e0, 1, 0x7fffe70138e0, 0x7fffe70138f4,
>> > 0x7fffe70133c0, 513, 0x7fffe70138fe)
>> > odbc.c:4040:SQLFreeConnect(0x6270e0)
>> > odbc.c:4006:_SQLFreeConnect(0x6270e0)
>> > odbc.c:4063:SQLFreeEnv(0x624080)
>> > odbc.c:4050:_SQLFreeEnv(0x624080)
>> >
>> >
>> > $TDSERVER=7.2 ./tsql -H [MSSQLSERVER] -p 1433 -U [USERID]
>>
>> It's TDSVER, not TDSERVER.
>>
>> > 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 115, "Operation now in progress"
>> > Error 20002 (severity 9):
>> >         Adaptive Server connection failed
>> > There was a problem connecting to the server
>> >
>> >
>> > $less /tmp/freetds.log
>> > log.c:196:Starting log file for FreeTDS 0.91
>> >         on 2012-10-10 11:53:13 with debug flags 0x4fff.
>> > iconv.c:330:tds_iconv_open(0x644350, UTF-8)
>> > iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
>> > iconv.c:187:local name for UTF-8 is UTF-8
>> > iconv.c:187:local name for UCS-2LE is UCS-2LE
>> > iconv.c:187:local name for UCS-2BE is UCS-2BE
>> > iconv.c:349:setting up conversions for client charset "UTF-8"
>> > iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
>> > iconv.c:391:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
>> > iconv.c:394:tds_iconv_open: done
>> > net.c:205:Connecting to 10.1.2.137 port 1433 (TDS version 5.0)
>>
>> Still 5.0 (for the typo above I think).
>>
>> > net.c:270:tds_open_socket: connect(2) returned "Operation now in
>> progress"
>> > net.c:310:tds_open_socket() succeeded
>> > util.c:156:Changed query state from DEAD to IDLE
>> > net.c:741:Sending packet
>> > 0000 02 00 02 00 00 00 00 00-** ** ** ** ** ** ** ** ** **  |........
>> > [LOCALMACHINE]|
>> > 0010 63 74 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |...... ........|
>> > 0020 00 00 00 00 00 00 0a ** ** ** ** ** ** ** ** ** ** ** *
>> > |.......[USERID]...|
>> > 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0040 00 00 00 00 00 ** ** ** ** ** ** ** ** ** ** ** ** ** **
>> > |......********...|
>> > 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0060 00 00 00 00 07 33 30 35-32 00 00 00 00 00 00 00 |.....305 2.......|
>> > 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>> > 0080 00 00 00 04 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 ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
>> > |...[MSSQLSERVER]|
>> > 00c0 32 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |....... ........|
>> > 00d0 00 0e 00 ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
>> > |....*******.....|
>> > 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 09 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:741: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:328:tds_process_login_tokens()
>> > util.c:331:tdserror(0x643c00, 0x644350, 20017, 115)
>> > util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>> > util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>> > util.c:156:Changed query state from IDLE to DEAD
>> > token.c:337:looking for login token, got  0()
>> > token.c:122:tds_process_default_tokens() marker is 0()
>> > token.c:125:leaving tds_process_default_tokens() connection dead
>> > login.c:466:login packet accepted
>> > util.c:331:tdserror(0x643c00, 0x644350, 20002, 0)
>> > util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>> > util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>> > mem.c:615:tds_free_all_results()
>> >
>> >
>> >
>> >
>>
>> Frediano
>>
>> >
>> >
>> > On Wed, Oct 10, 2012 at 8:45 AM, Randy Syring <rsyring AT gmail.com> wrote:
>> >
>> >>  Todd,
>> >>
>> >> I have found TDSDUMP and TDSDUMPCONFIG to be invaluable when
>> >> troubleshooting connection issues:
>> >>
>> >> http://www.freetds.org/userguide/logging.htm
>> >>
>> >> ---------------------------------------------
>> >> Randy Syring
>> >> Development & Executive DirectorLevel 12 Technologies <
>> https://www.lev12.com/>
>> >> Direct: 502-276-0459
>> >> Office: 502-212-9913
>> >>
>> >> Principled People, Technology that Works
>> >>
>> >>  On 10/09/2012 06:11 PM, Todd Brush wrote:
>> >>
>> >> Unfortunately I see limited troubleshooting documentation related to my
>> >> specific problem within the document you referenced. When I check
>> externals
>> >> sources, I find conflicting information, and references to various
>> config
>> >> files that reference each other. I do not understand why this is so
>> >> convoluted!
>> >>
>> >> In testing, tsql works sometimes, and osql does not, then I change a
>> >> configuration and test again, and not tsql does not work at ALL, and
>> osql
>> >> output is further along, but still not successful. Frustration.
>> >>
>> >>
>> >> Please tell me what log files or config files I can send to shed light
>> on
>> >> where I am obviously going wrong. I am trying to connect from a SUSE
>> Linux
>> >> vm to MS SQL 2005 [Microsoft SQL Server 2005 - 9.00.4060.00 (X64)   Mar
>> 17
>> >> 2011 13:06:52   Copyright (c) 1988-2005 Microsoft Corporation
>>  Enterprise
>> >> Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2]
>> >>
>> >> Again, using the (now expired) Easysoft driver, I was able to set this
>> up
>> >> in minutes and use their isql tool to run queries from a bash shell,
>> from
>> >> the exact same vm to the exact same sql server. The problem must lie
>> within
>> >> my freeTDS and or unixODBC configuration. It's not a network/protocol or
>> >> credentials/permissions issue.
>> >>
>> >>
>> >>
>> >> On Sat, Oct 6, 2012 at 2:04 PM, James K. Lowden <jklowden AT freetds.org>
>> <jklowden AT freetds.org>wrote:
>> >>
>> >>
>> >>  On Fri, 5 Oct 2012 16:18:17 -0400
>> >> Todd Brush <brush.todd AT gmail.com> <brush.todd AT gmail.com> wrote:
>> >>
>> >>
>> >>  #cat /usr/local/etc/odbc.ini
>> >> [NICKNAME]
>> >> Driver=FreeTDS
>> >> Description=mssql driver
>> >> Server=hostname.dnssuffix.com
>> >> Port=1433
>> >> User=domain\username
>> >> Password=password
>> >> Database=DBNAME
>> >>
>> >>  http://www.freetds.org/userguide/odbcconnattr.htm
>> >>
>> >> Please read that document again.  Some of what is in your odbc.ini is
>> >> not read by the driver; extra entries are silently ignored.
>> >>
>> >> Remember that specifying "Server" (not "Servername) in odbc.ini lets
>> >> the driver connect without reference to freetds.conf.  osql will show
>> >> you that.
>> >>
>> >> I suspect what's missing is the TDS version.  You don't say how you
>> >> configured FreeTDS or what kind of server you're connecting to.  If you
>> >> didn't change the defaults and you're connecting to a Microsoft server,
>> >> it won't work!
>> >>
>> >> Two other tools at your disposal: osql and TDSDUMP.
>> >>
>> >> HTH.
>> >>
>> >> --jkl
>> >> _______________________________________________
>> >> FreeTDS mailing listFreeTDS AT lists.ibiblio.orghttp://
>> lists.ibiblio.org/mailman/listinfo/freetds
>> >>
>> >>  _______________________________________________
>> >> FreeTDS mailing listFreeTDS AT lists.ibiblio.orghttp://
>> lists.ibiblio.org/mailman/listinfo/freetds
>> >>
>> >>
>> >>
>> >>
>> > _______________________________________________
>> > 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
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds