Re: [PDO] PDO_OCI

Hi Chris, Thank you for the prompt reply. Please find my comments bellow. On Wed, Mar 30, 2011 at 8:46 PM, Christopher Jones < christopher.jones@oracle.com> 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. > 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. > The PDO_OCI from PECL is older than in the PHP 5.3 bundles. > I noticed that, but I did not have other option. :) > 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. 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, 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: christopher.jones@oracle.com > Tel: +1 650 506 8630 > Blog: http://blogs.oracle.com/opal/ > -- schkovich PHP Dojo <http://phpdojo.blogspot.com/>