Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Logon error from php / apache

Logon error from php / apache

From: David Munsey-Kano <David.Munsey-Kano_at_dartmouth.edu>
Date: Mon, 08 Nov 1999 12:38:35 -0500
Message-ID: <38270A9B.870F2C2D@dartmouth.edu>


I am using Apache 1.3.6 PHP 3.1.12 and Oracle Libraries 8.0.5 on an Alpha with Digital UNIX V4.0D (Rev. 878). I have successfully compiled and linked everything using gcc. basic php functions are working in my pages, but when I execute ora_logon() or OCI_Logon() I get:

Warning: Unable to connect to ORACLE (ORA-01017: invalid username/password; logon denied)

I am using the same name and password that I use to connect using sqlplus from the same machine. IE in sqlplus I use:

        ops$munseykano_d/<mypassword>@BRONZE

In php3 I use:

$con = ocilogon("ops$munseykano_d","<mypassword>", "BRONZE");

        or

$con = ora_logon("ops$munseykano_d_at_BRONZE","<mypassword>");

I created a CGI version of php3 and executed a small test file that contains:

<?
ociinternaldebug(1);
$con = ocilogon("ops$munseykano_d","bigwaves", "BRONZE");
?>

(I found this in a list archive when looking for answers) This outputs:

%./php oci.php3
Content-type: text/html

OCIDebug: oci8_open_server new conn=2000 dname=BRONZE<br> <br>
<b>Warning</b>: OCISessionBegin: ORA-01017: invalid username/password; logon denied
 in <b>oci.php3</b> on line <b>3</b><br>

OCIDebug: oci8_open_user: FAILURE -> CLEANUP called<br>
OCIDebug: _oci8_close_user: logging-off sess=0<br>
OCIDebug: _oci8_close_user: logging-off DEAD session<br>
OCIDebug: oci8_do_connect: FAILURE -> CLEANUP called<br>
OCIDebug: _oci8_close_conn: id=0<br>
OCIDebug: php3_rshutdown_oci8<br>
OCIDebug: _oci8_close_server: detaching conn=2000 dbname=BRONZE<br>
OCIDebug: php3_mshutdown_oci8<br>

Thanks,

--
David Munsey-Kano
Dartmouth College
(603) 646-1320 Received on Mon Nov 08 1999 - 11:38:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US