CSWS/PHP Oracle9 connectivity

[berlioz]

Hello,

With CSWS 2 (apache)/PHP under OpenVMS 7.3.2 i'm actually trying to interface an Oracle 9i database located on the same server with no success.

In my php.ini i've uncommented "extension=php_oracle.exe"
In my apache$www:[000000]login.com i've added @orauser.com

But... no connexion at that time... (php:ora_logon failed)

Some can help me ?
thanks in advance for all

[John Gillings]

berlioz,

I'd expect the process to be running under username APACHE$WWW or similar. Is that username authorized to access the database? Is there some way for your end user to provide a username/password to be used to login?

[Martin Vorlaender]

From http://h71000.www7.hp.com/openvms/products/ips/apache/csws_php_relnotes.html#oci8ext I read that you need to define logical APACHE$OCI_SHR.

What does http://your.server/php/php_info.php say about Oracle connectivity (should appear in the "additional modules" section)?

cu,
Martin

[berlioz]

Martin,

About CSWS_PHP installation Guide and release notes, OCI8 extension :

The problem is that i'm currently using Oracle 9 and there's no ora_root:[UTIL] directory on my server. So i actually don't know how define APACHE$OCI_SHR logical...

But he documentation says that it works with any Oracle 8 and Oracle 9 database server, so i'm just looking for the right solution for Oracle 9

[berlioz]

and no ORACLIENT_Vxxx.EXE too

[Martin Vorlaender]

AFAIK, you have to install the client separately from the database.

And mind you: I'm no Oracle expert...

cu,
Martin

[berlioz]

Here's the output for php_info.php

ORACLE

Oracle Support enabled
Oracle Version no value
Compile-time ORACLE_HOME no value
Libraries Used no value

is it normal to have "no_value" for all oracle parameters ?

[J.M]

berlioz,

define APACHE$OCI_SHR as :[.lib32]libclntsh.so" and try again

[Martin Vorlaender]

berlioz,

I get the same output from php_info on a system here:

OpenVMS 7.2-1H1
CSWS 1.3
CSWS_PHP 1.1
ORACLE 8.1.7

And I *do* have an ORACLIENT_V817.EXE.
I've not yet tried to connect to the database

cu,
Martin

[Daniel Fernandez Illan]

Hi Berlioz

If you need install some Oracle product you can use "oracleins" symbol (login with oracle user).

This procedure show a menu that allow install components of ORACLE, including UTIL directory.

Best regards