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:
(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.