php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #11169 OCILogon failed
Submitted: 2001-05-29 08:52 UTC Modified: 2002-04-13 08:36 UTC
From: truejaws at unitel dot co dot kr Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.5 OS: Solaris 7
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: truejaws at unitel dot co dot kr
New email:
PHP Version: OS:

 

 [2001-05-29 08:52 UTC] truejaws at unitel dot co dot 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



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-29 09:22 UTC] sniper@php.net
Have you set ALL the environment variables mentioned
on this page: http://www.php.net/oci8

--Jani

 [2001-05-29 10:06 UTC] truejaws at unitel dot co dot 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

 [2002-04-13 08:36 UTC] thies@php.net
nothing php can do. something with your oracle-client setup is wrong.

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Apr 24 11:01:30 2024 UTC