|
|
Posted by rtconner on 11/18/48 11:38
Andy Hassall wrote:
> On 28 Jan 2006 09:15:01 -0800, "rtconner" <rtconner@gmail.com> wrote:
>
> >I just installed Apache 1.3/PHP 5 on my Windows XP compy. It works
> >fine. Now I want to get the interface to Oracle 9 installed.
> >
> >My computer has instant client 10 installed, I regularly use sqlplus
> >and can connect to the Oracle DB with python without problem.
> >
> >I uncommented the 'extension=php_oci8.dll' line in php.ini. Now I
> >recieve a "Fatal error: Call to undefined function oci_connect()" when
> >I try to use php to connect to the oracle database.
> >
> >What is going on here? I don't understand what I did wrong.
>
> If you did a straightforward installation then the usual thing to watch for is
> that the Oracle software won't be accessible by the local service user that
> Apache (and hence PHP runs as). Check the permissions on your Oracle directory
> - your interactive user will be able to use it, as you're already using
> sqlplus, but probably not the user Apache runs as. An alternative is to get
> Apache to run under your user account by modifying the service, but make sure
> you realise the possible security implications before doing that.
>
> Also make sure that the Oracle home is on the PATH environment variable _as
> seen by the Apache process_ - i.e. set as a global environment variable, not
> just a user environment variable.
>
> Were there any errors (either message boxes, or in the Windows Event Log) when
> you started Apache that indicates that it couldn't load php_oci8.dll? Usually
> these then leads to information about a problem with PHP loading the Oracle
> client DLL due to the issues above.
well that was a stroke of genius. I checked the log find the
php_oci8.dll file. I apparently needed to set the extension_dir
directive. and, well everything seems to be working at least a little
better now.
i now get and unkown windows apache.exe exception when I run queries.
but that seems unrelated to this problem.
thanks for the help. I'll play with exception and see what I can do to
remedy it.
-rob
Navigation:
[Reply to this message]
|