oci8 extension issues with PHPMapScript

[Jeff McKenna]

• reported by Björn Danielsson:

I commented php_oci8_11g.dll in the ini-file as you said and ran phpinfo twice, once with the libmap.dll for Oracle and once with the standard libmap.dll.
 
With the standard libmap.dll MapScript is loaded, but with the libmap.dll for Oracle neither oci8 nor MapScript is loaded.
 
The only uncommented modules in my ini-file now are php_curl, php_fileinfo, php_gd2, php_intl and php_mapscript. The error messages in Apaches error.log disappeared when php_mbstring and php_exif were commented.
 
Mapserv -v shows INPUT=ORACLESPATIAL.
So it seems to be a php/oracle problem.
 
I use oracle instantclient_11_2 while in 3.1.0 the name is oracle12. Is that an issue? Oracle versions?

[Jeff McKenna]

A good resource for PHP with oci8 extension: ​http://www.oracle.com/technetwork/articles/dsl/technote-php-instant-084410.html

[Jeff McKenna]

• added missing php_oci8*.dll files to \ms4w\Apache\php\ext\
• needs more testing & feedback
• try MS4W 3.1.1 at ​http://www.ms4w.com/release/ms4w_3.1.1.zip

[Bjorn1234]

Hi,

I have tried version 3.1.1.

Both oci8 and php_mapscript are loaded.
However, there is a problem with environment variable PATH. oci_pconnect to Oracle returns: oci_pconnect(): OCIEnvNlsCreate() failed.'....please check that PATH includes the directory with Oracle Instant Client libraries ...'.

phpinfo's environmental variable PATH just contains /ms4w/Apache/cgi-bin, which is the content of Apache's conf-file SetEnv PATH. After having commented SetEnv in the conf-file and restarted Apache phpinfo now shows all items in the registry PATH, just like version 3.0.6 does. Unfortunately this does not solve the PATH problem with oci_pconnect(), which still can't find the Oracle Instant Client libraries. I have not tried to copy all the contains from /Oracle/instantclient_11_2 to /Apache/cgi-bin which perhaps might work. It seems a bit too rough a measure.

I have no idea what to try next.

Björn D

[Bjorn1234]

Hi,

Got it working!

After some thinking I remembered that I after getting errors moved oci.dll from oracle instant client to apache/cgi-bin as a test. When I just now deleted oci.dll from cgi-bin and commented PATH in the conf file it all worked.

So the remaining problem seems to be that SetEnv PATH in the conf file blocks PATH from the registry.

Björn D

[Jeff McKenna]

Thank you for this research. This will help for the next build. I'll leave this ticket open until it is resolved.

[Jeff McKenna]

This Apache PATH change is available in today's MS4W 3.1.2 release. Please download and test: ​http://ms4w.com

[Jeff McKenna]

Closing. Please re-open if issue still occurs with MS4W 3.1.2 release