[freetds] OpenSSL, Sql Server 2000

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Oct 20 10:21:09 EDT 2006


> 
> 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




More information about the FreeTDS mailing list