My Oracle Support Banner

WebLogic SQL Authentication Provider - Password Algorithm: SHA-512 Does Not Match Oracle DB SHA2 Password (Doc ID 2479491.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

Oracle WebLogic Server - Version 12.2.1.2.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.