php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #18988 Oracle+Apache+PHP = Random Memory Dump
Submitted: 2002-08-20 12:36 UTC Modified: 2002-09-21 01:57 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: jhise at distantworker dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4.3.0-dev OS: RH Linux 7.3
Private report: No CVE-ID: None
View Developer Edit
 [2002-08-20 12:36 UTC] jhise at distantworker dot com 
Linux version 2.4.18-3 (bhcompile@daffy.perf.redhat.com) (gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-110)) #1 Thu Apr 18 07:37:53 EDT 2002

Apache 1.3.22
-----
I've had this problem for a while. I can't figure it out at all.

I've set up PHP, Apache and Oracle Client 8.1.7. When I query the database and get no results, I get all kinds of garbage in the browser, including PHP code, non-printable characters, etc. However, I did recompile PHP as a standalone executable. If I run the same exact query through PHP that way, I have no problems. The only thing I've found online about this (and I think it's about this) is list on phpbuilder:

http://www.phpbuilder.org/mail/php-developer-list/199903/0106.php?print_mode=1
Under the Oracle section (bug #56).

This has happened on two Dell Rack servers and a compaq desktop. But I don't think it's hardware related.

Thanks,

Jeremy

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-08-20 12:45 UTC] jhise at distantworker dot com 
Actually...it's not only when there are no results returned. It does in fact happen when there are results returned. And the query is as simple as "select code from dashboard where id = 439" and code is a varchar2(32).
 [2002-08-20 13:01 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip
 [2002-08-20 13:02 UTC] sniper@php.net 
check also that your apache httpd is linked with libpthread
(see http://www.php.net/manual/en/ref.oci8.php for details)

Also, give us the configure line you used to configure PHP.
 [2002-08-20 13:05 UTC] jhise at distantworker dot com 
The configure is:

 './configure' '--with-apache=../apache_1.3.22' '--with-oracle' '--with-oci8' '--enable-track-vars' '--enable-trans-sid' '--enable-magic-quotes' '--enable-sigchild' '--enable-calendar' '--enable-ftp' '--with-gd=/usr/local' '--enable-gd-imgstrttf' '--with-jpeg-dir=/usr/local/lib' '--with-png-dir=/usr/local' '--enable-wddx' '--enable-sysvmem' '--enable-sysvshm' '--with-xml' '--with-ttf' '--with-zlib=/usr/local' '--with-zlib-dir=/usr/local' '--enable-sockets' '--with-java=/usr/local/java'
 [2002-08-20 13:08 UTC] sniper@php.net 
You could drop --with-oracle as you have --with-oci8 (which is the preferred extension to be used)
 [2002-08-20 13:09 UTC] jhise at distantworker dot com 
[root@usnyc7thdev11 src]# ldd /usr/sbin/httpd 
	libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40031000)
	libm.so.6 => /lib/i686/libm.so.6 (0x40046000)
	libcrypt.so.1 => /lib/libcrypt.so.1 (0x40068000)
	libgdbm.so.2 => /usr/lib/libgdbm.so.2 (0x40095000)
	libdb-3.3.so => /usr/lib/libdb-3.3.so (0x4009b000)
	libmm.so.11 => /usr/lib/libmm.so.11 (0x4012a000)
	libexpat.so.0 => /usr/lib/libexpat.so.0 (0x4012e000)
	libdl.so.2 => /lib/libdl.so.2 (0x4014e000)
	libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
	/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
 [2002-08-20 13:41 UTC] jhise at distantworker dot com 
Well:

I did reinstall PHP. I've vastly simplified the configure to:

./configure --with-oci8 --with-apache=../apache_1.3.22

This has not resolved the problem. I will now try the latest snapshot.
 [2002-08-20 13:57 UTC] jhise at distantworker dot com 
:( Well...I've installed the latest version of PHP...and the problem still exists. While this is not really helpful, here are some examples of my result sets:
---------------------
Warning: OCIParse: ORA-00972: identifier is too long in /var/www/html/development/jhise/tams_sourcing/lib/database_sup.plib on line 125
Invalid database query: select * from dashb_register where code = '## Here is a bunch of jibberish ##
---------------------
Warning: OCIStmtExecute: ORA-00933: SQL command not properly ended in /var/www/html/development/jhise/tams_sourcing/lib/database_sup.plib on line 140
---------------------
Warning: OCIStmtExecute: ORA-00911: invalid character in /var/www/html/development/jhise/tams_sourcing/lib/database_sup.plib on line 140
---------------------
 [2002-08-20 21:29 UTC] sniper@php.net 
Forgot to update version. (please check it from phpinfo() output so it's the same..?)

Thies, any ideas what might be causing this?
 [2002-08-23 12:09 UTC] jhise at distantworker dot com 
I don't understand. Forgot to update version?
 [2002-08-23 12:14 UTC] thies@php.net 
i need a _SHORT_ testcase that allows me to reproduce your 
problem. please try to make it as _short_ as possible and 
send it to me via mail
 [2002-09-21 01:57 UTC] sniper@php.net 
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 12:01:31 2024 UTC