Bug #57351 [Opn->Csd]: Unable to install PDO_OCI

Edit report at https://bugs.php.net/bug.php?id=57351&edit=1 ID: 57351 Updated by: cmb@php.net Reported by: nicolas dot ternisien at gmail dot com Summary: Unable to install PDO_OCI -Status: Open +Status: Closed Type: Bug -Package: PDO_OCI +Package: PECL Operating System: Linux/Ubuntu PHP Version: 5.1.6 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: As the PECL package is not maintained anymore, I'm closing this ticket. Previous Comments: ------------------------------------------------------------------------ [2008-09-12 13:16:50] jcfiala at gmail dot com BTW: This is a really useful page for getting pdo_oci installed - thanks for writing it all down! ------------------------------------------------------------------------ [2007-04-30 08:06:21] bjoern dot mueller at ivz dot de pecl/pear installation of pdo_oci is not stable at the moment on any linux i have tested so far and if you dont want to spend a whole bunch of time in investigating confscripts details just grab php5 tarball and instantclient basic/sdk zips and install from source. if you want your paketmanager to know about it you would have to install php source rpm for your dist, vi the specfile, build and install your own rpm. best regards bjoern. ------------------------------------------------------------------------ [2007-04-29 13:35:03] nicolas dot ternisien at gmail dot com The question is how to make it work easily with the Debian packaging of instantclient of Oracle (http://oss.oracle.com/debian) Does the pdo_oci version provided by PHP can be installed by default on an Ubuntu installation, or does it still need a pear/pecl install pdo_oci ? Thanks for your answers ------------------------------------------------------------------------ [2007-04-27 11:26:17] wez@php.net Just use the pdo_oci that comes with PHP, as it is newer than the one in pecl. ------------------------------------------------------------------------ [2007-04-27 09:39:10] bjoern dot mueller at ivz dot de workaround: try to build pdo_oci on your own. pecl download pdo_oci tar -cf PDO_OCI-1.0.tar cd PDO_OCI-1.0 ./configure --prefix=/usr/local --with-pdo-oci=instantclient,/usr/local/instantclient,10.2.0.3 you will need to download and untar the oracle instanclient (basic and sdk) from oracle homepage into /usr/local/instantclient if you receive an error ("to dumb to figure out where oci.h is") vi the configure script and modify the searchpath for the oracle headerfiles (in my case they were found in /usr/local/instantclient/sdk). if your make exits with an error "cannot find -lclntsh" try 1. to symlink libclntsh.so.10.1 in /usr/local/instanclient to libclntsh.so 2. to add /usr/local/instantclient to your /etc/ld.so.conf and run ldconfig 3. to vi the configure script again and edit the PDO_OCI_LIB_DIR (PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX") remember to make clean and configure again if you edit the configure script. last step is to copy the extension (./modules/pdo_oci.so) to php extension_dir and to add "extension=pdo_oci.so" to php.ini ... here is my diff configure script: uppsala:/tmp/PDO_OCI-1.0 # diff configure.save configure 3962c3962 < if test -f $PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client/oci.h ; then --- > if test -f $PDO_OCI_IC_PREFIX/sdk/include/oci.h ; then 3964c3964 < if test "$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client" != "/usr/include"; then --- > if test "$PDO_OCI_IC_PREFIX/sdk/include" != "/usr/include"; then 3966,3967c3966,3967 < if test -z "$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client" || echo "$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client" | grep '^/' >/dev/null ; then < ai_p=$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client --- > if test -z "$PDO_OCI_IC_PREFIX/sdk/include" || echo > "$PDO_OCI_IC_PREFIX/sdk/include" | grep '^/' >/dev/null ; then > ai_p=$PDO_OCI_IC_PREFIX/sdk/include 3970c3970 < ep_dir="echo $PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client|$SED 's%/*[^/][^/]*/*$%%'" --- > ep_dir="echo $PDO_OCI_IC_PREFIX/sdk/include|$SED > 's%/*[^/][^/]*/*$%%'" 3973c3973 < ai_p="$ep_realdir/basename \"$PDO_OCI_IC_PREFIX/include/oracle/$PDO_OCI_IC_VERS/client\"" --- > ai_p="$ep_realdir/basename > \"$PDO_OCI_IC_PREFIX/sdk/include\"" 4035c4035 < PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX/lib/oracle/$PDO_OCI_IC_VERS/client/lib" --- > PDO_OCI_LIB_DIR="$PDO_OCI_IC_PREFIX" uppsala:/tmp/PDO_OCI-1.0 # best regards bjoern ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=57351 -- Edit this bug report at https://bugs.php.net/bug.php?id=57351&edit=1