ID: 31038
User updated by: damien dot harper at keops dot net
Reported By: damien dot harper at keops dot net
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Red Hat 8
PHP Version: 4.3.10RC2
New Comment:
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 ?
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2004-12-14 18:32:35] damien dot harper at keops dot net
Isn't that MPM related ?
------------------------------------------------------------------------
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
