ID: 24343
Updated by: [EMAIL PROTECTED]
Reported By: thomas at fivemile dot net
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: Redhat Linux 8.0
PHP Version: 4.3.3-dev
New Comment:
Then use those. Wild guess: The SAME environment vars don't work with
DIFFERENT oracle version..
Previous Comments:
------------------------------------------------------------------------
[2003-07-08 10:52:15] thomas at fivemile dot net
the SAME script on the SAME machine works with the 9.0.1 client libs I
copied over from the other machine. Only the 9.2.0 client libs (using
the SAME script, the SAME php, the SAME apache and the SAME configure
line) do not work.
------------------------------------------------------------------------
[2003-07-07 19:29:08] [EMAIL PROTECTED]
Try a script which has ONLY that one line.
And you're sure your username/password doesn't contain any illegal
chars? And your db name is tns.domain ??
------------------------------------------------------------------------
[2003-06-26 18:36:52] thomas at fivemile dot net
Warning: ociplogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-00911: invalid character in
/home/httpd/index.php3 on line 3
or
Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-00922: missing or invalid option in
/home/httpd/index.php3 on line 3
'Line 3' is simply the OCILogon or OCIPLogon as follows:
$ohnd = OCILogon("dvd","hidden","tns.domain");
------------------------------------------------------------------------
[2003-06-26 18:30:36] [EMAIL PROTECTED]
With what script and what errors do you get..?
------------------------------------------------------------------------
[2003-06-26 18:23:19] thomas at fivemile dot net
environment of the defunct server (from phpinfo())
NLS_LANG german_germany.WE8DEC
LD_LIBRARY_PATH
/opt/oracle/product/9.2.0/lib:/lib:/usr/lib:/opt/apache2/lib::/usr/local/lib
ORACLE_SID tsid
ORACLE_BASE /opt/oracle
PATH
/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/opt/oracle/product/9.2.0/bin
PWD /
LANG en_US.UTF-8
ORACLE_TERM xterm
SHLVL 1
ORA_NLS33 /opt/oracle/product/9.2.0/ocommon/nls/admin/data
ORACLE_HOME /opt/oracle/product/9.2.0
_ /sbin/initlog
and the environment of the working server:
PWD /home
ORACLE_SID TSID
LD_LIBRARY_PATH
/opt/oracle/product/9.0.1/lib:/lib:/usr/lib:/usr/local/lib
CLASSPATH
/opt/oracle/product/9.0.1/JRE:/opt/oracle/product/9.0.1/jlib:/opt/oracle/product/9.0.1/rdbms/jlib:/opt/oracle/product/9.0.1/network/jlib
LANG en_US
ORACLE_BASE /opt/oracle
ORACLE_HOME /opt/oracle/product/9.0.1
ORACLE_TERM 386
SHLVL 3
ORA_NLS33 /opt/oracle/product/9.0.1/ocommon/nls/admin/data
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
NLS_LANG german_germany.WE8DEC
_ /sbin/initlog
if i log into the webserver user on the non-functioning host i can
access the oracle db with sql*plus just fine.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/24343
--
Edit this bug report at http://bugs.php.net/?id=24343&edit=1
