Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Logon error from php / apache
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