Edit report at http://bugs.php.net/bug.php?id=39312&edit=1
ID: 39312
Comment by: jbrauer at llu dot edu
Reported by: andrew dot nagy at villanova dot edu
Summary: Cannot install PDO_OCI
Status: Assigned
Type: Bug
Package: PDO related
Operating System: Linux
PHP Version: 5.2.9
Assigned To: sixd
New Comment:
I got it to build on Redhat using the instantclient RPM. Here's what I
did.
manually added the following to config.m4 to allow for Oracle instant
client
11.1
(stolen from matts at iastate above)
@@ -7,6 +7,8 @@
if test -s "$PDO_OCI_DIR/orainst/unix.rgs"; then
PDO_OCI_VERSION=`grep '"ocommon"' $PDO_OCI_DIR/orainst/unix.rgs |
sed 's/[
][ ]*/:/g' | cut -d: -f 6 | cut -c 2-4`
test -z "$PDO_OCI_VERSION" && PDO_OCI_VERSION=7.3
+ elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.11.1;
then
+ PDO_OCI_VERSION=11.1
elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.10.1;
then
PDO_OCI_VERSION=10.1
elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.9.0; then
AND
@@ -119,6 +126,9 @@
10.2)
PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)
;;
+ 11.1)
+ dnl PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)
+ ;;
*)
AC_MSG_ERROR(Unsupported Oracle version! $PDO_OCI_VERSION)
;;
if you have instant client of lower version its not needed.
Then I re phpize 'd it. and ran configure:
(esimard at mediagrif dot com)'s strace showed me the only dir I needed
was /usr
./configure --with-pdo-oci=instantclient,/usr,11.1.0.1
configure, make and make install completed successfully
Previous Comments:
------------------------------------------------------------------------
[2009-09-16 21:15:51] matts at iastate dot edu
Since the above messed up the formatting, I'll keep a copy of the patch
here for the meantime:
http://booster.agron.iastate.edu/mattsteven/oci_patch_jaunty.patch
------------------------------------------------------------------------
[2009-09-16 21:13:02] matts at iastate dot edu
Here is a patch which will let you build the pdo_oci lib with the
instant client on debian or ubuntu systems. Save the contents to
oci_patch.txt, and then run it against your config.m4 file like so:
cd PDO_OCI-1.0 && patch -p0 < /path/to/oci_patch.txt
=========
### Eclipse Workspace Patch 1.0
#P pdo_oci
Index: config.m4
===================================================================
--- config.m4 (revision 141)
+++ config.m4 (working copy)
@@ -7,6 +7,8 @@
if test -s "$PDO_OCI_DIR/orainst/unix.rgs"; then
PDO_OCI_VERSION=`grep '"ocommon"' $PDO_OCI_DIR/orainst/unix.rgs |
sed 's/[ ][ ]*/:/g' | cut -d: -f 6 | cut -c 2-4`
test -z "$PDO_OCI_VERSION" && PDO_OCI_VERSION=7.3
+ elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.11.1;
then
+ PDO_OCI_VERSION=11.1
elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.10.1;
then
PDO_OCI_VERSION=10.1
elif test -f $PDO_OCI_DIR/lib/libclntsh.$SHLIB_SUFFIX_NAME.9.0; then
@@ -57,14 +59,19 @@
AC_MSG_CHECKING([for oci.h])
if test -f
$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client/oci.h ; then
PHP_ADD_INCLUDE($PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client)
+
PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/lib"
AC_MSG_RESULT($PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client)
elif test -f
$PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/include/oci.h ;
then
PHP_ADD_INCLUDE($PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/include)
+
PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/lib"
AC_MSG_RESULT($PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/include)
+ elif test -f $PDO_OCI_IC_PREFIX/sdk/include/oci.h ; then
+ PHP_ADD_INCLUDE($PDO_OCI_IC_PREFIX/sdk/include)
+ AC_MSG_RESULT($PDO_OCI_IC_PREFIX/sdk/include)
+ PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX"
else
AC_MSG_ERROR([I'm too dumb to figure out where the include dir is
in your instant client install])
fi
-
PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/lib"
PDO_OCI_VERSION="`echo $PDO_OCI_IC_VERS | cut -d. -f1-2`"
else
if test -d "$PDO_OCI_DIR/rdbms/public"; then
@@ -119,6 +126,9 @@
10.2)
PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)
;;
+ 11.1)
+ dnl PHP_ADD_LIBRARY(clntsh, 1, PDO_OCI_SHARED_LIBADD)
+ ;;
*)
AC_MSG_ERROR(Unsupported Oracle version! $PDO_OCI_VERSION)
;;
@@ -176,22 +186,24 @@
-L$PDO_OCI_LIB_DIR $PDO_OCI_SHARED_LIBADD
])
- ifdef([PHP_CHECK_PDO_INCLUDES],
- [
- PHP_CHECK_PDO_INCLUDES
- ],[
- AC_MSG_CHECKING([for PDO includes])
- if test -f $abs_srcdir/include/php/ext/pdo/php_pdo_driver.h; then
+dnl ifdef([PHP_CHECK_PDO_INCLUDES],
+dnl [
+dnl PHP_CHECK_PDO_INCLUDES
+dnl ],[
+ AC_MSG_CHECKING([ PDO includes])
+ if test -f $prefix/include/php/ext/pdo/php_pdo_driver.h; then
+ pdo_inc_path=$prefix/include/php/ext
+ elif test -f $prefix/include/php5/ext/pdo/php_pdo_driver.h; then
+ pdo_inc_path=$prefix/include/php5/ext
+ elif test -f $abs_srcdir/include/php/ext/pdo/php_pdo_driver.h;
then
pdo_inc_path=$abs_srcdir/ext
elif test -f $abs_srcdir/ext/pdo/php_pdo_driver.h; then
pdo_inc_path=$abs_srcdir/ext
- elif test -f $prefix/include/php/ext/pdo/php_pdo_driver.h; then
- pdo_inc_path=$prefix/include/php/ext
else
AC_MSG_ERROR([Cannot find php_pdo_driver.h.])
fi
AC_MSG_RESULT($pdo_inc_path)
- ])
+dnl ])
PHP_NEW_EXTENSION(pdo_oci, pdo_oci.c oci_driver.c oci_statement.c,
$ext_shared,,-I$pdo_inc_path)
------------------------------------------------------------------------
[2009-09-04 23:09:55] jnichols959 at gmail dot com
seems like pdo_oci will configure, compile and run correctly with the
proper environment variables and configure commands everywhere *except*
on mac os x. the patch suggested in comment
http://bugs.php.net/bug.php?id=39312#c144683 of this bug fixes it on mac
os x (tested with 10.2.0.4 instantclient and os x 10.5.8) and also works
on linux (centos 5.3 x86_64 and 10.2.0.4 instantclient also x86_64).
can someone with access test and hopefully apply the patch so os x users
can use pdo_oci without hacking the configure script?
------------------------------------------------------------------------
[2009-07-14 14:36:16] cmroddy at gmail dot com
following tony2001's directions exactly i am of course able to
reproduce this problem. i got the thing to build once a couple of years
ago but haven't succeeded since then. as i recall it took several days
of continuous shell games with the configure script.
it seems there is no one around to maintain PDO_OCI. i can sympathize
with this. i certainly wouldn't want to maintain it either. but if this
build can't be made to work even given explicit paths to every single
file it needs, then PDO_OCI needs to be dropped entirely and deleted
from the documentation.
------------------------------------------------------------------------
[2009-03-18 23:06:48] esimard at mediagrif dot com
I will assume that "assigned" means open since this bug doesn't seem
fixed yet.
I tried to install instantclient 10.2.0.4 with php-5.2.9 on RHEL5.
Tried it with the RPMs, didn't work, so I followed the instructions that
other people suggested here on the php.net instantclient page.
I installed the client in /usr/lib/oracle/10.2.0.4/client/
and the sdk in /usr/lib/oracle/10.2.0.4/client/sdk/include/
I tried to configure with the switches:
--with-oci8=shared,instantclient,/usr/lib/oracle/10.2.0.4/client
--with-pdo-oci=instantclient,/usr/lib/oracle,10.2.0.4
without success, getting the error I'm too dumb to figure out where the
libraries are in your Instant Client install.
After checking it out with strace, it seems that it tries to find the
files(headers and libs in the wrong directories). Also a import of
ld.so.conf with the libs dir did not help apparently.
So here is what I saw:
stat64("/usr/lib/oracle/include/oracle/10.2.0.4/client/oci.h",
0xbf7f53b8) = -1 ENOENT (No such file or directory)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
stat64("/usr/lib/oracle/lib/oracle/10.2.0.4/client/include/oci.h",
0xbf7f52e8) = -1 ENOENT (No such file or directory)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
stat64("/usr/lib/oracle/sdk/include/oci.h", 0xbf7f5218) = -1 ENOENT (No
such file or directory)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
stat64("/usr/lib/oracle/client/include/oci.h", 0xbf7f5148) = -1 ENOENT
(No such file or directory)
fixed temporary with ln -s /usr/lib/oracle/10.2.0.4/client/sdk/
/usr/lib/oracle/sdk
and
stat64("/usr/lib/oracle/lib/oracle/10.2.0.4/client/lib/libclntsh.so",
0xbfa5a858) = -1 ENOENT (No such file or directory)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
stat64("/usr/lib/oracle/client/lib/libclntsh.so", 0xbfa5a788) = -1
ENOENT (No such file or directory)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
stat64("/usr/lib/oracle/libclntsh.so", 0xbfa5a6b8) = -1 ENOENT (No such
file or directory)
fixed temporary with ln -s /usr/lib/oracle/10.2.0.4/client/
/usr/lib/oracle/client
ln -s /usr/lib/oracle/10.2.0.4/client/
/usr/lib/oracle/10.2.0.4/client/lib
which is somewhat ghetto.
I would like to hear if you have a smoother way to do that. If this bug
is not considered open, can someone please email me if you have another
workaround if this comment gets deleted?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=39312
--
Edit this bug report at http://bugs.php.net/bug.php?id=39312&edit=1
