ID: 31038
Updated by: [EMAIL PROTECTED]
Reported By: damien dot harper at keops dot net
-Status: Open
+Status: Assigned
Bug Type: OCI8 related
Operating System: Red Hat 8
PHP Version: 4.3.10RC2
-Assigned To:
+Assigned To: tony2001
New Comment:
Give me some time for testing.
ATM I can tell only that Apache2 is not recommended for production
environment and this will not be changed in the nearest future. At
least, you should use prefork if you have to stick with Apache2.
Previous Comments:
------------------------------------------------------------------------
[2004-12-14 19:52:14] damien dot harper at keops dot net
I'd prefer to stick with 4.x.x branch for compatibility.
It will be used on a production server and we can't loose time to check
that everything is OK with PHP 5.x now.
Nobody has any idea how to solve this trouble ?
------------------------------------------------------------------------
[2004-12-14 19:33:33] [EMAIL PROTECTED]
Are you able to try latest release from 5.0.x branch?
------------------------------------------------------------------------
[2004-12-14 18:57:24] damien dot harper at keops dot net
Wooops, I forgot the interesting part of the included file
fonctionsDb.php :
<?php
...
function connection(){
global $errorCode,$test;
$host = "172.16.0.7";
$port = "1521";
$service = "ORACLE9";
$user = "sirenet";
$pwd = "sirenet";
$db="(DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)
(HOST=$host)(PORT=$port)
)
)
(CONNECT_DATA=(SERVICE_NAME=$service))
)";
if ($test==1){
$conn = ocilogon($user,$pwd,$db);
} else {
$conn = @ocilogon($user,$pwd,$db);
}
if ($conn==""){
$errorCode = 2;
}
return $conn;
}
function deconnection($conn){
ocilogoff($conn);
}
...
?>
------------------------------------------------------------------------
[2004-12-14 18:54:28] damien dot harper at keops dot net
PHP 4.3.10RC2
Oracle 9 database
Oracle 9.2.0.1 client
Everything works fine using command line : php myscript.php gives me
expected results
export ORACLE_SID="ORACLE9"
export ORACLE_HOME="/home/oracle/OraHome1"
export LD_LIBRARY_PATH="/home/oracle/OraHome1/lib"
export TNS_ADMIN="/home/oracle/OraHome1/network/admin/tnsnames.ora"
export NLS_LANG="English_America.WE8ISO8859P1"
here is the script :
<?php
include "queries/fonctionsDb.php";
$username = "sirenet";
$passwd = "sirenet";
$host = "172.16.0.7";
$port = "1521";
$service = "ORACLE9";
//$db="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=$host)(PORT=$port)))(CONNECT_DATA=(SERVICE_NAME=$service)))";
$db="SIRENET";
$conn = connection();
if (!$conn) {
echo "Connection failed";
echo "Error Message: [" . OCIError($conn) . "]";
exit;
} else {
echo "Connected!"."\n";
$parse=OCIParse($conn,"select nom from chevaux");
OCIExecute($parse,OCI_DEFAULT);
echo "\nRecuperation de donnees\n";
$nrows = ocifetchstatement($parse, $rs, 0, 100,OCI_NUM);
$resultTab = "";
$numCol = 0;
for ( $iRow = 0; $iRow < $nrows;
$iRow++ ) {
reset($rs);
while ( $column = each($rs) )
{
$data =
$column['value'];
$resultTab[$iRow][$numCol] = $data[$iRow];
echo
$iRow.'|'.$numCol.'|'.$resultTab[$iRow][$numCol];
$numCol++;
}
$numCol = 0;
}
OCIFreeStatement($parse);
deconnection($conn);
}
?>
------------------------------------------------------------------------
[2004-12-14 18:45:23] [EMAIL PROTECTED]
It works fine on a number of OSes, Web-servers etc.
And I still can't see how can I reproduce your problem, as it works
perfect for me.
Try it with *officially* supported Apache version (as Apache2 is
officially NOT recommended), try to run the same code using CLI
version.
And, please, give me your environment variables values and other
additional info, so I'll be able to debug it.
------------------------------------------------------------------------
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/31038
--
Edit this bug report at http://bugs.php.net/?id=31038&edit=1
