Skip to Content.
Sympa Menu

freetds - Re: [freetds] OpenSSL, Sql Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] OpenSSL, Sql Server 2000
  • Date: Fri, 20 Oct 2006 16:21:09 +0200

>
> Hi,
>
> I have an MS SQL Server 2000, with a certificate. We are successfully
> connecting with encryption from .NET clients, but I can't seem to get
> things working with FC5 / freetds 0.64 / unixODBC 2.2.11. I also tried
> with freetds 0.65.dev.20061016.
>
> When I compile using "--with-openssl", the connection hangs at
> process_login_tokens(). If I switch to protocol version 7.0,
> things work
> again using the same credentials (but of course not encrypted). What's
> going on here?
>
> Thanks in advance for any help.
> -Kurt
>
> 17:18:01.709610 31444 (net.c:1165):handshake succeeded!!
> 17:18:01.709699 31444 (write.c:134):tds_put_string converting
> 8 bytes of
> "(name of client machine)"
> 17:18:01.709789 31444 (write.c:162):tds_put_string wrote 16 bytes
> 17:18:01.709828 31444 (write.c:134):tds_put_string converting
> 8 bytes of
> "(username)"
> 17:18:01.709861 31444 (write.c:162):tds_put_string wrote 16 bytes
> 17:18:01.709893 31444 (write.c:134):tds_put_string converting
> 4 bytes of
> "TSQL"
> 17:18:01.709926 31444 (write.c:162):tds_put_string wrote 8 bytes
> 17:18:01.709955 31444 (write.c:134):tds_put_string converting 10 bytes
> of "(name of server from freetds.conf)"
> 17:18:01.709987 31444 (write.c:162):tds_put_string wrote 20 bytes
> 17:18:01.710016 31444 (write.c:134):tds_put_string converting 11 bytes
> of "TDS-Library"
> 17:18:01.710047 31444 (write.c:162):tds_put_string wrote 22 bytes
> 17:18:01.710077 31444 (write.c:134):tds_put_string converting 10 bytes
> of "us_english"
> 17:18:01.710107 31444 (write.c:162):tds_put_string wrote 20 bytes
> 17:18:01.710137 31444 (write.c:162):tds_put_string wrote 0 bytes
> 17:18:01.710468 31444 (token.c:312):tds_process_login_tokens()

strange.

Could you try to change src/tds/login.c changing number below

/* encryption, normal */

comment from 0 to 1 ?
It just tell to use high encryption, perhaps from SP4 is a requirement.
Could you also post a dump (for instance using ethereal or other tool)
using .NET clients?

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page