[Bug 261967] database/freetds fail to connect ms sql server on FreeBSD-13-Stable (2022/02)

From: <bugzilla-noreply_at_freebsd.org>
Date: Tue, 15 Feb 2022 10:20:32 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=261967

            Bug ID: 261967
           Summary: database/freetds fail to connect ms sql server on
                    FreeBSD-13-Stable (2022/02)
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: jsc@ntu.edu.tw

After some tests, I suspect the openssl 1.1.1m on FreeBSD-13-Stable (2022/02)
prevent freetds from connecting to microsoft sql server 2019.

Command:
setenv TDSDUMP /tmp/freetds.log
tsql -S host -U username -P password

tail /tmp/freetds.log
tls.c:130:in tds_pull_func_login
tls.c:130:in tds_pull_func_login
tls.c:130:in tds_pull_func_login
tls.c:1065:handshake succeeded!!
login.c:1053:quietly sending TDS 7+ login packet
token.c:418:tds_process_login_tokens()

Failed scenarios:
FreeBSD-13-Stable (2022/02) [openssl 1.1.1m]
1. pkg install freetds (1.3.6,1)
2. make freetds from ports, using default options
3. compile freetds from source, using default options, version ranging from:
0.91, 1.0, 1.1, 1.2.21, 1.3.6, 1.3.9

Successful scenarios:
1. FreeBSD-13-Stable (2022/02) [openssl 1.1.m]
    make freetds from ports, select "GNUTLS"
2. FreeBSD-13-Release [openssl 1.1.k]
    pkg install freetds (1.3.4,1)
3. FreeBSD-12.2-Stable [openssl 1.1.1i]
    pkg install freetds (1.3.4,1)
4. FreeBSD-12.2-Stable [openssl 1.1.1k]
    pkg install freetds (1.3.6)

Thanks for your help.

-- 
You are receiving this mail because:
You are the assignee for the bug.