Hi All!
Does anybody have some hints as to what might be causing a problem (segfault) with Oracle's instantclient when used in conjunction with PHP 5.2.4 (both the CLI and a webserver -- apache 2.x). If I run simple queries I get a result -- no problem. (select * from atable where name='hart') However if I do any more complicated query (select from two tables via a join for example) I get a segmentation fault (again both with the CLI and it segfaults the httpd process). All programs are built from source (except instantclient which I downloaded from oracle). I'm running on SLES10 on an ia64 platform. The info PHP identifies as the system: Linux ssaturn 2.6.16.21-0.8-default #1 SMP Mon Jul 3 18:25:39 UTC 2006 ia64 Oracle is instantclient ia64-10.2.0.3-20061230 oci8 version 1.2.3 revision 1.269.2.16.2.37 Here's my configure command for PHP: './configure' '--with-zlib' '--with-gd' '--with-jpeg' '--with-png' '--with-libxml2=/usr/bin' '--with-mysql=/usr/local/mysql5120' '--with-apxs2=/usr/local/apache2/bin/apxs' '--enable-ftp' '--with-imap-ssl=/usr/include/ssl' '--with-imap=/space/custom_builds/imap-stuff/' '--with-openssl' '--with-pam' '--with-dom' '--with-iconv' '--with-mbstring=all' '--with-mbregex' '--with-domsxlt' '--with-mcrypt' '--with-xml' '--with-mime-magic' '--enable-exif' '--enable-uploadprogress' '--with-xmlrpc' '--with-gettext' '--with-pgsql' '--with-oci8=instantclient,/usr/local/oracle' Again, I can successfully login to the oracle database, and the simplest of queries works. Anything "complicated" crashes the program. I saw on php.net messages about memory exhaustion and segfaults.. Since I'm using the most recent version of PHP I would not think that getting a updated PECL package is going to do the trick. I increased the amt of memory a script can use (in php.ini) to 128Mb but no difference. Is there somehwere else I should be changing a setting? Not sure what else to try.. Thanks! Joshua _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
