Bug #11169 Updated: OCILogon failed

ID: 11169 Updated by: thies@php.net Reported By: truejaws@unitel.co.kr -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: Solaris 7 PHP Version: 4.0.5 New Comment: nothing php can do. something with your oracle-client setup is wrong. Previous Comments: ------------------------------------------------------------------------ [2001-05-29 10:06:38] truejaws@unitel.co.kr sqlplus works fine. I think LD_PRELOAD variable is not necessary. $ env _=/usr/bin/env HZ=100 PATH=/opt/SUNWspro/bin:/usr/ccs/bin:/usr/bin:/usr/local/bin:/usr/ucb:/etc:/usr/sbin:.:/oracle/bin NLS_LANG=American_America.KO16KSC5601 LOGNAME=oracle ORACLE_SID=XXXX ORACLE_OWNER=xxxxxx SHELL=/bin/ksh ORA_NLS33=/oracle/ocommon/nls/admin/data HOME=/oracle LD_LIBRARY_PATH=/oracle/lib DISPALY=red:0.0 TERM=vt100 ORACLE_HOME=/oracle PWD=/tmp TZ=ROK ------------------------------------------------------------------------ [2001-05-29 09:22:02] sniper@php.net Have you set ALL the environment variables mentioned on this page: http://www.php.net/oci8 --Jani ------------------------------------------------------------------------ [2001-05-29 08:52:33] truejaws@unitel.co.kr My program cannot connect to oracle server. I think this bug is equal to Richard's (#6456), that was closed for no feedback. (hi kir@php.net, tnsping works successfully.) For any questions about this bug, I'll reply ASAP. compiled options: ----------------- ./configure --with-oci8=/oracle --enable-track-vars error producing: ---------------- $ cat tt.php #!/usr/local/bin/php -q <? function Logon() { OCIInternalDebug(1); $dbuser = "userid"; $dbuserpwd = "pwd"; $conn = OCILogon($dbuser, $dbuserpwd, "our_dbserver"); return $conn; } $conn = Logon(); if($conn != false){ echo"OK> DB connection ok\n"; } else { echo"ERR> DB connection fail\n"; } ?> $ php tt.php X-Powered-By: PHP/4.0.5 Content-type: text/html OCIDebug: _oci_open_server new conn=0 dname=our_dbserver<br> <br> <b>Warning</b>: OCISessionBegin: ORA-03120: two-task conversion routine: integer overflow in <b>tt.php</b> on line <b>7</b><br> OCIDebug: _oci_open_session: FAILURE -> CLEANUP called<br> OCIDebug: START _oci_close_session: logging-off sess=0<br> OCIDebug: _oci_close_session: logging-off DEAD session<br> OCIDebug: oci_do_connect: FAILURE -> CLEANUP called<br> OCIDebug: START _oci_conn_list_dtor: id=0<br> OCIDebug: END _oci_conn_list_dtor: id=0<br> ERR> DB connection fail OCIDebug: START php_rshutdown_oci<br> OCIDebug: END php_rshutdown_oci<br> OCIDebug: START _oci_close_server: detaching conn=1 dbname=our_dbserver<br> OCIDebug: START php_mshutdown_oci<br> OCIDebug: END php_mshutdown_oci<br> System environment: ------------------ $ tnsping our_dbserver TNS Ping Utility for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 29-MAY-01 20:58:14 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=our_dbserver)(PORT=1521)) OK (10 msec) $ sqlplus dev2/dev2@dev.ableclick.co.kr SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 29 21:24:08 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SQL> $ php -v 4.0.5 $ uname -a SunOS red 5.7 Generic_106542-11 i86pc i386 i86pc ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=11169&edit=1