ID: 24343
Updated by: [EMAIL PROTECTED]
Reported By: thomas at fivemile dot net
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Redhat Linux 8.0
-PHP Version: 4.3.2
+PHP Version: 4.3.3-dev
New Comment:
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 ??
Previous Comments:
------------------------------------------------------------------------
[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?
------------------------------------------------------------------------
[2003-06-26 16:03:28] thomas at fivemile dot net
The snapshot seems to have cleared the segfaults, nevertheless the
weird oracle error messages remain. Is there a way to debug the
OCI(P)Logon and compare it with the data the working server is sending?
------------------------------------------------------------------------
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
