Re: [PDO] PDO_OCI

Comments are inline.

On 03/30/2011 01:59 PM, Goran Miskovic wrote:
> Hi Chris,
>
> Thank you for the prompt reply.
>
> Please find my comments bellow.
>
> On Wed, Mar 30, 2011 at 8:46 PM, Christopher Jones <[email protected] <mailto:[email protected]>> wrote:
>
>
>     Hi Goran,
>
>     How do you set LD_LIBRARY_PATH in the Apache environment? If you're
>     using the system Apache, try setting it in /etc/apache2/envvars.  Or
>     do you use ld.so.conf?  See "Setting Oracle Environment Variables for
>     Apache" on p 106 of
>     http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html
>
>
> I used ld.so.conf. Underground PHP Oracle Manual is great. I used it
> a lot. Unfortunately my specific case is not covered: I am running
> Ubuntu x64, therefore I had to install 32bit Oracle XE, using Debian
> packag, while client has to be 64bit and I used Instant Client 11.2
> zip distribution.

It has all the hallmarks of a confused environment - incorrect
environment vars or even perhaps clashing library versions.

Both the 10.2 and 11g libclntsh.so have the OCIEnvCreate symbol so
there is something fundamental missing.

Does command-line PHP work?

>     I strongly suggest using OCI8 instead of the still "experimental"
>     PDO_OCI.  OCI8 has a bunch more basic + advanced features and is
>     stable.
>
>
> I installed OCI8 while reviewing Jeffrey Rubinoff tutorial
> _/Creating a Database Driven Application With PHP /_[1
> <http://netbeans.org/kb/docs/php/wish-list-oracle-lesson1.html>], as
> part of the NetBeans NetCAT 7.0 program. However, I prefer using PDO
> and having Oracle database already running on my machine, I saw
> opportunity to experiment with PDO_OCI driver.

Fair enough.  I'm sure some patches for PDO_OCI will be appreciated!

>     The PDO_OCI from PECL is older than in the PHP 5.3 bundles.
>
>
> I noticed that, but I did not have other option. :)

You should be able to copy the PDO_OCI directory from a PHP 5.3 bundle
and phpize & configure it.

>     Since you're on a non-RPM system, you're using the Instant Client
>     zips?  You shouldn't need to patch PHP 5.3 config.m4 for the zip
>     files.
>
>
> I did patch config.m4 with few more changes and attached cumulative
> patch to my initial email. Have I used wrong patch?!! Complier did
> not report any errors.

Since 39312 has multiple overlapping patches (some of which are
already fixed) and there isn't any maintainer for PDO, I don't see it
worth continuing with that bug as it stands.  Better to close it and
log new ones.

>     FWIW yesterday Felipe merged a patch to PDO_OCI config.m4 for
>     64bit RPM support. http://bugs.php.net/44989
>
>
> I quickly scanned config.m4 from todays build: It will fail no
> Ubuntu (and other Debian distributions I guess). php_pdo_driver.h is
> not in /include/*php*/ext/pdo but in /include/*php5*/ext/pdo. See
> patch that I applied. I will correct paths (or just create sym link)
> and try again. :) Best,

Ah, a PDO-specific check.  I guess you are using the Ubuntu PHP
packages and not using the default location?  Wez & Tony (in
http://svn.php.net/viewvc?view=revision&revision=179756 and
http://svn.php.net/viewvc?view=revision&revision=179924) didn't
structure the config.m4 to cope with non standard install locations
that Linux distro maintainers may have chosen.  Anyway, why not create
the patch you need based on the latest 5.3 config.m4 and open a new
bug?  This will record the changes for anyone else to find.

Chris


>
> Goran
>
>
>
>     Chris
>
>
> [1] http://netbeans.org/kb/docs/php/wish-list-oracle-lesson1.html
>
>     On 03/30/2011 05:15 AM, Goran Miskovic wrote:
>
>         Hi all,
>         After applying patch given in #39312 <http://bugs.php.net/bug.php?id=39312>, and correcting PHP paths (cumulative patch attached) I complied PDO_OCI on Ubuntu 10.10 x64 without any errors.
>
>         However, Apache is failing to start with following error: symbol lookup error: /usr/lib/php5/20090626/pdo_oci.so: undefined symbol: OCIEnvCreate
>         Help will be highly appreciated.
>         Thanks,
>
>         --
>         schkovich
>         PHP Dojo <http://phpdojo.blogspot.com/>
>
>
>         #39312 http://bugs.php.net/bug.php?id=39312
>
>
>     --
>     Email: [email protected] <mailto:[email protected]>
>     Tel: +1 650 506 8630 <tel:%2B1%20650%20506%208630>
>     Blog: http://blogs.oracle.com/opal/
>
>
>
> --
> schkovich
> PHP Dojo <http://phpdojo.blogspot.com/>

-- 
Email: [email protected]
Tel:  +1 650 506 8630
Blog:  http://blogs.oracle.com/opal/