Home  |  Linux  | Mysql  | PHP  | XML
Date:Thu Mar 31 17:46:19 2011
Subject:Re: [PDO] PDO_OCI
Hi Chris,

Compiled and running. :)

I did not figure out how make "make test " working. Script is complaining
that PDO module is not loaded:
PHP Warning: Cannot load module 'PDO_OCI' because required module 'pdo' is
not loaded in Unknown on line 0
Warning: Cannot load module 'PDO_OCI' because required module 'pdo' is not
loaded in Unknown on line 0

PDO is enabled and correctly loading using CLI. However generated and
loaded tmp-php.ini is missing PDO settings. Sounds as if additional ini
files are not scanned. Any hints?

I will open bug and submit patch as you suggested.

--
schkovich
PHP Dojo <http://phpdojo.blogspot.com/>

On Wed, Mar 30, 2011 at 11:40 PM, Christopher Jones <
christopher.jones@oracle.com> wrote:

>
> 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 <
>> christopher.jones@oracle.com <mailto: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.
>>
>
> 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: christopher.jones@oracle.com <mailto:

>> christopher.jones@oracle.com>
>> Tel: +1 650 506 8630 <tel:%2B1%20650%20506%208630>
>>
>> Blog: http://blogs.oracle.com/opal/
>>
>>
>>
>> --
>> schkovich
>> PHP Dojo <http://phpdojo.blogspot.com/>
>>
>
> --
> Email: christopher.jones@oracle.com
> Tel: +1 650 506 8630
> Blog: http://blogs.oracle.com/opal/
>

Navigate in group php.pdo at sever news.php.net
Previous Next





  
© No Copyright
You are free to use Anything, but please consult your advocate before doing so as this website
also list content from other sources which may be copyrighted.