Posted by Jochem Maas on 10/11/05 04:30

Chuck wrote:
> After 3 months of headache and intermittent seg faults on Solaris 9, we
> decided to give SLES 9 a try.
>
> Now we get continuous seg faults.
>
> I am running apache 2.0.54 on SLES 9 with all updates, and Oracle
> 10.2.0.1<http://10.2.0.1>.
> (everything is the 32-bit flavor)
>
> I built PHP as follows:
> adcinfops02:/usr/local/httpd-2.0.54/htdocs #./configure
> --prefix=/usr/local/php-5.0.5 --with-apxs2=/usr/local/httpd-2.0.54/bin/apxs

long shot: which worker module do you have enabled in httpd.conf?
you can only use 'pre-fork' with php.

> --enable-cli --enable-debug --with-config-file-path=/usr/local/php-5.0.5/lib
> --enable-sigchild --with-zlib --with-bz2 --enable-ftp --with-gettext
> --enable-mbstring --with-ncurses --with-oci8=/u01/app/oracle/product/10.2
> --enable-session --enable-sockets --enable-shared --disable-xml
> --disable-libxml --disable-dom --with-jpeg-dir=/usr/lib
> --with-png-dir=/usr/lib --with-zlib-dir=/usr/lib --with-xpm-dir=/usr/lib
> --disable-simplexml --without-pear
>
> Here is the simply php page that seg faults _every_ time it is called. (On
> solaris, it only seg faulted 25% of the time)
> <?php
>
> putenv("ORACLE_HOME=/u01/app/oracle/product/10.2");
> putenv("ORACLE_SID=ADCDM02");
> putenv("TNS_ADMIN=/var/opt/oracle");
>
>
> $ora = ociplogon("dm","mypassword", "MYSID");
>
> $stmt=OCIParse($ora, "select USERNAME from dba_users");
> $res=OCIExecute($stmt);
>
> $rows = OCIFetchstatement($stmt, $results);
>
> print "DEBUG: rows=$rows<BR>\n";
>
> $keys = array_keys($results);
> foreach($keys as $key)
> {
> print "$key<BR>\n";
> }
> for($i=0; $i < $rows; $i++)
> {
> print " " . $results["USERNAME"][$i] . "<BR>\n";
> }
>
> OCIFreeStatement($stmt);
> OCILogoff($ora);
>
> ?>
>
>
> I can run this script 100 times from the command line ( # php oratest.php )
> and not a single seg fault.
>
> Anyone have any idea why this is happenning?
>
> Also, is there a config, any OS, any version, and combination AT ALL, where
> PHP is reliable when using Oracle 10g as the back end? Any configuration at
> all?
>
> Thx,
> CC
> --
>

[Back to original message]