topic Re: CSWS/PHP Oracle9 connectivity in Operating System - OpenVMS

CSWS/PHP Oracle9 connectivity

berlioz — Mon, 15 Nov 2004 11:38:58 GMT

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

Re: CSWS/PHP Oracle9 connectivity

John Gillings — Mon, 15 Nov 2004 21:16:50 GMT

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?

Re: CSWS/PHP Oracle9 connectivity

Martin Vorlaender — Tue, 16 Nov 2004 02:28:18 GMT

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

Re: CSWS/PHP Oracle9 connectivity

berlioz — Tue, 16 Nov 2004 03:41:34 GMT

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

Re: CSWS/PHP Oracle9 connectivity

berlioz — Tue, 16 Nov 2004 03:42:39 GMT

and no ORACLIENT_Vxxx.EXE too

Re: CSWS/PHP Oracle9 connectivity

Martin Vorlaender — Tue, 16 Nov 2004 03:47:31 GMT

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

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

cu,
Martin

Re: CSWS/PHP Oracle9 connectivity

berlioz — Tue, 16 Nov 2004 03:51:33 GMT

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 ?

Re: CSWS/PHP Oracle9 connectivity

J.M — Tue, 16 Nov 2004 05:25:30 GMT

berlioz,

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

Re: CSWS/PHP Oracle9 connectivity

Martin Vorlaender — Tue, 16 Nov 2004 06:25:12 GMT

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

Re: CSWS/PHP Oracle9 connectivity

Daniel Fernandez Illan — Tue, 16 Nov 2004 07:36:24 GMT

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

Re: CSWS/PHP Oracle9 connectivity

berlioz — Tue, 16 Nov 2004 11:03:28 GMT

Martin, Milan,

According to a post in google comp.os.vms group, it seems that the HP CSWS/PHP installation and released notes doc is false.

We have to define PHP$OCI_SHR and not APACHE$OCI_SHR in login.com in order APACHE/PHP to work with OCI.

The right syntax for Oracle 9i seems to be something like :
define php$oci_shr ora_root:[lib32]libclntsh.so

Re: CSWS/PHP Oracle9 connectivity

Martin Vorlaender — Wed, 17 Nov 2004 03:32:24 GMT

Hi,

I dug a little deeper inside the application development docs, and found that linking is documented as by using ORA_UTIL:LOUTL.COM. On my Oracle8 system the link with shared OCI image in that DCL procedure references ORA_OLB:ORACLIENT.OPT, which contains the line "ora_util:oraclient_V817/shareable".

So for my system, ORACLIENT_V817.EXE seems to be the right shareable image. YMMV with your V9.

cu,
Martin

Re: CSWS/PHP Oracle9 connectivity

berlioz — Thu, 18 Nov 2004 08:23:59 GMT

Here's my situation at that time (after 3 days of hard work... lol)

that's what i've done in apache$www login.com.
$!
$ @ora_root:[000000]orauser
$!
$ define php$oci_shr ora_root:[lib32]libclntsh.so
$ define apache$oci_shr ora_root:[lib32]libclntsh.so
$ define php$oci_pfx " "
$ !

Here's my php/oracle test script :
putenv("ORACLE_HOME=dka0:[produit.oracle]");
putenv("ORACLE_SID=PC1CA2");
putenv("LD_LIBRARY_PATH=dka0:[produit.oracle.lib32]");
putenv("TNS_ADMIN=dka0:[produit.oracle.network.admin]tnsnames.ora");
putenv("TWO_TASK=dka0:[produit.oracle.network.admin]tnsnames.ora");
putenv("ORACLE_BASE=dka0:[produit]");
$username = "valerie";
$paswd = "bei";
$db ="(DESCRIPTION =
(ADDRESS =
(PROTO = TCP)
(HOST = PC1CA2)
(PORT = 1521)
)
(CONNECT_DATA = (SID = PC1CA2))
)";
echo "

Attempting database connection...

";
$db_conn = ocinlogon($username, $paswd, $db);
if (!$db_conn)
{
echo "...FAILED. Check the username, passwd, dbstring given in this script are valid or not.

";
if (OCIError($db_conn))
{
$erra=OCIError($db_conn);
dodberror("SQL Error: $erra[code] $erra[message]");
}
exit;
}
else
{
echo "

Connected...

";
}

$stmt = ociparse($db_conn, "select type_op,nom_op from acces");
if (!$stmt)
{
echo '

parsing error

';
}
if (!ociexecute($stmt,OCI_DEFAULT))
{
echo "

query execute error!

";
}
echo "\n";
$ncols = OCINumCols($stmt);
echo "\n";

for ($i = 1; $i <= $ncols; $i++) {
$column_name = OCIColumnName($stmt,$i);
echo "\n";
}

while (OCIFetch($stmt))
{
echo "\n";
for ($i = 1; $i <= $ncols; $i++)
{
$column_value = OCIResult($stmt,$i);
echo "\n";
}
echo "\n";
}

echo "\n";
echo "

$column_name

$column_value

\n";

OCIFreeStatement($stmt);
OCILogoff($db_conn);

Now my php script connect to the database but i've a strange error when i'm
strying to select data
When drawn out from bases column is of type int (number) all is ok.
Data are presented on page, but when I drawing out of given type
Varchar (eg. name) then it doesn't work (white page without ORA error)!
I've tried to modify NLS_LANG environnement variable without any success, but
an Ora 12705 Invalid or unknown NLS parameter value specified.
What's the trouble ? environment problem ? NLS problem ? OCI pb ?

What is the best way to define environment variable : in login.com ? in php script ?

I need a way...

Re: CSWS/PHP Oracle9 connectivity

Bojan Nemec — Thu, 18 Nov 2004 09:01:33 GMT

Berlioz,

In php putenv is probably a wrapper arround the C function putenv. This comes from the *NIX world. This function works fith environment variables which dont exist in VMS. The closest to this are VMS symbols. But the VMS setenv and putenv does not set any VMS symbols! The values set by these routines are visible only from the program.

Maybe you can debug what is defined using the php function passthru() (passthru("show symbol/all") and passthru ("show logical")).

But if you define all symbols and logical names in login.com this will work.

Bojan

Re: CSWS/PHP Oracle9 connectivity

berlioz — Thu, 18 Nov 2004 09:29:16 GMT

Bojan,

it's true that it's work better when i define logical in login.com

actually, my problem seems to be an "oracle nls" problem while trying to retrive data from char and varchar value.

Re: CSWS/PHP Oracle9 connectivity

berlioz — Thu, 18 Nov 2004 10:01:26 GMT

YES !!!!!!

i've ****** solved my problem !!! (sorry but i've loose 4 days)

The problem is in login.com

don't invoke orauser.com, but just define ORACLE_HOME, ORACLE_SID and ORA_NLS33

And !!!! show must go on !!!

Thanks for all