ID: 24343
Comment by: timothy_haak at yahoo dot com
Reported By: thomas at fivemile dot net
Status: No Feedback
Bug Type: OCI8 related
Operating System: Redhat Linux 8.0
PHP Version: 4.3.3-dev
New Comment:
Hi
Don't know why but by removing the following variable from my profile I
managed to get it to work.
NLS_LANG="ENGLISH_UNITED KINGDOM.WE8MSWIN1252"
export NLS_LANG
Hope this helps
Previous Comments:
------------------------------------------------------------------------
[2004-02-14 08:46:19] timothy_haak at yahoo dot com
Hi sorry ment to add the script as well
I have also tested connecting from sqlplus which i can do.
<?php
ociinternaldebug(1);
if (OCILogon("<username>", "<password>", "pierceg"))
{
echo "Successfully connected to Oracle.\n";
}
else
{
echo "Oracle Connect Error ";
}
?>
------------------------------------------------------------------------
[2004-02-14 08:38:43] timothy_haak at yahoo dot com
Hi
I am having a similar issue to the person below here is what the screen
prints out when I ad the ociinternaldebug(1); to the top of the file.
Warning: ocilogon() [function.ocilogon]: OCISessionBegin: ORA-00604:
error occurred at recursive SQL level 1 ORA-00911: invalid character in
/Scripts/WEB/test.php on line 3
OCIDebug: _oci_open_session: FAILURE -> CLEANUP called
OCIDebug: START _oci_close_session: logging-off sess=0
OCIDebug: _oci_close_session: logging-off DEAD session
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called
OCIDebug: START _oci_conn_list_dtor: id=0
OCIDebug: END _oci_conn_list_dtor: id=0
Oracle Connect Error OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
I have tried compiling with both php versions PHP 5.0 Beta 4 and PHP
4.3.4
Here is what is loaded into my profile.
ORACLE_BASE=/u01/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/oracle/product/9.2
export ORACLE_HOME
ORACLE_SID=PIERCEG
export ORACLE_SID
PATH=$PATH:$HOME/bin:/u01/oracle/product/9.2/bin
export PATH
USERNAME=""
export USERNAME
CLASSPATH=:.:/u01/oracle/product/9.2/jdbc/lib/classes111.zip
export CLASSPATH
LD_LIBRARY_PATH=/u01/oracle/product/9.2/lib
export LD_LIBRARY_PATH
ORA_NLS33=/u01/oracle/product/9.2/ocommon/nls/admin/data
export ORA_NLS3
NLS_LANG="ENGLISH_UNITED KINGDOM.WE8MSWIN1252"
export NLS_LANG
NLS_DATE_FORMAT="RRRR-MM-DD HH24:MI:SS"
export NLS_DATE_FORMAT
PATH=$PATH:/usr/local/jre/bin
export PATH
LD_ASSUME_KERNEL=2.4.1
export LD_ASSUME_KERNEL
Here is the configuration info
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-oci8'
'--enable-track-vars' '--enable-ftp' '--enable-sigchild' '--with-gd'
'--enable-gd-native-ttf' '--with-ttf'
'--with-freetype-dir=/usr/local/freetype' '--with-jpeg-dir=/usr/lib/'
'--with-zlib' '--with-png-dir=/usr/lib/' '--with-xpm-dir=/usr/X11R6'
'--with-ldap' '--enable-exif' '--with-png' '--without-tsrm-pthreads'
'--enable-inline-optimization' '--with-tiff=/usr/lib/'
>From phpinfo
oci8
OCI8 Support enabled
Revision $Revision: 1.248 $
Active Persistent Links 0
Active Links -3
Oracle Version 9.2
Compile-time ORACLE_HOME /u01/oracle/product/9.2
Libraries Used no value
Temporary Lob support enabled
Collections support enabled
------------------------------------------------------------------------
[2003-07-20 10:41:59] [EMAIL PROTECTED]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2003-07-13 10:45:30] [EMAIL PROTECTED]
Try adding "ociinternaldebug(1);" in the beginning of your script.
That'll make the functions to print out some extra debugging
information.
------------------------------------------------------------------------
[2003-07-13 05:54:10] thomas at fivemile dot net
Okay, once again, slowly.
- installed a fresh oracle 9.2.0
- installed a fresh apache with PHP and linked against oracle
- does NOT work
- copied over the entire /opt/oracle/product/9.0.1 tree from another
machine where the libs work
- installed a fresh apache with PHP linked against those other libs
- CHANGED the environment vars so the 9.0.1 libs are used instead of
the 9.2.0 libs
- now it works - NO thanks to wild guesses from the bugs team.
i have installed a couple of working oci/php combos so far, the 9.2.0
is the first one where i ran into these kind of problems. And you can't
earnestly expect new users to fiddle with libs for 2 weeks till their
oci bindings start to work...
If you like, you can have an account on the box in question and have a
look around yourself. However i am NOT satisfied with the answer 'okay,
you made a crude hack, and by chance it worked, now use it and stop
bugging us'
------------------------------------------------------------------------
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
