[PHP-DEV] PHP 4.0 Bug #9917 Updated: left open Oracle cursors break mail() function

2001-03-23 Thread andrewmc

ID: 9917
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Oracle related
Description: left open Oracle cursors break mail() function


closing the cursors was a red herring, it worked for a bit then same problem occurred 
again. From having done some research and changing some scripts it seems that the 
problem starts after any PHP script which does putenv() has been run. Removing 
putenv() from all PHP scripts and setting up the environment in the Apache startup 
script instead seems to workaround the problem though is not ideal.

Previous Comments:
---

[2001-03-22 07:53:59] [EMAIL PROTECTED]
PHP 4.0.4 staticly compiled into Apache 1.3.14 with Oracle 7.3.4 support - configure 
line as follows:
./configure  --without-mysql --with-apache=/usr/local/apache_1.3.14 --with-ora
cle=/devuat/oracle7.3.4 --enable-track-vars --enable-sigchild

Apache started with PHPRC pointed to directory containing php.ini file with following 
line:
sendmail_path   = /usr/lib/sendmail -t -i

Start Apache, run PHP script which uses mail() function...this works fine until a PHP 
script has been run which performs ora_* functions but does not close cursor 
resources. Subsequent mail() function calls result in no message and the following in 
the Apache error_log file:

: is not an identifier

This looks like stderr from /bin/sh (output below)
$ strings /bin/sh|grep identif
is not an identifier

The following code before calls to mail() fixes the problem:

for ($i=0; $i10; $i++) ora_close ($i);

Seems that unclosed cursors break mail()

More info available if required.

---


Full Bug description available at: http://bugs.php.net/?id=9917


-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DEV] PHP 4.0 Bug #9917: left open Oracle cursors break mail() function

2001-03-22 Thread andrewmc

From: [EMAIL PROTECTED]
Operating system: Sequent DYNIX/ptx 4.4.8
PHP version:  4.0.4
PHP Bug Type: Mail related
Bug description:  left open Oracle cursors break mail() function

PHP 4.0.4 staticly compiled into Apache 1.3.14 with Oracle 7.3.4 support - configure 
line as follows:
./configure  --without-mysql --with-apache=/usr/local/apache_1.3.14 --with-ora
cle=/devuat/oracle7.3.4 --enable-track-vars --enable-sigchild

Apache started with PHPRC pointed to directory containing php.ini file with following 
line:
sendmail_path   = /usr/lib/sendmail -t -i

Start Apache, run PHP script which uses mail() function...this works fine until a PHP 
script has been run which performs ora_* functions but does not close cursor 
resources. Subsequent mail() function calls result in no message and the following in 
the Apache error_log file:

: is not an identifier

This looks like stderr from /bin/sh (output below)
$ strings /bin/sh|grep identif
is not an identifier

The following code before calls to mail() fixes the problem:

for ($i=0; $i10; $i++) ora_close ($i);

Seems that unclosed cursors break mail()

More info available if required.


-- 
Edit Bug report at: http://bugs.php.net/?id=9917edit=1



-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]