[Gusdev-rad-issues] Oci8 and oracle

[Juan C. P. <bi...@ge...>]

I'm testing out the web pages that were created, and I'm not getting pages
to load in the browsers properly.  I have edited php.ini to allow registered
globals for the cookies. I enabled php in apache and have ORACLE_HOME set.
I had to edit my user_registration.php file because it was calling require()
which was not set to the right db-include for me, so I had to specify it
directly.  When I run on the command line, the web pages seem to work just
fine, and I see all the HTML and javascript spit out to STDOUT, BUT I get
the following error in my error log:

    [30-Nov-2005 12:08:37] PHP Warning:  ora_getcolumn(): Ora_Fetch failed
    (ORA-01002: fetch out of sequence -- while processing OCI function
    OFETCH/OFEN) in /usr/local/apache2/htdocs/misc/user_registration.php on
    line 153

I assume this has something to do with the issues in compiling PHP with OCI8
and with oracle.  

When I try to run user_registration.php from the web-browser, I get a blank
page, and I get the following in the error log:

    [30-Nov-2005 12:10:22] PHP Warning:
    dbConnectionSetup(/home/oracle/RADSA_2.0.0/db-include.inc) [<a
    href='function.dbConnectionSetup'>function.dbConnectionSetup</a>]:
    failed to open stream: Permission denied in
    /usr/local/apache2/htdocs/include/php/db.inc on line 6

    [30-Nov-2005 12:10:22] PHP Fatal error:  dbConnectionSetup() [<a
    href='function.require'>function.require</a>]: Failed opening required
    '/home/oracle/RADSA_2.0.0/db-include.inc'
 ---(include_path='.:/usr/local/apache2/htdocs/include/php/:./include/php:..
----/include/php') in /usr/local/apache2/htdocs/include/php/db.inc on line 6

My permissions are 777 for all these include files and directories, so I
don't think the web user is having issues with permissions.  I don't know
what else could be necessarily different between the apache user and myself
(as 'oracle' user), unless I'm not realizing some other environment
variables set improperly or not set at all.

Juan