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

Last updated on AUGUST 17, 2023

Applies to:

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

Changes

Cause

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