ID:               33097
 Updated by:       [EMAIL PROTECTED]
 Reported By:      dboeke at eesus dot jnj dot com
-Status:           Open
+Status:           Bogus
 Bug Type:         OCI8 related
 Operating System: Win2k Server ver 5.0.2195 SP4
 PHP Version:      5.0.4
 New Comment:

Yes, I was able to reproduce it once, but after some time spent on
debugging/dropping and creating new users I can't reproduce it
anymore.
Anyway, this is not a PHP bug, because PHP just calls
OCIPasswordChange() function and if it fails randomly there is nothing
we can do. 
Try to search metalink database and bug Oracle people.


Previous Comments:
------------------------------------------------------------------------

[2005-05-23 21:03:02] dboeke at eesus dot jnj dot com

<?php
$oraSid = 'PROD1';
$userID = 'UserNm';
$oldPwd = 'Qqww!$123';
$newPwd = 'Zzxx!$456';

$conn = @oci_new_connect($userID, $oldPwd, $oraSid);
        
if ($conn) {
        $result = @oci_password_change($conn, $userID, $oldPwd, $newPwd);
        $e = ($result) ? array('message'=>'Success') : oci_error($conn);
        @oci_close($conn);
} else { 
        $e = oci_error(); 
}

echo $e['message'];
?>

Same Error (ORA-28008: invalid old password ) with the above code.

------------------------------------------------------------------------

[2005-05-23 20:19:25] [EMAIL PROTECTED]

And what if you remove all this stuff not related to the OCI itself
(like strpslashes, forms etc.) ?

------------------------------------------------------------------------

[2005-05-23 19:12:07] dboeke at eesus dot jnj dot com

I can use the Password command in SQL Plus to successfully change the
password.  Also confirmed that other passwords using similar structure
fail, ie:

Zzxx!$123
Aabb!$456

I haven't been able to check the local 9i environment yet, cause I
don't have a user account, but I have requested one, and will update
when I can.

------------------------------------------------------------------------

[2005-05-21 23:11:11] [EMAIL PROTECTED]

And please try to use oci_password_change() with your locally installed
Oracle.

------------------------------------------------------------------------

[2005-05-21 23:10:13] [EMAIL PROTECTED]

And what happens if you try to change the password using sqlplus (but
not with "alter user" command) ?

------------------------------------------------------------------------

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/33097

-- 
Edit this bug report at http://bugs.php.net/?id=33097&edit=1

Reply via email to