Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 07 Apr 2017 08:56:58 +0000
From:      bugzilla-noreply@freebsd.org
To:        freebsd-ports-bugs@FreeBSD.org
Subject:   [Bug 218454] databases/freetds: cannot connect to MS SQL Server 2008 after upgrade to 1.00.27,1
Message-ID:  <bug-218454-13@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D218454

            Bug ID: 218454
           Summary: databases/freetds: cannot connect to MS SQL Server
                    2008 after upgrade to 1.00.27,1
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: bofh@freebsd.org
          Reporter: 000.fbsd@quip.cz
             Flags: maintainer-feedback?(bofh@freebsd.org)
          Assignee: bofh@freebsd.org

databases/freetds and php56-mssql worked for us for many years but it failed
after last upgrade to freetds-1.00.27,1. Previous version (freetds-1.00.1,1)
works fine.

# tsql -S MSSQLsrv -p 1433 -D JBDATA -U user -P pass
locale is "C"
locale charset is "US-ASCII"
using default charset "cp1250"
Setting JBDATA as default database in login packet
Error 20017 (severity 9):
        Unexpected EOF from the server
Error 20002 (severity 9):
        Adaptive Server connection failed
There was a problem connecting to the server


; freetds.conf
[MSSQLsrv]
        host =3D 10.20.30.40
        port =3D 1433
        tds version =3D 8.0
        client charset =3D cp1250


The failing connection is to Windows Server 2003 R2 SP2 / MS SQL Server 2008

Connection to other machine with Windows Server 2012 R2 / MS SQL Server 2014
works fine.

freetds was build on our poudriere machine 10.3 amd64.=20

Info about resulting package

pkg info freetds-1.00.27,1
freetds-1.00.27,1
Name           : freetds
Version        : 1.00.27,1
Installed on   : Fri Mar 31 15:03:53 2017 CEST
Origin         : databases/freetds
Architecture   : FreeBSD:10:amd64
Prefix         : /usr/local
Categories     : databases
Licenses       : GPLv2
Maintainer     : bofh@FreeBSD.org
WWW            : http://www.freetds.org/
Comment        : Sybase/Microsoft TDS protocol library
Options        :
        DOCS           : off
        GNUTLS         : off
        IODBC          : off
        MARS           : off
        OPENSSL        : on
        UNIXODBC       : on
Shared Libs required:
        libcrypto.so.9
        libodbc.so.2
        libodbcinst.so.2
        libssl.so.9
        libgcrypt.so.20
Shared Libs provided:
        libtdsodbc.so.0
        libsybdb.so.5
        libct.so.4

I don't know how to fix it.=20
Please let me know I you need some more details.

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-218454-13>