php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: jhise at distantworker dot com
New email:
PHP Version: OS:

 

 [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 07 21:01:27 2024 UTC