From owner-freebsd-apache@FreeBSD.ORG Wed Jan 2 21:11:59 2013 Return-Path: Delivered-To: apache@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id D99C72E2 for ; Wed, 2 Jan 2013 21:11:59 +0000 (UTC) (envelope-from mi+thun@aldan.algebra.com) Received: from smtp02.lnh.mail.rcn.net (smtp02.lnh.mail.rcn.net [207.172.157.102]) by mx1.freebsd.org (Postfix) with ESMTP id 98DB5336 for ; Wed, 2 Jan 2013 21:11:59 +0000 (UTC) Received: from mr16.lnh.mail.rcn.net ([207.172.157.36]) by smtp02.lnh.mail.rcn.net with ESMTP; 02 Jan 2013 16:11:59 -0500 Received: from smtp04.lnh.mail.rcn.net (smtp04.lnh.mail.rcn.net [207.172.157.104]) by mr16.lnh.mail.rcn.net (MOS 4.3.4-GA) with ESMTP id CDY96201; Wed, 2 Jan 2013 16:11:57 -0500 X-Auth-ID: anat Received: from 209-6-63-29.c3-0.sbo-ubr1.sbo.ma.cable.rcn.com (HELO utka.zajac) ([209.6.63.29]) by smtp04.lnh.mail.rcn.net with ESMTP; 02 Jan 2013 16:11:57 -0500 Message-ID: <50E4A29D.4020204@aldan.algebra.com> Date: Wed, 02 Jan 2013 16:11:57 -0500 From: "Mikhail T." User-Agent: Mozilla/5.0 (X11; FreeBSD i386; rv:14.0) Gecko/20120808 Thunderbird/14.0 MIME-Version: 1.0 To: apache@FreeBSD.org Subject: Fixes for apr-util's FreeTDS driver Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: Garrett Rooney X-BeenThere: freebsd-apache@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Support of apache-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Jan 2013 21:11:59 -0000 Hello! I've made the FreeTDS-driver work again -- and submitted the patch to Apache: https://issues.apache.org/bugzilla/show_bug.cgi?id=53666 The developers are a little slow to pick it up -- perhaps, because few people use Sybase (or MS SQL) with Apache -- but it is quite usable. Can I add the patch to our devel/apr1 port? Thanks! Yours, -mi From owner-freebsd-apache@FreeBSD.ORG Wed Jan 2 22:11:55 2013 Return-Path: Delivered-To: apache@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id C51D8DBD for ; Wed, 2 Jan 2013 22:11:55 +0000 (UTC) (envelope-from ohauer@FreeBSD.org) Received: from p578be941.dip0.t-ipconnect.de (p578be941.dip0.t-ipconnect.de [87.139.233.65]) by mx1.freebsd.org (Postfix) with ESMTP id 7E182786 for ; Wed, 2 Jan 2013 22:11:55 +0000 (UTC) Received: from [192.168.0.100] (cde1100.uni.vrs [192.168.0.100]) (Authenticated sender: ohauer) by p578be941.dip0.t-ipconnect.de (Postfix) with ESMTPSA id C678620901; Wed, 2 Jan 2013 23:11:39 +0100 (CET) Message-ID: <50E4B0D4.9090802@FreeBSD.org> Date: Wed, 02 Jan 2013 23:12:36 +0100 From: Olli Hauer User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: apache@FreeBSD.org Subject: Re: Fixes for apr-util's FreeTDS driver References: <50E4A29D.4020204@aldan.algebra.com> In-Reply-To: <50E4A29D.4020204@aldan.algebra.com> X-Enigmail-Version: 1.4.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: Garrett Rooney , "Mikhail T." X-BeenThere: freebsd-apache@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Support of apache-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Jan 2013 22:11:55 -0000 On 2013-01-02 22:11, Mikhail T. wrote: > Hello! > > I've made the FreeTDS-driver work again -- and submitted the patch to Apache: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=53666 > > The developers are a little slow to pick it up -- perhaps, because few people use Sybase (or MS SQL) with Apache -- but it is quite usable. Can I add the patch to our devel/apr1 port? Thanks! Yours, > > -mi > Hi Mikhail, patch applies clean on our current devel/apr1 port (apr-util-1.4.1). http://people.freebsd.org/~ohauer/diffs/patch-apr-util-1.4.1__dbd__apr_dbd_freetds.c Maybe the patch finds more notice upstream if shaped against the current apr-util-1.5.1? Do you have also a patch for apr-util-1.5.1 available? I hope the FreeBSD ports infrastructure is full back in near time so an expr-run with the current apr-util can be done. Which FreeTDS port should be used as dependency ? $> grep -i ^freetds /usr/ports/INDEX-8 | cut -d\| -f - freetds-0.64_8,1|/usr/ports/databases/freetds freetds-devel-0.91_3,1|/usr/ports/databases/freetds-devel freetds-msdblib-0.64_8,1|/usr/ports/databases/freetds-msdblib -- Regards, olli From owner-freebsd-apache@FreeBSD.ORG Wed Jan 2 22:20:56 2013 Return-Path: Delivered-To: apache@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 69B841E8; Wed, 2 Jan 2013 22:20:56 +0000 (UTC) (envelope-from mi+thun@aldan.algebra.com) Received: from smtp02.lnh.mail.rcn.net (smtp02.lnh.mail.rcn.net [207.172.157.102]) by mx1.freebsd.org (Postfix) with ESMTP id 52BA47BB; Wed, 2 Jan 2013 22:20:54 +0000 (UTC) Received: from mr16.lnh.mail.rcn.net ([207.172.157.36]) by smtp02.lnh.mail.rcn.net with ESMTP; 02 Jan 2013 17:20:54 -0500 Received: from smtp01.lnh.mail.rcn.net (smtp01.lnh.mail.rcn.net [207.172.4.11]) by mr16.lnh.mail.rcn.net (MOS 4.3.4-GA) with ESMTP id CDZ08847; Wed, 2 Jan 2013 17:20:53 -0500 Received-SPF: None identity=pra; client-ip=209.6.63.29; receiver=smtp01.lnh.mail.rcn.net; envelope-from="mi+thun@aldan.algebra.com"; x-sender="mi+thun@aldan.algebra.com"; x-conformance=sidf_compatible Received-SPF: None identity=mailfrom; client-ip=209.6.63.29; receiver=smtp01.lnh.mail.rcn.net; envelope-from="mi+thun@aldan.algebra.com"; x-sender="mi+thun@aldan.algebra.com"; x-conformance=sidf_compatible Received-SPF: None identity=helo; client-ip=209.6.63.29; receiver=smtp01.lnh.mail.rcn.net; envelope-from="mi+thun@aldan.algebra.com"; x-sender="postmaster@utka.zajac"; x-conformance=sidf_compatible X-Auth-ID: anat Received: from 209-6-63-29.c3-0.sbo-ubr1.sbo.ma.cable.rcn.com (HELO utka.zajac) ([209.6.63.29]) by smtp01.lnh.mail.rcn.net with ESMTP; 02 Jan 2013 17:20:53 -0500 Message-ID: <50E4B2C3.6050703@aldan.algebra.com> Date: Wed, 02 Jan 2013 17:20:51 -0500 From: "Mikhail T." User-Agent: Mozilla/5.0 (X11; FreeBSD i386; rv:14.0) Gecko/20120808 Thunderbird/14.0 MIME-Version: 1.0 To: Olli Hauer Subject: Re: Fixes for apr-util's FreeTDS driver References: <50E4A29D.4020204@aldan.algebra.com> <50E4B0D4.9090802@FreeBSD.org> In-Reply-To: <50E4B0D4.9090802@FreeBSD.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: Garrett Rooney , apache@FreeBSD.org X-BeenThere: freebsd-apache@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Support of apache-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Jan 2013 22:20:56 -0000 On 02.01.2013 17:12, Olli Hauer wrote: > Hi Mikhail, > > patch applies clean on our current devel/apr1 port (apr-util-1.4.1). > http://people.freebsd.org/~ohauer/diffs/patch-apr-util-1.4.1__dbd__apr_dbd_freetds.c > > Maybe the patch finds more notice upstream if shaped against the current apr-util-1.5.1? > Do you have also a patch for apr-util-1.5.1 available? I'm pretty sure, it will apply just as well against 1.5 -- the driver has not changed in years. As currently shipped it is badly broken because the dbd/driver API changed (years ago!) and the FreeTDS-driver only got updated to allow it to /compile/ (but not /work/). The drag is in that very few people use Sybase with Apache -- the products are from two different worlds, so to speak... My client happens to (still) use Vignette for their web-publishing (and Vignette uses Sybase as its own backend), so that's why they were interested -- but it is a rare case... > I hope the FreeBSD ports infrastructure is full back in near time so an expr-run with > the current apr-util can be done. This would be new functionality so I doubt, an expr-run is warranted... > Which FreeTDS port should be used as dependency ? > > $> grep -i ^freetds /usr/ports/INDEX-8 | cut -d\| -f - > freetds-0.64_8,1|/usr/ports/databases/freetds > freetds-devel-0.91_3,1|/usr/ports/databases/freetds-devel > freetds-msdblib-0.64_8,1|/usr/ports/databases/freetds-msdblib I think, it should LIB_DEPEND on sybdb with the databases/freetds used by default. If the system already has -lsybdb installed by any other port, then it can use that. Yours, -mi From owner-freebsd-apache@FreeBSD.ORG Wed Jan 2 23:18:59 2013 Return-Path: Delivered-To: apache@FreeBSD.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 9999737F for ; Wed, 2 Jan 2013 23:18:59 +0000 (UTC) (envelope-from ohauer@FreeBSD.org) Received: from p578be941.dip0.t-ipconnect.de (p578be941.dip0.t-ipconnect.de [87.139.233.65]) by mx1.freebsd.org (Postfix) with ESMTP id 412B3999 for ; Wed, 2 Jan 2013 23:18:59 +0000 (UTC) Received: from [192.168.0.100] (cde1100.uni.vrs [192.168.0.100]) (Authenticated sender: ohauer) by p578be941.dip0.t-ipconnect.de (Postfix) with ESMTPSA id 7D54320901; Thu, 3 Jan 2013 00:18:52 +0100 (CET) Message-ID: <50E4C097.7040007@FreeBSD.org> Date: Thu, 03 Jan 2013 00:19:51 +0100 From: Olli Hauer User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: apache@FreeBSD.org Subject: Re: Fixes for apr-util's FreeTDS driver References: <50E4A29D.4020204@aldan.algebra.com> <50E4B0D4.9090802@FreeBSD.org> In-Reply-To: <50E4B0D4.9090802@FreeBSD.org> X-Enigmail-Version: 1.4.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: "Mikhail T." X-BeenThere: freebsd-apache@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: "apache@FreeBSD.org" List-Id: Support of apache-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Jan 2013 23:18:59 -0000 > On 02.01.2013 17:12, Olli Hauer wrote: >> Hi Mikhail, >> >> patch applies clean on our current devel/apr1 port (apr-util-1.4.1). >> http://people.freebsd.org/~ohauer/diffs/patch-apr-util-1.4.1__dbd__apr_dbd_freetds.c >> >> Maybe the patch finds more notice upstream if shaped against the current apr-util-1.5.1? >> Do you have also a patch for apr-util-1.5.1 available? > I'm pretty sure, it will apply just as well against 1.5 -- the driver has not > changed in years. As currently shipped it is badly broken because the dbd/driver > API changed (years ago!) and the FreeTDS-driver only got updated to allow it to > /compile/ (but not /work/). You are right (just done a quick diff) > > The drag is in that very few people use Sybase with Apache -- the products are > from two different worlds, so to speak... My client happens to (still) use > Vignette for their web-publishing (and Vignette uses Sybase as its own backend), > so that's why they were interested -- but it is a rare case... Back in 2002/3 I was happy to shutdown a product which used Sybase (application crashed, connection not closed clean so lic. for next client not freed up ...) Maybe the user who send in the apr_pcalloc diff is also interested and can confirm your patch > http://mail-archives.apache.org/mod_mbox/apr-dev/201207.mbox/%3C4994179EC7ED6843AAB0A30A1639E7F81DB5260901@DGEX2V.dg.deltagroup.com%3E >> I hope the FreeBSD ports infrastructure is full back in near time so an expr-run with >> the current apr-util can be done. > This would be new functionality so I doubt, an expr-run is warranted... >> Which FreeTDS port should be used as dependency ? I was thinking about apr-util-1.5.x, was not related to your patch more about the time frame for a commit. >> $> grep -i ^freetds /usr/ports/INDEX-8 | cut -d\| -f - >> freetds-0.64_8,1|/usr/ports/databases/freetds >> freetds-devel-0.91_3,1|/usr/ports/databases/freetds-devel >> freetds-msdblib-0.64_8,1|/usr/ports/databases/freetds-msdblib > I think, it should LIB_DEPEND on sybdb with the databases/freetds used by > default. If the system already has -lsybdb installed by any other port, then it > can use that. Ok, will do some test builds at the weekend on 8.3/9.1 (amd64). -- Regards, olli