ID: 24343
User updated by: thomas at fivemile dot net
Reported By: thomas at fivemile dot net
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Redhat Linux 8.0
PHP Version: 4.3.3-dev
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2003-06-26 17:54:50] [EMAIL PROTECTED]
Have you set all the necessary environment variables correctly when you
start apache?
------------------------------------------------------------------------
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
