date:20040419

#22692 [Opn-Csd]: Oracle 9i

2004-04-19 Thread tony2001

 ID:   22692
 Updated by:   [EMAIL PROTECTED]
 Reported By:  frusti at frusti dot com
-Status:   Open
+Status:   Closed
 Bug Type: Feature/Change Request
 Operating System: Windows 2000 Server SP3
 PHP Version:  4.3.2RC1


Previous Comments:


[2004-04-19 06:20:46] cjbj at hotmail dot com

Php_oci8 is the newest PHP Oracle extension.

It uses Oracle's most current C API - called OCI8 because it was
introduced with Oracle version 8.



[2003-03-14 03:18:59] frusti at frusti dot com

Hello,

I am using portable SQL with ADODB and now I have performance-problemes
with Oracle 9i. 
I have also tested it with PEAR-DB, the same problem.
With Oracle 8i it goes well. 

Have anyone an idea when a newer Oracle-extensions come out? At moment
I use php_oci8. 

Please give me a feedback as soon as possible.

Thanks and best regards,
Frast Andreas




-- 
Edit this bug report at http://bugs.php.net/?id=22692edit=1

#19714 [Asn-WFx]: OCI8: Using default user in OCI8 functions

2004-04-19 Thread tony2001

 ID:   19714
 Updated by:   [EMAIL PROTECTED]
 Reported By:  jomar at hafro dot is
-Status:   Assigned
+Status:   Wont fix
 Bug Type: Feature/Change Request
 Operating System: SunOS
 PHP Version:  4.2.2
 Assigned To:  maxim
 New Comment:

That seems to be a useful feature, which makes PHP more secure, so I'm
changing this to Won't fix.


Previous Comments:


[2004-04-19 06:05:10] cjbj at hotmail dot com

From
http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#extauth

Allowing externally authenticated database connections over the web
would be a potential security risk for most configurations. Luckily
PHP's OCI8 extension will not allow external authentication where the
username is / and the password an empty string. The call in PHP's
oci8.c to Oracle's OCISessionBegin() always sets the credential flag to
OCI_CRED_RDBMS. To support operating system authentication the PHP
source code would have to be changed to pass Oracle the OCI_CRED_EXT
flag when appropriate.



[2002-11-11 13:08:10] [EMAIL PROTECTED]

Oracle does not seem to read user/pass if it is passed to it as the
username via OCILogon.

When second parameter is an empty strng OCISessionBegin() complains
about the NULL password Given while if username contains '/' it is 1)
unparsed by API, 2) will still leave OCISessionBegin() without a
password.

I will take a look at it.




[2002-10-02 08:04:17] jomar at hafro dot is

I´m using Apache enviroment :
SetEnv ORACLE_HOME /usr/oracle
SetEnv ORA_NLS33 /usr/oracle/ocommon/nls/admin/data
SetEnv NLS_LANG icelandic_america

I also set the tns_names and more env within root enviroment before I
execute apachectl start running php as a module. 
I also compiled Php with Oci8.

I´m having trouble with ocilogon function when I use the 
ocilogon(/,) (default user/nopass,server)

If I logon using a valid username and password then it is ok, but when
I use this method it returns an ora error :
ORA-01005: null password given; logon denied 

I also have the ora libs and if I use ora_logon(/,) that seems to
work.





-- 
Edit this bug report at http://bugs.php.net/?id=19714edit=1

#26286 [Com]: Parent: child process exited with status 3221225477 -- Restarting

2004-04-19 Thread cpuidle at gmx dot de

 ID:   26286
 Comment by:   cpuidle at gmx dot de
 Reported By:  igg10 at alu dot ua dot es
 Status:   No Feedback
 Bug Type: Apache2 related
 Operating System: Windows 2000
 PHP Version:  4.3.4
 New Comment:

Windows error reporting mentions:
szModName: php5ts.dll
szModVer:  5.0.0.0
offset:00052dc6

Can provide full memory dump from winXP error reporting on request (12m
unzipped).

Cheers,
Andi


Previous Comments:


[2004-04-19 07:34:56] cpuidle at gmx dot de

Same issue for me, using Apache 2.0.49, PHP5RC1
Seems to be happening in conjunction with MySQL?



[2004-04-09 09:51:28] hagen at xiag dot ch

The same on WindowsXP SP1,
PHP 5RC1 as a module on Apache 2.0.48.



[2004-04-08 20:44:45] colstrom at dxlab dot com

I am running into the same problem, with the following configuration:

Windows XP SP1
Apache 2.0.47
PHP 4.3.4

In an attempt to correct this, I upgraded to the following:

Apache 2.0.49
PHP 4.3.5

And yet the problem persists. As for scripts, I am running a very
heavily hacked phpBB-v2.0.6, and dotProject-v1.0.2. I have tried the
aforementioned fix of turning register_globals ON, and still the error
persists.

What am I doing wrong?



[2004-03-23 17:01:19] MSunbeam at gmx dot net

I had that same bug.
Using 
apache 2.0.49 php5.0.0rc1  on Win2k
Using SSL 

Listen 443
LoadFile /server/php/ssleay32.dll
LoadModule ssl_module modules/mod_ssl.so

The error eccord when user was request http://localhost:443
(he called normal server on SSL-port)

error.log

[Tue Mar 23 23:03:46 2004] [notice] Parent: child process exited with
status 3221225477 -- Restarting.
[Tue Mar 23 23:03:49 2004] [notice] Parent: Created child process 592
[Tue Mar 23 23:03:54 2004] [notice] Child 592: Child process is
running
[Tue Mar 23 23:03:54 2004] [notice] Child 592: Acquired the start
mutex.
[Tue Mar 23 23:03:54 2004] [notice] Child 592: Starting 250 worker
threads.


drwtsn32 error report



Anwendungsausnahme aufgetreten:
Anwendung:  (pid=1080)
Wann: 23.03.2004 @ 23:03:45.902
Ausnahmenummer: c005 (Zugriffsverletzung)

* Systeminformationen *
Computername: msunbeam.net
Benutzername: MSun
Prozessoranzahl: 1
Prozessortyp: x86 Family 6 Model 3 Stepping 3
Windows 2000-Version: 5.0
Aktuelles Build: 2195
Service Pack: None
Aktueller Typ: Uniprocessor Free
Firma: 
Besitzer: MSun

* Taskliste *
   0 Idle.exe
   8 System.exe
 144 smss.exe
 172 csrss.exe
 192 winlogon.exe
 220 services.exe
 232 lsass.exe
 388 svchost.exe
 416 SPOOLSV.exe
 444 blackd.exe
 460 svchost.exe
 488 nvsvc32.exe
 508 RapApp.exe
 540 regsvc.exe
 572 winmgmt.exe
 768 explorer.exe
 876 4DMAIN.exe
 896 blackice.exe
1076 Apache.exe
1004 IEXPLORE.exe
1080 Apache.exe
2100 IEXPLORE.exe
2120 drwtsn32.exe
   0 _Total.exe

(0040 - 00405000) .\Apache.pdb
(77F8 - 77FFF000) 
(6EEC - 6EEE) .\libapr.pdb
(77E7 - 77F33000) 
(77DA - 77DFA000) 
(77D3 - 77D9F000) 
(74FA - 74FB4000) 
(7800 - 78046000) 
(74F9 - 74F98000) 
(74F6 - 74F73000) 
(77E0 - 77E65000) 
(77F4 - 77F7C000) 
(7797 - 77994000) 
(74FC - 74FC9000) 
(6EE6 - 6EE89000) .\libaprutil.pdb
(6EE5 - 6EE59000) .\libapriconv.pdb
(6FF0 - 6FF42000) .\libhttpd.pdb
(6C92 - 6C928000) 
(664B - 66504000) 
(7758 - 777C6000) 
(70BD - 70C35000) 
(7171 - 71794000) 
(77A4 - 77B35000) 
(74F4 - 74F51000) 
(74F8 - 74F87000) 
(7CA0 - 7CA22000) 
(77C0 - 77C5E000) 
(7741 - 77488000) 
(7740 - 7741) 
(6FCF - 6FCF6000) 
(6FCD - 6FCD6000) 
(6FCC - 6FCC6000) 
(6FCB - 6FCB6000) 
(6FCA - 6FCA8000) 
(6FC8 - 6FC86000) 
(6FE2 - 6FE26000) 
(6FEA - 6FEA6000) 
(6FE9 - 6FE96000) 
(6FC4 - 6FC48000) 
(6FC3 - 6FC37000) 
(6FC2 - 6FC27000) 
(6FC1 - 6FC19000) 
(6FC0 - 6FC06000) 
(6FE5 - 6FE57000) 
(1000 - 10027000) 
(0084 - 00919000) 
(6FD0 - 6FD1F000) 
(0092 - 00C74000) 
(779A - 77A35000) 
(1F7D - 1F804000) 
(76B0 - 76B3F000) 
(1F8C - 1F8D9000) 
(0119 - 01199000) 
(013A - 013A8000) 
(013B - 013C) 
(013C - 013E7000) 
(7754 - 77571000) 
(0147 - 01477000) 
(0148 - 0148C000) 
(0149 - 01564000) 
(0157 - 01577000) 
(0158 - 0158B000) 
(0159 - 01665000) 
(0167 - 01701000) 
(77BD - 77BDF000) 
(0171 - 0172F000) 
(0173 - 01736000) 
(0174 - 018C3000) 
(018D - 018DA000) 
(018E - 0191F000) 
(0194 - 01949000) 
(0195 - 01956000) 
(0196 - 0198A000) 
(0199 - 019C2000) 
(019D - 019DC000) 
(019E - 01A23000) 
(01A4 -

#28054 [NEW]: debug_backtrace() bug

2004-04-19 Thread misu200 at yahoo dot com

From: misu200 at yahoo dot com
Operating system: Fedora Linux kernel 2.6.4
PHP version:  5.0.0RC1
PHP Bug Type: Unknown/Other Function
Bug description:  debug_backtrace() bug

Description:

I set my own error handle function and then i try to include a
non-existent file (aga.php).The problem is when i make a
var_dump(debug_backtrace()) in my error handle function it shows me wrong
results.

Reproduce code:
---
?php

function ourErrorHandler($errNo, $errStr, $errFile, $errLine)
{

echo PRE;
var_dump(debug_backtrace());
echo /PRE;
}


// set the user error handler to be the above 

$oldErrorHandler = set_error_handler(ourErrorHandler,
error_reporting());

require_once(aga.php);

?

Expected result:

array(2) {
  [0]=
  array(3) {
[file]=
string(28) /var/www/html/dir1/file2.php
[line]=
int(15)
[function]=
string(15) ourErrorHandler
  }
  [1]=
  array(4) {
[file]=
string(28) /var/www/html/dir1/file2.php
[line]=
int(15)
[args]=
array(1) {
 [0]=
 string(28) aga.php  - this should be here
}
[function]=
string(12) require_once
  }
}

Actual result:
--
array(2) {
  [0]=
  array(3) {
[file]=
string(28) /var/www/html/dir1/file2.php
[line]=
int(15)
[function]=
string(15) ourErrorHandler
  }
  [1]=
  array(4) {
[file]=
string(28) /var/www/html/dir1/file2.php
[line]=
int(15)
[args]=
array(1) {
 [0]=
 string(28) /var/www/html/dir1/file2.php - is wrong
}
[function]=
string(12) require_once
  }
}


-- 
Edit bug report at http://bugs.php.net/?id=28054edit=1
-- 
Try a CVS snapshot (php4):  http://bugs.php.net/fix.php?id=28054r=trysnapshot4
Try a CVS snapshot (php5):  http://bugs.php.net/fix.php?id=28054r=trysnapshot5
Fixed in CVS:   http://bugs.php.net/fix.php?id=28054r=fixedcvs
Fixed in release:   http://bugs.php.net/fix.php?id=28054r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=28054r=needtrace
Need Reproduce Script:  http://bugs.php.net/fix.php?id=28054r=needscript
Try newer version:  http://bugs.php.net/fix.php?id=28054r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=28054r=support
Expected behavior:  http://bugs.php.net/fix.php?id=28054r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=28054r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=28054r=submittedtwice
register_globals:   http://bugs.php.net/fix.php?id=28054r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28054r=php3
Daylight Savings:   http://bugs.php.net/fix.php?id=28054r=dst
IIS Stability:  http://bugs.php.net/fix.php?id=28054r=isapi
Install GNU Sed:http://bugs.php.net/fix.php?id=28054r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=28054r=float

#27485 [Asn-WFx]: OCI clob column objects inconsistent in result set

2004-04-19 Thread tony2001

ID: 27485
Updated by: [EMAIL PROTECTED]
Reported By: jseverson at myersinternet dot com
-Status: Assigned
+Status: Wont fix
Bug Type: Feature/Change Request
Operating System: Redhat Linux kernel 2.4.18-3
PHP Version: 4.3.4
Assigned To: tony2001
New Comment:

It would be NICE if PHP had a method of saving null into your
descriptor
so that you can keep your clobs consistent, since the presence of
empty
locators behave differently when selecting from them as compared with
null clobs.
there is no need in such method, NULL clobs/blobs/anything alse can be
saved using SQL:
INSERT INTO clobs_table (, clob_field) VALUES(,NULL);

Previous Comments:

[2004-03-05 18:43:16] [EMAIL PROTECTED]

I would classify this as a feature request then, assinging to the the
maintainer, Antony.

[2004-03-05 14:36:00] jseverson at myersinternet dot com

After several more hours of investigating, we have determined that our
first hypothesis was not true. I am not quite sure this is still a PHP
bug or not, as it seems like is more a case of a behavior of Oracle.
Here is a script I've setup to demonstrate the behavior:

http://test1.myersinternet.com/php_test/test_clobs.html

To briefly summarize, a clob can exist in two states, both of which
APPEAR to be null when viewing the clob in TOAD, TORA, or SQLPLUS. In
one state, the clob is actually null, which is the case where the
column is ommitted completely when doing an insert. The second case,
the clob is an empty locator, which is the case when specifying the
column in the insert, using the empty_clob() function, but then not
performing a save on the oci descriptor. My script demonstrates both of
these cases and their output.

Oracle Documentation explaining this behavior:

http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76940/adl02bs5.htm#117091

You can set an internal LOB -- that is, a LOB column in a table, or a
LOB attribute in an object type defined by you-- to be NULL or empty:

Setting an Internal LOB to NULL: A LOB set to NULL has no locator. A
NULL value is stored in the row in the table, not a locator. This is
the same process as for all other datatypes.

Setting an Internal LOB to Empty: By contrast, an empty LOB stored in a
table is a LOB of zero length that has a locator. So, if you SELECT
from an empty LOB column or attribute, you get back a locator which you
can use to populate the LOB with data via one of the six programmatic
environments, such as OCI or PL/SQL(DBMS_LOB).

[2004-03-05 02:42:00] [EMAIL PROTECTED]

The same results(i.e. allright) with 4.3.4.
By the way, PHP 4.3.4 was released before all these changes you're
talking about, in the early november, 2003.

[2004-03-04 12:22:05] jseverson at myersinternet dot com

Can you please try PHP version 4.3.4? We looked at the CVS log for the
OCI changes done and it looks like a lot of work was done in December,
2003 dealing with LOBs, which wouldn't be present in 4.3.3.

Thanks

[2004-03-04 01:59:26] [EMAIL PROTECTED]

I can't get your results with this code.
In both cases I get empty arrays, if OCI_RETURN_NULLS wasn't used or
array of NULLs, if it was.
Tested with PHP5-cvs, PHP4-cvs, PHP4.3.3.

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/27485

77 matches

Mail list logo