topic HPWS Apache with PHP and Oracle in Operating System - HP-UX

HPWS Apache with PHP and Oracle

Griffel — Thu, 04 Aug 2005 12:03:44 GMT

Hello, who can help?

The designers of the hpws distribution can particularly help me.

I have 2 problems with the HP Webserver distribution HPUXWSATW-A212 and
the modul php and the oracle library oci8.sl.

#1
The webserver software hpws was installed without bugs with swinstall.
A problem was start this from the comand linie version of php und pear.

Error message : "/usr/lib/dld.sl: Can´t open shared library: /CLO/BUILD_ENV/lib/libdld.2"
"/usr/lib/dld.sl: No such file or directory"

I have made a directory /CLO/build and made a connection to /usr in this directory.
This is a bad away but php and pear works.
However, cause is the faulty distribution of the software of HP.

#2
The Error message ist "Unable to load dynamic library /opt/hpws/apache/php/lib/php/extensions/oci8.sl' -
Invalid flags for dlopen: /opt/hpws/apache/php/lib/php/extensions/oci8.sl in Unknown on linie 0

The client is installed by Oracle 9.2 on the HPUX 11.11 server.
I have put all Enviroment variables ORACLE_HOME,SH_LIBPATH,SD_LIBRAY_PATH and LD_PRELOAD in apachectl for oracle.
The problem is probably hidden here, too.
The output by ld -t oci8.sl is : Can`t open /opt/oracle/lib/libclntsh.sl.8.0.
The same result at chatr oci8.sl.
When I make a soft link from libclntsh.sl.9.0 on libclntsh.sl.8.0, the Error message is : "bad magic nummber e.g.".

However, I don't have any client for Oracle 8 and he doesn't have to be got any more, too.

Many thanks!

Re: HPWS Apache with PHP and Oracle

Steven E. Protter — Thu, 04 Aug 2005 12:12:33 GMT

Couple of things.

The error message in section 1 is usually caused by the wrong value or missing directory in the SHLIB_PATH variable.

That being said, Oralcle ships with its own httpd server which is based on apache.

There are pieces of Oracle that are built on Oracle 8 components. The error message is misleading to a great degree.

This problem is also most likely to be an environment variable. Oracle's manual for the 9.2 database is very specfic and needs to be followed concerning patching and required environment varibables and patching and optional products.

The soft link solution you tried is innnovative, but not the answer.

If you are running a mixed Oracle 8/9 environment, I have a few tools developed that might help you handle envrionment switching issues.

If you have some reason to use the HP version of apache and php et al, then make sure the SHLIB_PATH variable at install time includes those tools you have already installed, which are in the /opt/hpws directory.

SEP

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Thu, 04 Aug 2005 21:03:20 GMT

You may have better luck if you link /opt/oracle/lib/libclntsh.sl.8.0 to $ORACLE_HOME/lib32/libclntsh.sl.9.0.

$ORACLE_HOME/lib/libclntsh.sl.9.0 is 64-bit library and it won't load in HP's apache, which is 32-bit.

$ORACLE_HOME/lib32/libclntsh.sl.9.0 is 32-bit library, so linking to it may work.

Re: HPWS Apache with PHP and Oracle

Griffel — Fri, 05 Aug 2005 09:12:04 GMT

Many Thanks Steven and Ermin,

but it don`t help me.

#1 -I have reinstall hpws
export /ORACLE/HOME="/opt/oracle/products/9ir2
export SHLIB_PATH=/usr/lib:/usr/local/lib:/opt/hpws/apache/lib:/$ORACLE_HOME/lib:/$ORACLE/HOME/lib32:/opt/hpws/apache/php/lib/php/extensions
export LD_PRELOAD=$ORACLE_HOME/JRE/lib/PA_RISC/native_threads/libjava.sl

- swinstall -s /daten/HPUXWSATW-A212-1100.depot

The same error as under exactly 1.
The /CLO/BUILD_ENV is in the file php-config written.
The variable extension_dir is also put wrongly.Swinstall set the oci8.sl under
/opt/hpws/apache/php/lib/php/extensions.

See appendix file php-config.

#2 I have made a softlink of libclntsh.9.0 (lib32)to libclntsh.8.0 . Without success.
However, another path is registered in the library oci8.sl. With this command chatr to see.
The location for the client oracle client library is /$ORACLE_HOME/lib/libclntsh.sl.9.0 or. .../lib32/lib...
The oci8 path for the client library is /opt/oracle/lib/libclntsh.sl.8.0

I wish a beautiful weekend!

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Sun, 07 Aug 2005 19:37:28 GMT

Please try the following

$ cd $ORACLE_HOME/lib32
$ ln -s libclntsh.sl.9.0 libclnsth.sl.8.0
$ export SHLIB_PATH=$ORACLE_HOME/lib32
$ ldd /opt/hpws/apache/php/lib/php/extensions/oci8.sl

ldd shouldn't return any errors and it should show you that oci8.sl picked up oracle library from $ORACLE_HOME/lib32.

If all is ok, make sure you export SHLIB_PATH as described above before starting apache.

Re: HPWS Apache with PHP and Oracle

Griffel — Mon, 08 Aug 2005 05:44:58 GMT

Hello Ermin

I have done everything as you it write that way. There is no more error message at the call ldd .../oci8.sl. The apache brings no more error either in the error_log file.
There is an error but if I invoke on the intenet explorer test webfile oracle.php :

Fatal error: Call to undefined function OCILogon() in /opt/hpws/apache/htdocs/oracle.php on line 30

I have put the line extension=oci8.sl and the line extension_dir = /opt/hpws/apache/php/lib/php/extensions in the file php.ini.

Do you have an idea?

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Mon, 08 Aug 2005 05:57:16 GMT

Please make sure ORACLE_HOME is defined (and exported) in the apache startup script.

Re: HPWS Apache with PHP and Oracle

Griffel — Mon, 08 Aug 2005 06:07:30 GMT

Yes i have put it. Enclosed means file apachectl.

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Mon, 08 Aug 2005 06:31:30 GMT

It looks like apache didn't load oci8.sl.

Can you create a simple php file that calls phpinfo() and see if oci comes up in the list?

Are there any errors in apache logs?

Re: HPWS Apache with PHP and Oracle

Griffel — Mon, 08 Aug 2005 07:07:12 GMT

I have already made this. OCI doesn't occur.
No errors in the apache error_log.

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Mon, 08 Aug 2005 18:38:48 GMT

Sorry, no more suggestions except to double check your php.ini again and make sure oci.sl is uncommented. You have modified the one in /opt/hpws/apache/conf/php.ini, haven't you?

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Tue, 09 Aug 2005 00:11:22 GMT

One more thought ... does file $ORACLE_HOME/JRE/lib/PA_RISC/native_threads/libja
va.sl exist?

What happens when you try this?

$ export SHLIB_PATH=$ORACLE_HOME/lib32
$ LD_PRELOAD=$ORACLE_HOME/JRE/lib/PA_RISC/native_threads/libja
va.sl /opt/hpws/apache/php/bin/php -c /opt/hpws/apache/conf/php.ini -f /opt/hpws
/apache/htdocs/oracle.php

Re: HPWS Apache with PHP and Oracle

Griffel — Tue, 09 Aug 2005 03:34:58 GMT

Hello Ermin

I find it this well you have left at the thing.
You have taken me to the right track.

Row extension=oci8.sl isn't commented any more now in php.ini.
$ORACLE_HOME/JRE/lib/PA_RISC/native_threads/libja
va.sl exist.
When i make this LD_PRELOAD=$ORACLE... php -c ...php.ini ...htdocs/oracle.php
then i have new warning of php :" PHP Startup : Unable to load dynamic lbraray '/opt/hpws/apache/php/lib/php/extensions/php_oci8.sl <-- this is wrong, the file php_oci8.sl don`t exist ,
osi8.sl is exist.
File php.ini contains entries ;extension=php_oci8.dll. I have copy the row, unkomment and only change dll in sl. At the first enquiry on ITC, however, I had written the line newly extension=oci8.sl.
The error was still the missing library libclntsh.sl.8.0 here.
The script oracle.php works now.Many Thanks for your help.

A problem still is, if I start php on the commandline. The error message "Can`t open shared library : /CLO/BUILD_ENV/usr/lib/libdld.2".
I only could solve this problem, if I have put a soft link on /usr/lib /CLO/BUILD_ENV/usr/lib .

Re: HPWS Apache with PHP and Oracle

Ermin Borovac — Tue, 09 Aug 2005 04:08:48 GMT

To fix the php binary problem all you need to do is enable use of SHLIB_PATH.

# chatr +s enable /opt/hpws/apache/php/bin/php

chatr listing on php binary should now show that use of SHLIB_PATH is enabled (it was previously disabled).

Now make sure you have /usr/lib in your SHLIB_PATH and php should work from the command line as well (and you can also remove link to /CLO/BUILD_ENV ...).

Not sure why this problem exists, but hopefully that works for you.

Re: HPWS Apache with PHP and Oracle

Griffel — Tue, 09 Aug 2005 04:46:35 GMT

Has immediately worked. The good tips have helped me very much. Thanks.

Re: HPWS Apache with PHP and Oracle

Griffel — Tue, 09 Aug 2005 04:54:30 GMT

Sorry, I have forgotten to assign the points.