NetBSD Problem Report #39232

From www@NetBSD.org  Sun Jul 27 23:01:38 2008
Return-Path: <www@NetBSD.org>
Received: from mail.netbsd.org (mail.netbsd.org [204.152.190.11])
	by narn.NetBSD.org (Postfix) with ESMTP id 4566E63B9AA
	for <gnats-bugs@gnats.netbsd.org>; Sun, 27 Jul 2008 23:01:38 +0000 (UTC)
Message-Id: <20080727230133.3347463B99A@narn.NetBSD.org>
Date: Sun, 27 Jul 2008 23:01:33 +0000 (UTC)
From: rehsack@web.de
Reply-To: rehsack@web.de
To: gnats-bugs@NetBSD.org
Subject: [UPDATE] databases/p5-DBD-Oracle
X-Send-Pr-Version: www-1.0

>Number:         39232
>Category:       pkg
>Synopsis:       [UPDATE] databases/p5-DBD-Oracle
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    pkg-manager
>State:          closed
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Sun Jul 27 23:05:00 +0000 2008
>Closed-Date:    Sat Dec 27 23:20:11 +0000 2008
>Last-Modified:  Sat Dec 27 23:20:11 +0000 2008
>Originator:     Jens Rehsack
>Release:        -
>Organization:
Bayer Business Services
>Environment:
AIX 5.3.0.0
>Description:
Update: databases/p5-DBD-Oracle -> 1.21
>How-To-Repeat:

>Fix:
Index: databases/p5-DBD-Oracle/Makefile
===================================================================
RCS file: /cvsroot/pkgsrc/databases/p5-DBD-Oracle/Makefile,v
retrieving revision 1.10
diff -u -r1.10 Makefile
--- databases/p5-DBD-Oracle/Makefile	4 Mar 2007 01:17:51 -0000	1.10
+++ databases/p5-DBD-Oracle/Makefile	27 Jul 2008 22:59:25 -0000
@@ -1,6 +1,6 @@
 # $NetBSD: Makefile,v 1.10 2007/03/04 01:17:51 grant Exp $

-DISTNAME=	DBD-Oracle-1.19
+DISTNAME=	DBD-Oracle-1.21
 PKGNAME=	p5-${DISTNAME}
 CATEGORIES=	databases perl5
 MASTER_SITES=	${MASTER_SITE_PERL_CPAN:=DBD/}
@@ -20,8 +20,9 @@

 BUILDLINK_PASSTHRU_DIRS+=	${ORACLE_HOME}

-LDFLAGS+=	-L${ORACLE_HOME}/lib
-LDFLAGS+=	${COMPILER_RPATH_FLAG}${ORACLE_HOME}/lib
+CFLAGS+=	-I${ORACLE_HOME}/rdbms/public/
+LDFLAGS+=	-L${ORACLE_HOME}/lib
+LDFLAGS+=	${COMPILER_RPATH_FLAG}${ORACLE_HOME}/lib
 LDFLAGS+=	-lclntsh

 .include "../../databases/p5-DBI/buildlink3.mk"
Index: databases/p5-DBD-Oracle/distinfo
===================================================================
RCS file: /cvsroot/pkgsrc/databases/p5-DBD-Oracle/distinfo,v
retrieving revision 1.3
diff -u -r1.3 distinfo
--- databases/p5-DBD-Oracle/distinfo	4 Mar 2007 01:04:11 -0000	1.3
+++ databases/p5-DBD-Oracle/distinfo	27 Jul 2008 22:59:25 -0000
@@ -1,5 +1,5 @@
 $NetBSD: distinfo,v 1.3 2007/03/04 01:04:11 grant Exp $

-SHA1 (DBD-Oracle-1.19.tar.gz) = 881f87571bff6c934248325b8b0db8de2a5149f3
-RMD160 (DBD-Oracle-1.19.tar.gz) = f22598b160de4f8b72c86c143e481594f290cd67
-Size (DBD-Oracle-1.19.tar.gz) = 369617 bytes
+SHA1 (DBD-Oracle-1.21.tar.gz) = 9f75b61b9ee002f2b4f275ae81951e267dcb539b
+RMD160 (DBD-Oracle-1.21.tar.gz) = a5a85345a2118c5304002c2adb1066859dd71fc5
+Size (DBD-Oracle-1.21.tar.gz) = 407281 bytes

>Release-Note:

>Audit-Trail:
From: Havard Eidnes <he@NetBSD.org>
To: rehsack@web.de
Cc: gnats-bugs@NetBSD.org
Subject: Re: pkg/39232 [UPDATE] databases/p5-DBD-Oracle
Date: Mon, 15 Sep 2008 15:23:52 +0200 (CEST)

 Hi,

 I see you've submitted an update to this package.

 In the submission, you don't mention whether you were able to
 test the package, and whether the tests succeeded.  I don't have
 the required infrastructure to be able to test the result
 myself...

 Best regards,

 - H=E5vard

From: Jens Rehsack <rehsack@web.de>
To: Havard Eidnes <he@NetBSD.org>
Cc: gnats-bugs@NetBSD.org
Subject: Re: pkg/39232 [UPDATE] databases/p5-DBD-Oracle
Date: Mon, 15 Sep 2008 22:03:30 +0000

 Havard Eidnes wrote:
 > Hi,
 >=20
 > I see you've submitted an update to this package.
 >=20
 > In the submission, you don't mention whether you were able to
 > test the package, and whether the tests succeeded.  I don't have
 > the required infrastructure to be able to test the result
 > myself...

 To be true, I didn't additional tests. I just updated the package and use=
 =20
 further in our environment which has a CMDB on Oracle and do some things =

 direct in the database(s) below the SAP systems.
 Those are Oracle 9 (less) and Oracle 10 (many) instances.

 In my build environment, which is a chrooted copy of the original systems=
 , I=20
 do not have any network connectivity - so I can't run tests within the pk=
 g=20
 during the build process.

 > Best regards,
 >=20
 > - H=E5vard
 >=20

 /Jens

From: Jens Rehsack <rehsack@web.de>
To: gnats-bugs@NetBSD.org
Cc: 
Subject: Re: pkg/39232 [UPDATE] databases/p5-DBD-Oracle
Date: Tue, 16 Dec 2008 07:59:54 +0000

 This is a multi-part message in MIME format.
 --------------070109050201080308040800
 Content-Type: text/plain; charset=ISO-8859-1; format=flowed
 Content-Transfer-Encoding: 7bit

 It seems, he@ is busy at the moment. So here's the patch if someone else has 
 time and commit permissions.

 Best regards,
 Jens

 --------------070109050201080308040800
 Content-Type: text/plain;
  name="patch-databases::p5-DBD-Oracle"
 Content-Transfer-Encoding: 7bit
 Content-Disposition: inline;
  filename="patch-databases::p5-DBD-Oracle"

 Index: Makefile
 ===================================================================
 RCS file: /cvsroot/pkgsrc/databases/p5-DBD-Oracle/Makefile,v
 retrieving revision 1.11
 diff -u -r1.11 Makefile
 --- Makefile	19 Oct 2008 19:17:44 -0000	1.11
 +++ Makefile	16 Dec 2008 08:03:01 -0000
 @@ -1,6 +1,6 @@
  # $NetBSD: Makefile,v 1.11 2008/10/19 19:17:44 he Exp $

 -DISTNAME=	DBD-Oracle-1.19
 +DISTNAME=	DBD-Oracle-1.22
  PKGNAME=	p5-${DISTNAME}
  PKGREVISION=	1
  CATEGORIES=	databases perl5
 @@ -11,7 +11,17 @@

  PERL5_PACKLIST=	auto/DBD/Oracle/.packlist

 +PKG_OPTIONS_VAR=	PKG_OPTIONS.p5-DBD-Oracle
 +
 +PKG_SUPPORTED_OPTIONS=	# empty
 +PKG_SUGGESTED_OPTIONS=	# empty
 +
 +PKG_OPTIONS_REQUIRED_GROUPS=	oralib
 +PKG_OPTIONS_GROUP.oralib=	lib32 libsys libbase
 +PKG_SUGGESTED_OPTIONS.oralib=	libsys
 +
  .include "../../mk/bsd.prefs.mk"
 +.include "../../mk/bsd.options.mk"

  .if !defined(ORACLE_HOME)
  PKG_FAIL_REASON+=	"You must set ORACLE_HOME to the location of your Oracle installation"
 @@ -21,8 +31,18 @@

  BUILDLINK_PASSTHRU_DIRS+=	${ORACLE_HOME}

 +.if !empty(PKG_OPTIONS:Mlib32)
 +LDFLAGS+=	-L${ORACLE_HOME}/lib32
 +LDFLAGS+=	${COMPILER_RPATH_FLAG}${ORACLE_HOME}/lib32
 +.elif !empty(PKG_OPTIONS:Mlib64)
  LDFLAGS+=	-L${ORACLE_HOME}/lib
  LDFLAGS+=	${COMPILER_RPATH_FLAG}${ORACLE_HOME}/lib
 +.elif !empty(PKG_OPTIONS:Mlibbase)
 +LDFLAGS+=	-L${ORACLE_HOME}
 +LDFLAGS+=	${COMPILER_RPATH_FLAG}${ORACLE_HOME}
 +.endif
 +
 +CFLAGS+=	-I${ORACLE_HOME}/rdbms/public/
  LDFLAGS+=	-lclntsh

  .include "../../databases/p5-DBI/buildlink3.mk"
 Index: distinfo
 ===================================================================
 RCS file: /cvsroot/pkgsrc/databases/p5-DBD-Oracle/distinfo,v
 retrieving revision 1.3
 diff -u -r1.3 distinfo
 --- distinfo	4 Mar 2007 01:04:11 -0000	1.3
 +++ distinfo	16 Dec 2008 08:03:01 -0000
 @@ -1,5 +1,5 @@
  $NetBSD: distinfo,v 1.3 2007/03/04 01:04:11 grant Exp $

 -SHA1 (DBD-Oracle-1.19.tar.gz) = 881f87571bff6c934248325b8b0db8de2a5149f3
 -RMD160 (DBD-Oracle-1.19.tar.gz) = f22598b160de4f8b72c86c143e481594f290cd67
 -Size (DBD-Oracle-1.19.tar.gz) = 369617 bytes
 +SHA1 (DBD-Oracle-1.22.tar.gz) = 23df4d0bdf4bc4da21dadc31aaa7dba443a7e9ce
 +RMD160 (DBD-Oracle-1.22.tar.gz) = a23804d9f803b245a9e22e050952cd0750da2e19
 +Size (DBD-Oracle-1.22.tar.gz) = 424624 bytes

 --------------070109050201080308040800--

State-Changed-From-To: open->feedback
State-Changed-By: he@NetBSD.org
State-Changed-When: Thu, 18 Dec 2008 01:14:09 +0000
State-Changed-Why:
Patch applied -- many thanks for it and testing.


From: Havard Eidnes <he@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc: 
Subject: PR/39232 CVS commit: pkgsrc/databases/p5-DBD-Oracle
Date: Thu, 18 Dec 2008 01:13:04 +0000 (UTC)

 Module Name:	pkgsrc
 Committed By:	he
 Date:		Thu Dec 18 01:13:04 UTC 2008

 Modified Files:
 	pkgsrc/databases/p5-DBD-Oracle: Makefile distinfo

 Log Message:
 Update from version 1.19nb1 to 1.22.

 Based on diffs and testing done by Jens Rehsack, while following
 up on PR#39232, patch also submitted there.

 Pkgsrc changes:
  o Support different oracle library options
  o Add HOMEPAGE using search.cpan.org

 Upstream changes:

 Changes in DBD-Oracle 1.21(svn rev 11067) 11th April 2008 ^

   Added Notes to README.win32.txt on installing Instant Client
     11.1.0.6.0 from John Scoles
   Added the oci_typecode_name method to get the name rather than
     just the number of an OCI_TYPECODE from John Scoles
   Fixed a unreported bug with Embedded Objects from John Scoles
   Fixes for #34621 & 33791 from RT cpan
   Added patch to allow faster fetch from REF CURSORs from Biswadeep Chowdhury
   Updated the Todo file for next version from John Scoles
   Added support for the 10.2 Data Interface for Persistent LOBs by John Scoles
   Changed the way pre-fetching is done by John Scoles
   Added support for Scrollable cursors from John Scoles
   Changed the max size of cache_rows to a sb4 rather than a int
     and or a ub4 from John Scoles
   Added support for Lobs in select of OCI Embedded Objects from
     John Scoles with a big thankyou to  Paul Weiss
   Fixed for embedded object in object from Paul Weiss
   Added support for direct insert of large XML data into XMLType
     fields from Hendrik Fuss & John Scoles
   Fixed memory leak (not releasing Temp Lob with OCILobFreeTemporary)
     when created for a bind from John Scoles
   Added support for bind_param_inout_array for use with execute_array
     from John Scoles
   Added enhancement for Embedded Objects handling from Paul G. Weiss
   Fixed to Makefile.PL let it read makefiles from other makes from
     Alexander V Alekseev
   Updated POD to tell users to Avoid Using "SQL Call" from Charles Jardine
   Updated POD to account for rt.cpan.org #30910: "DBD-Oracle crashes
     when trying to read empty LOB" from John Scoles
   Added DBD::Oracle impdata/threads patch from Jeffrey Klein

 Changes in DBD-Oracle 1.20(svn rev 10517) 11th January 2008 ^

   Fixed lob test so it skips the one test that relies on it if v$
     session. from Rafael Kitover
   Fixed // with /* */ in dbdimp.c from John Scoles
   Fixed for execute_for_fetch in Oracle.pm returning 0 instead of
     0E0.  from Martin J. Evans
   Added README.64bit.txt that contains help for compiling on 64
     bit boxes from John Scoles
   Fixed typo in Oracle.pm from Tom R.
   Added support for ora_charset, ora_ncharset from Stephen J. Smith
   Fixed Makefile.PL for better handling of empty array in
     File::Find::find from Slaven Rezic
   Fixed references to README.clients.txt in Makefile.PL from  John Scoles
   Added PERL_NO_GET_CONTEXT for better multi-threaded support from John Scoles
   Changed required version of DBI to be 1.51 from John Scoles
   Fixed bug in 31lob.t from John Scoles
   Added notes on installing Instantclient .rpm to README.Lunix.txt
   Added support for OCI array bind from Alexander V Alekseev
   Added support for select of OCI Embedded Objects from John Scoles
   Added a tip in README.64bit.txt from cartmanltd
   Added fix to Makefile.PL for finding SQLplus for Ubuntu Server
     (but should work for others) from Martin J. Evans
   Added fix to Makefile.PL for Gentoo AMD64 from Tom R.
   Added fix to dbdimp.c for speed up of Null-Operations from Andreas Behal
   Added fix to dbdimp.c for SQLCS_NCHAR index use on varchar2s from
     Peter J. Holzer


 To generate a diff of this commit:
 cvs rdiff -r1.11 -r1.12 pkgsrc/databases/p5-DBD-Oracle/Makefile
 cvs rdiff -r1.3 -r1.4 pkgsrc/databases/p5-DBD-Oracle/distinfo

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.

From: Jens Rehsack <rehsack@web.de>
To: gnats-bugs@NetBSD.org
Cc: 
Subject: Re: pkg/39232 ([UPDATE] databases/p5-DBD-Oracle)
Date: Sat, 27 Dec 2008 21:18:31 +0000

 he@NetBSD.org wrote:
 > Synopsis: [UPDATE] databases/p5-DBD-Oracle
 > 
 > State-Changed-From-To: open->feedback
 > State-Changed-By: he@NetBSD.org
 > State-Changed-When: Thu, 18 Dec 2008 01:14:09 +0000
 > State-Changed-Why:
 > Patch applied -- many thanks for it and testing.

 Could be feedback -> closed - tested and verfied (on AIX 5.3).

 /Jens

State-Changed-From-To: feedback->closed
State-Changed-By: wiz@NetBSD.org
State-Changed-When: Sat, 27 Dec 2008 23:20:11 +0000
State-Changed-Why:
Confirmed fixed, thanks for the feedback!


>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.51 2026/08/10 02:28:17 riastradh Exp $
$NetBSD: gnats_config.sh,v 1.10 2026/05/13 22:00:09 riastradh Exp $
Copyright © 1994-2026 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.