php+oracle

Anon

Apache 1.3.17
PHP 4.0.4pl1
Red Hat 6.2
Oracle 8.1.7

I have an Oracle database (Oracle 8.1.7) running on one server and Apache (1.3.17), PHP (4.0.4pl1) and Linux (Red Hat 6.2) running on another machine. PHP is running as a module of Apache. PHP was compiled without Oracle support and I need to keep MySQL support.

What do I need to do in this server to access the Oracle DB? Is it necessary to re-install PHP? Can anyone help me?

Thank you.

Anon

You will need to re-configure and compile PHP to support Oracle also. You will need to have access to the Oracle libraries to get the compilation to work properly, but if you can run sqlplus or any other Oracle program from your web server then you shouldn't have any problems. PHP needs the Oracle environment variables set for it to compile with Oracle support properly.

Anon

any way to get the php function dl("Maybe_oracle.so") to dynamically load the module,,if your hosting company did not compile with oracle?

what about the dl() function?

anyone ever used it?

Ken

Anon

I am trying to compile PHP with support Oracle (oci8)
But the Apache doesn't start

Starting httpd: Syntax error on line 875 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/libphp4.so into server: libclntsh.so.8.0: cannot open shared object file: No such file or directory
[FAILED]

Other informations:
Red Hat 6,2
Php 4.1pl1
Oracle 8.1.5...

HELP-ME, PLEASE!!!!

Anon

Well it tells you exactly what is wrong, you compiled PHP with support for libclntsh.so.8.0, but apache can't find this shared object. Does Apache have the proper environment variables set up?

Anon

I compiled PHP like this:

./configure --with-apxs --with-oracle=/usr1/oracle/product/8.1.0.5/ --with-oci8=/usr1/oracle/product/8.1.0.5/ --enable-track-vars

The Apache doesn't start:

[root@uaberta modules]# ldd libphp4.so
libpam.so.0 => /lib/libpam.so.0 (0x40121000)
libdl.so.2 => /lib/libdl.so.2 (0x40129000)
libresolv.so.2 => /lib/libresolv.so.2 (0x4012d000)
libm.so.6 => /lib/libm.so.6 (0x4013c000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4015a000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40187000)
libclntsh.so.8.0 => not found
libc.so.6 => /lib/libc.so.6 (0x4019d000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
[root@uaberta modules]#

I tried to do a link in /lib:
ln -s /usr1/oracle/product/8.1.5/lib/libclntsh.so.8.0 /lib/libclntsh.so.8.0

The Apache started, but the server is not accessible!!!

Thanks,

Anon

Check your environment variables to see if you have ORACLE_BASE, ORACLE_HOME, LD_LIBRARY_PATH, and ORACLE_SID set. The user you used to complie PHP probably has these set and your Apache user (www, or nobody) probably doesn't. Or the user you are using to start Apache (root) doesn't have these set, or set properly.

Anon

I tried to set:

LD_LIBRARY_PATH=/usr1/oracel/product/8.1.5/lib
export LD_LIBRARY_PATH

I compiled the php e started the Apache. OK!!!
The Apache found the libs, but the server is not accessible, as if it was not running.

Anon

I'm not an Oracle DBA so I don't know how much help I'm being, but did you check that all of the Environment variables that I mentiond were set properly. When I've tried to start my web server without these set it always crashed. Maybe you need to have the OracleSID value set to make the connection work.