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
