NYCPHP Meetup

NYPHP.org

[nycphp-talk] PHP5, Oracle 9i, failure to connect

Nathan Lavertue nd at lavertue.com
Wed Aug 25 17:16:44 EDT 2004


Yea... pretty certain. We had tried to setup the dev Oracle
environment too... (on Mac OS X) but it was getting too
complicated, and I was able to access the db remotely... and
since I had configured PHP with the Oracle libraries that *did*
get installed... things should be ok.  We seemed to have some
issues, possibly, with the Apache setup. I had to add the
following to the apachectl binary file...

ORACLE_HOME=/Users/oracle/Source/9iR2
export ORACLE_HOME
TNS_ADMIN=/Users/oracle/Source/9iR2/network/admin
export TNS_ADMIN

... we get some kind of connection, but the query seems to be
*stuck*.

Thanks... we'll be keep on rollin' here.
..................
nd lavertue // .flash.soldier/pixel.terrorist.
...................
lavertue.com // mutemuse.com
...................


--/ Adam Maccabee Trachtenberg
> On Wed, 25 Aug 2004, Nathan Lavertue wrote:
>
>> I just finished working on a development project creating
>> charts with data from a MySQL database using the GD 2.0
>> libraries. However, the database where this will be
>> implemented
>> is Oracle 9i. I have access to it remotely, from my
>> workstation, but I've only been able to connect via a
>> shell...
>> not using PHP.
>
> I've never used Oracle with or without PHP, but are you sure
> your copy
> of PHP (or the Web server that's running it) runs in an
> environment
> where all the necessary Oracle environment variables have been
> set?
>
> See http://www.php.net/oci8 for more information.
>
> I can tell you've done this for your account, but I'm not sure
> you've
> done the same for the user Apache is running as.
>
> -adam
>
> --
> adam at trachtenberg.com
> author of o'reilly's "upgrading to php 5" and "php cookbook"
> avoid the holiday rush, buy your copies today!
> _______________________________________________
> New York PHP Talk
> Supporting AMP Technology (Apache/MySQL/PHP)
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.newyorkphp.org
>



More information about the talk mailing list