Working well so far on i386 connecting to MS Server 2008. Tested it
using tsql and py-odbc.
Thanks,
Ryan
On Wed, Sep 8, 2010 at 3:27 AM, Stuart Henderson <s...@spacehopper.org> wrote:
> if anyone's using freetds, please test and report back.
>
> Index: Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/Makefile,v
> retrieving revision 1.37
> diff -u -p -r1.37 Makefile
> --- Makefile 1 Sep 2010 09:17:42 -0000 1.37
> +++ Makefile 8 Sep 2010 10:26:53 -0000
> @@ -3,11 +3,10 @@
> COMMENT= database drivers for Sybase/Microsoft SQL Server
>
> V= 0.82
> -PATCHVER= 20090903
> +PATCHVER= 20100728
> DISTNAME= freetds-$V
> PKGNAME= ${DISTNAME}.1pre${PATCHVER}
> -REVISION= 0
> -PATCHFILES= freetds-post82-${PATCHVER}.diff.fixed.gz:0
> +PATCHFILES= freetds-post82-${PATCHVER}.diff.gz:0
>
> SHARED_LIBS += ct 4.0 # .4.0
> SHARED_LIBS += sybdb 6.0 # .5.0
> @@ -16,6 +15,8 @@ SHARED_LIBS += tdsodbc 0.0
> CATEGORIES= databases
>
> HOMEPAGE= http://www.freetds.org/
> +# or, if they lunch out the dns registration again:
> +# http://freetds.schemamania.org/
>
> # GPLv2+
> PERMIT_PACKAGE_CDROM= Yes
> @@ -40,6 +41,9 @@ LIB_DEPENDS= ::databases/iodbc,-main \
> FLAVORS= msdblib
> FLAVOR?=
>
> +# requires database server
> +REGRESS_IS_INTERACTIVE=Yes
> +
> USE_LIBTOOL= Yes
> CONFIGURE_STYLE= gnu
> CONFIGURE_ARGS= ${CONFIGURE_SHARED} \
> @@ -71,7 +75,6 @@ post-install:
> ${PREFIX}/share/examples/freetds/pool.conf-sample
> �...@cd ${PREFIX}/lib && ln -s libtdsodbc.so.${LIBtdsodbc_VERSION} \
> libtdsodbc.so
> - @mv ${PREFIX}/share/doc/freetds-$V.1.dev.20090930 \
> - ${PREFIX}/share/doc/freetds
> + @mv ${PREFIX}/share/doc/freetds-* ${PREFIX}/share/doc/freetds
>
> .include <bsd.port.mk>
> Index: distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/distinfo,v
> retrieving revision 1.14
> diff -u -p -r1.14 distinfo
> --- distinfo 10 Oct 2009 14:16:55 -0000 1.14
> +++ distinfo 8 Sep 2010 10:26:53 -0000
> @@ -1,10 +1,10 @@
> MD5 (freetds-0.82.tar.gz) = Pfay6D/UIOkPG+y9EWKZCg==
> -MD5 (freetds-post82-20090903.diff.fixed.gz) = LK7ChN+bZmxituREsHTxyw==
> +MD5 (freetds-post82-20100728.diff.gz) = YJ7BviKjCBBZJy1gea+taQ==
> RMD160 (freetds-0.82.tar.gz) = 01lsUSAiMyzbO6s3WVAVnx6TCks=
> -RMD160 (freetds-post82-20090903.diff.fixed.gz) = FNzHR4oYLGFhr4GOX1lnL2zeVp8=
> +RMD160 (freetds-post82-20100728.diff.gz) = eQaj378lJgQ4v/fUM+t+L+/16Mo=
> SHA1 (freetds-0.82.tar.gz) = fioMnkHCQMLRx/acbyeOmlu4DC0=
> -SHA1 (freetds-post82-20090903.diff.fixed.gz) = Oa3Ou0XIRhlaZEYJoRutg2mlmds=
> +SHA1 (freetds-post82-20100728.diff.gz) = 0qS3IUiLJCKd7ynJbCj5OaRNc4A=
> SHA256 (freetds-0.82.tar.gz) = 4nMUg2FL2ZLIyxM7zDhDLeE8+iQ8wTJ/N0EttQyZsrY=
> -SHA256 (freetds-post82-20090903.diff.fixed.gz) =
> uPcIKi1tcovRwWjm7p4tFKd9wt1g4PY+jin17qRJYBk=
> +SHA256 (freetds-post82-20100728.diff.gz) =
> F3mBqPzDxMYQG3ePydi5Foy2dU4Oss5X303+IYjmlLo=
> SIZE (freetds-0.82.tar.gz) = 1596755
> -SIZE (freetds-post82-20090903.diff.fixed.gz) = 117703
> +SIZE (freetds-post82-20100728.diff.gz) = 57888
> Index: patches/patch-Makefile_in
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/patches/patch-Makefile_in,v
> retrieving revision 1.7
> diff -u -p -r1.7 patch-Makefile_in
> --- patches/patch-Makefile_in 11 Oct 2009 16:33:36 -0000 1.7
> +++ patches/patch-Makefile_in 8 Sep 2010 10:26:53 -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-Makefile_in,v 1.7 2009/10/11 16:33:36 ajacoutot Exp $
> ---- Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ Makefile.in Sun Oct 11 18:21:53 2009
> -@@ -688,13 +688,6 @@ uninstall-info: uninstall-info-recursive
> +--- Makefile.in.orig Wed May 7 23:59:24 2008
> ++++ Makefile.in Wed Sep 8 09:44:27 2010
> +@@ -687,13 +687,6 @@ uninstall-info: uninstall-info-recursive
>
>
> install-data-local:
> Index: patches/patch-configure
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/patches/patch-configure,v
> retrieving revision 1.5
> diff -u -p -r1.5 patch-configure
> --- patches/patch-configure 11 Oct 2009 16:33:36 -0000 1.5
> +++ patches/patch-configure 8 Sep 2010 10:26:53 -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-configure,v 1.5 2009/10/11 16:33:36 ajacoutot Exp $
> ---- configure.orig Sun Oct 11 18:27:25 2009
> -+++ configure Sun Oct 11 18:28:01 2009
> -@@ -22997,8 +22997,8 @@ cat >>confdefs.h <<\_ACEOF
> +--- configure.orig Wed May 7 23:59:26 2008
> ++++ configure Wed Sep 8 09:44:27 2010
> +@@ -22578,8 +22578,8 @@ cat >>confdefs.h <<\_ACEOF
> #define HAVE_GNUTLS 1
> _ACEOF
>
> Index: patches/patch-odbc_unittests_Makefile_in
> ===================================================================
> RCS file:
> /cvs/ports/databases/freetds/patches/patch-odbc_unittests_Makefile_in,v
> retrieving revision 1.5
> diff -u -p -r1.5 patch-odbc_unittests_Makefile_in
> --- patches/patch-odbc_unittests_Makefile_in 11 Oct 2009 16:33:36 -0000
> 1.5
> +++ patches/patch-odbc_unittests_Makefile_in 8 Sep 2010 10:26:53 -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-odbc_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36
> ajacoutot Exp $
> ---- src/odbc/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ src/odbc/unittests/Makefile.in Sun Oct 11 18:21:53 2009
> -@@ -1015,7 +1015,7 @@ check-am: all-am
> +--- src/odbc/unittests/Makefile.in.orig Wed May 7 23:59:20 2008
> ++++ src/odbc/unittests/Makefile.in Wed Sep 8 09:44:27 2010
> +@@ -1006,7 +1006,7 @@ check-am: all-am
> check: check-am
> all-am: Makefile
> installdirs:
> Index: patches/patch-src_ctlib_unittests_Makefile_in
> ===================================================================
> RCS file:
> /cvs/ports/databases/freetds/patches/patch-src_ctlib_unittests_Makefile_in,v
> retrieving revision 1.5
> diff -u -p -r1.5 patch-src_ctlib_unittests_Makefile_in
> --- patches/patch-src_ctlib_unittests_Makefile_in 11 Oct 2009 16:33:36
> -0000 1.5
> +++ patches/patch-src_ctlib_unittests_Makefile_in 8 Sep 2010 10:26:53
> -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-src_ctlib_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36
> ajacoutot Exp $
> ---- src/ctlib/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ src/ctlib/unittests/Makefile.in Sun Oct 11 18:21:53 2009
> -@@ -736,7 +736,7 @@ check-am: all-am
> +--- src/ctlib/unittests/Makefile.in.orig Wed May 7 23:59:18 2008
> ++++ src/ctlib/unittests/Makefile.in Wed Sep 8 09:44:27 2010
> +@@ -735,7 +735,7 @@ check-am: all-am
> check: check-am
> all-am: Makefile
> installdirs:
> Index: patches/patch-src_dblib_unittests_Makefile_in
> ===================================================================
> RCS file:
> /cvs/ports/databases/freetds/patches/patch-src_dblib_unittests_Makefile_in,v
> retrieving revision 1.5
> diff -u -p -r1.5 patch-src_dblib_unittests_Makefile_in
> --- patches/patch-src_dblib_unittests_Makefile_in 11 Oct 2009 16:33:36
> -0000 1.5
> +++ patches/patch-src_dblib_unittests_Makefile_in 8 Sep 2010 10:26:53
> -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-src_dblib_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36
> ajacoutot Exp $
> ---- src/dblib/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ src/dblib/unittests/Makefile.in Sun Oct 11 18:21:53 2009
> -@@ -785,7 +785,7 @@ check-am: all-am
> +--- src/dblib/unittests/Makefile.in.orig Wed May 7 23:59:19 2008
> ++++ src/dblib/unittests/Makefile.in Wed Sep 8 09:44:27 2010
> +@@ -784,7 +784,7 @@ check-am: all-am
> check: check-am
> all-am: Makefile
> installdirs:
> Index: patches/patch-src_pool_Makefile_in
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/patches/patch-src_pool_Makefile_in,v
> retrieving revision 1.4
> diff -u -p -r1.4 patch-src_pool_Makefile_in
> --- patches/patch-src_pool_Makefile_in 11 Oct 2009 16:33:36 -0000 1.4
> +++ patches/patch-src_pool_Makefile_in 8 Sep 2010 10:26:53 -0000
> @@ -1,7 +1,7 @@
> $OpenBSD: patch-src_pool_Makefile_in,v 1.4 2009/10/11 16:33:36 ajacoutot Exp
> $
> ---- src/pool/Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ src/pool/Makefile.in Sun Oct 11 18:21:53 2009
> -@@ -530,10 +530,7 @@ uninstall-am: uninstall-binPROGRAMS uninstall-info-am
> +--- src/pool/Makefile.in.orig Wed May 7 23:59:21 2008
> ++++ src/pool/Makefile.in Wed Sep 8 09:44:27 2010
> +@@ -529,10 +529,7 @@ uninstall-am: uninstall-binPROGRAMS uninstall-info-am
>
>
> install-data-local:
> Index: patches/patch-src_tds_unittests_Makefile_in
> ===================================================================
> RCS file:
> /cvs/ports/databases/freetds/patches/patch-src_tds_unittests_Makefile_in,v
> retrieving revision 1.5
> diff -u -p -r1.5 patch-src_tds_unittests_Makefile_in
> --- patches/patch-src_tds_unittests_Makefile_in 11 Oct 2009 16:33:36 -0000
> 1.5
> +++ patches/patch-src_tds_unittests_Makefile_in 8 Sep 2010 10:26:53 -0000
> @@ -1,6 +1,6 @@
> $OpenBSD: patch-src_tds_unittests_Makefile_in,v 1.5 2009/10/11 16:33:36
> ajacoutot Exp $
> ---- src/tds/unittests/Makefile.in.orig Sun Oct 11 18:21:53 2009
> -+++ src/tds/unittests/Makefile.in Sun Oct 11 18:21:53 2009
> +--- src/tds/unittests/Makefile.in.orig Wed May 7 23:59:22 2008
> ++++ src/tds/unittests/Makefile.in Wed Sep 8 09:44:27 2010
> @@ -198,7 +198,7 @@ INSTALL_STRIP_PROGRAM = @INSTALL_STRIP_PROGRAM@
> LDFLAGS = @LDFLAGS@
> LIBICONV = @LIBICONV@
> @@ -10,7 +10,7 @@ $OpenBSD: patch-src_tds_unittests_Makefi
> LIBTOOL = @LIBTOOL@
> LN_S = @LN_S@
> LTLIBICONV = @LTLIBICONV@
> -@@ -624,7 +624,7 @@ check-am: all-am
> +@@ -623,7 +623,7 @@ check-am: all-am
> check: check-am
> all-am: Makefile
> installdirs:
> Index: pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/freetds/pkg/PLIST,v
> retrieving revision 1.15
> diff -u -p -r1.15 PLIST
> --- pkg/PLIST 10 Oct 2009 14:16:55 -0000 1.15
> +++ pkg/PLIST 8 Sep 2010 10:26:53 -0000
> @@ -181,8 +181,83 @@ ${DOC}/reference/tab_r.gif
> ${DOC}/reference/tabs.css
> ${DOC}/reference/todo.html
> ${DOC}/userguide/
> +${DOC}/userguide/about.htm
> +${DOC}/userguide/aboutunicode.htm
> +${DOC}/userguide/acknowledgments.htm
> +${DOC}/userguide/advocacy.htm
> +${DOC}/userguide/apireference.htm
> +${DOC}/userguide/appendmode.htm
> +${DOC}/userguide/askingforhelp.htm
> +${DOC}/userguide/build.htm
> +${DOC}/userguide/choosingtdsprotocol.htm
> +${DOC}/userguide/config.htm
> +${DOC}/userguide/configs.htm
> +${DOC}/userguide/confirminstall.htm
> +${DOC}/userguide/contrib.htm
> +${DOC}/userguide/contributors.htm
> +${DOC}/userguide/ctlib.api.summary.htm
> +${DOC}/userguide/dblib.api.summary.htm
> +${DOC}/userguide/domains.htm
> +${DOC}/userguide/dsnless.htm
> +${DOC}/userguide/envvar.htm
> +${DOC}/userguide/freetdsconf.htm
> +${DOC}/userguide/freetdshistory.htm
> +${DOC}/userguide/gfdl-1.htm
> +${DOC}/userguide/gfdl-10.htm
> +${DOC}/userguide/gfdl-11.htm
> +${DOC}/userguide/gfdl-2.htm
> +${DOC}/userguide/gfdl-3.htm
> +${DOC}/userguide/gfdl-4.htm
> +${DOC}/userguide/gfdl-5.htm
> +${DOC}/userguide/gfdl-6.htm
> +${DOC}/userguide/gfdl-7.htm
> +${DOC}/userguide/gfdl-8.htm
> +${DOC}/userguide/gfdl-9.htm
> +${DOC}/userguide/gfdl.htm
> +${DOC}/userguide/help.htm
> ${DOC}/userguide/index.htm
> ${DOC}/userguide/index.html
> +${DOC}/userguide/install.htm
> +${DOC}/userguide/interfacesfile.htm
> +${DOC}/userguide/interfacesformat.htm
> +${DOC}/userguide/interfaceslocation.htm
> +${DOC}/userguide/interfacespurpose.htm
> +${DOC}/userguide/iso8859.htm
> +${DOC}/userguide/locales.htm
> +${DOC}/userguide/localization.htm
> +${DOC}/userguide/logging.htm
> +${DOC}/userguide/mailinglist.htm
> +${DOC}/userguide/odbc.api.summary.htm
> +${DOC}/userguide/odbcconnattr.htm
> +${DOC}/userguide/odbcdiagnose.htm
> +${DOC}/userguide/odbcinionly.htm
> +${DOC}/userguide/odbcombo.htm
> +${DOC}/userguide/osissues.htm
> +${DOC}/userguide/packages.htm
> +${DOC}/userguide/pagenodata.htm
> +${DOC}/userguide/perl.htm
> +${DOC}/userguide/php.htm
> +${DOC}/userguide/portoverride.htm
> +${DOC}/userguide/prepodbc.htm
> +${DOC}/userguide/programming.htm
> +${DOC}/userguide/projects.htm
> +${DOC}/userguide/python.htm
> +${DOC}/userguide/samplecode.htm
> +${DOC}/userguide/seemtooslow.htm
> +${DOC}/userguide/serverthere.htm
> +${DOC}/userguide/software.htm
> +${DOC}/userguide/stunnel.htm
> +${DOC}/userguide/sybsql.htm
> +${DOC}/userguide/tdshistory.htm
> +${DOC}/userguide/tdspool.htm
> +${DOC}/userguide/troubleshooting.htm
> +${DOC}/userguide/unicode.htm
> +${DOC}/userguide/unicodefreetds.htm
> +${DOC}/userguide/unicodegoodbad.htm
> +${DOC}/userguide/unicodeutf.htm
> +${DOC}/userguide/usefreetds.htm
> +${DOC}/userguide/userguide.css
> +${DOC}/userguide/what.htm
> share/examples/freetds/
> share/examples/freetds/freetds.conf-sample
> �...@sample ${SYSCONFDIR}/freetds.conf
>
>
--
Thanks,
Ryan
