WebLogic SQL Authentication Provider - Password Algorithm: SHA-512 Does Not Match Oracle DB SHA2 Password
(Doc ID 2479491.1)
Last updated on AUGUST 03, 2022
Applies to:
Oracle WebLogic Server - Version 12.2.1.2.0 and laterInformation in this document applies to any platform.
Symptoms
It was observed that SQL Authenticator USERS table U_PASSWORD column stored encrypted SHA-512 password text does not match with MYSQL Database calculated SHA-512 text.
mysql> select * from USERS;
+--------+---------------------------------------------------------------------------------------------------------------------- +-------------------+
| U_NAME | U_PASSWORD | U_DESCRIPTION |
+--------+-----------------------------------------------------------------------------------------------------------------------+-------------------+
| test |{SHA-512}2gfAiiwu83EOaIv/R2qKCdUtbTS27jxBpLH1jylJeS7yAHlWXKDXjidYsztQoTyYKcCL32cNyALmJ/KJNk0gOg== | |
+--------+-----------------------------------------------------------------------------------------------------------------------+-------------------+
1 row in set (0.00 sec)
Below is output of computing the SHA-512 as documented in
https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |