Install help for connecting to oracle database

[reshu1596]

Originally Posted by mistwang

Try adding LD_LIBRARY_PATH to the "environment" section of the lsphp external application.

I am sorry, not sure I understand what that means. Is this a particular file or something I need to add before compiling?

Thanks
RM

[mistwang]

You need to change "lsphp" configuration under "external app" tab from the web admin interface.
just add "LD_LIBRARY_PATH=...." to "environment" configuration entry, this environment varible must be set explicitly from there.

[reshu1596]

Originally Posted by mistwang

You need to change "lsphp" configuration under "external app" tab from the web admin interface.
just add "LD_LIBRARY_PATH=...." to "environment" configuration entry, this environment varible must be set explicitly from there.

Now I get the following error in stderr.log when I try to run a simple oracle connect. Looks like it still has some problems with LD_LIBRARY_PATH

2007-02-07 13:17:43.536 [NOTICE] [199.11.4.59:6443-0#Example] [STDERR] PHP Warning: ocilogon() [<a href='function.ocilogon'>function.ocilogon</a>]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in /export/home/rawlog/lsws/DEFAULT/html/ravioraconnect.php on line 3
2007-02-07 13:17:43.537 [NOTICE] [199.11.4.59:6443-0#Example] [STDERR] PHP Warning: ociparse() expects parameter 1 to be resource, boolean given in /export/home/rawlog/lsws/DEFAULT/html/ravioraconnect.php on line 7
2007-02-07 13:17:43.537 [NOTICE] [199.11.4.59:6443-0#Example] [STDERR] PHP Warning: ociexecute() expects parameter 1 to be resource, null given in /export/home/rawlog/lsws/DEFAULT/html/ravioraconnect.php on line 8
2007-02-07 13:17:43.537 [NOTICE] [199.11.4.59:6443-0#Example] [STDERR] PHP Warning: ocifetchinto() expects parameter 1 to be resource, null given in /export/home/rawlog/lsws/DEFAULT/html/ravioraconnect.php on line 9
2007-02-07 13:17:43.537 [NOTICE] [199.11.4.59:6443-0#Example] [STDERR] PHP Warning: ocilogoff() expects parameter 1 to be resource, boolean given in /export/home/rawlog/lsws/DEFAULT/html/ravioraconnect.php on line 16

Any ideas?
Thanks
RM

The following

<?php

$conn = OCILogon('usera', 'sql', '//oracletest:1521/Vitalnet');

$query = 'select table_name from user_tables';

$stid = OCIParse($conn, $query);
OCIExecute($stid, OCI_DEFAULT);
while ($succ = OCIFetchInto($stid, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "<br>\n";
}

OCILogoff($conn);

?>

[reshu1596]

finally got it to work!!! I had to use the following two lines in the php script.
PutEnv("LD_LIBRARY_PATH=/export/home/rawlog/oracle/instantclient_10_2");
PutEnv("ORACLE_HOME=/oracle/g01/software/rdbms/9.2.0.6");

Any ideas why the lsphp doesn't use these environment variables?

I will send post another message with what all I did to get this working.

Thanks
Ravi

[mistwang]

I think you need to add "ORACLE_HOME" env to "Environment" configuration of lsphp as well. No need to use PutEnv().

LSWS has strict security policy, when LSWS start a external application, it will not set any environment variables in your current system environment, you have set them explicitly in the configuration.