Re: Extremely Urgent: Problem with PHP and Oracle

Justin Patrin <papercrane@xxxxxxxxxxxxxxx> · Wed, 09 Jun 2004 23:16:12 -0700

Charles Morris wrote:

Hello all, I have recently been working with OCI and when I use OCILogon
[wethere with example scripts or my own code] I get a "PAge cannot be
displayed" (like DNS error) when I naviagte to the page. When I comment
out the OCILogon part it works great exept for the oracle part. I am able
to accesss the database from Perl, the built in SQL*PLUS and other
languages.- The only problem is this. I have to have this working by
friday morning and I cannot risk not mailing this alias; so please any
help is greatly appreciated!!

Here are my code snippets:

dbconnection.php
<?php
class OracleConnection
{
  var $CONN = "";
  var $IPADD = "*.*.*.*";
  var $USER = "****";
  var $PASS = "********";
  var $SID = "****";

  function fatal_error($text)
  {
    $maillink = '<a href="mailto:cmorris@xxxxxxxxxx";>network administrator</a>';
    echo "<b>Fatal Error. </b><br>";
    echo "[$text] ( 0 : 0 ) <br>";
    echo $_SERVER['HTTP_USER_AGENT'];
    echo "<br>";

    echo "ORACLE_SID: ".getenv("ORACLE_SID")."<BR>ORACLE_HOME: ".getenv("ORACLE_HOME"."<BR>";

    $error = OCIError();

    if ($error["offset"])
    {
       $sqltext = substr ($error["sqltext"], 0, $error["offset"]) . '*' . substr ($err ($error["sqltext"], $error["offset"]);
    }
    else
    {$sqltext = "No OCI error.";}

    echo $sqltext;
    echo "<BR>Contact the $maillink with this message.\n";
  exit;
  function init()
  {
    putenv("ORACLE_SID=PROJ");
    putenv("ORACLE_HOME=/home/oracle9");

    $ipadd = $this->IPADD;
    $user = $this->USER;
    $pass = $this->PASS;
//    $dbase = $this->DBASE;
//    $dbase = $DBAC_BEGIN . $DBAC_PROTO . $DBAC_HOST . $DBAC_PORT . "))" . $DBAC_COTD . ")";
    $dbase = "(DESCRIPTION=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 128.*.*.*)(PORT = 1521)))(CONNECT_DATA=(SID=PROJ)))";

// use for PHP 5.0 and greater
//    $conn = oci_connect($user, $pass, $dbase) || $this->fatal_error("Connection could not be established with server [$ipadd]");

// use for PHP 4.91 and lower
    $conn = ociplogon($user, $pass, $dbase) || $this->fatal_error("Connection could not be established with server [$ipadd]");

    $this->CONN = $conn || $this->fatal_error("Connection could not be stabalized, unable to continue.");

  return true;
  }

//end class: 'OracleConnection'
}

--eof--

Also, could someone please send me a working example of using variables
appended to text with "array()"? I am a long time experienced perl
programmer and I have tried using the . operatore a + but no luck.

Thanks everyone!!!

Please excuse types, typing on a 14.4 connection.

-------------------------------------------------------------------------------
Charles Morris
        cmorris@xxxxxxxxxx

CS Systems Group		Old Dominion University
http://www.cs.odu.edu/~cmorris
http://www.cs.odu.edu/cspage/systemstaff.html
------------------------------------------------------------------------------
They that give up essential liberty to obtain
a little temporary safety deserve neither
liberty nor safety. -- Benjamin Franklin, 1759
The only secure computer is one that's unplugged, locked in a
safe, and buried 20 feet under the ground in a secret location...
and i'm not even too sure about that one"--Dennis Huges, FBI.

On first glance, your fatal_error function doesn't seem to have an ending }.

I have tried putenv myself and it doesn't seem to work for Oracle 
connections. Putting those in your shell environment, then restarting 
apache. Check to see if the env vars are set from a PHP script (without 
using putenv to set them of course).

--
paperCrane <Justin Patrin>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php