How to Decrypt hashpasswords in PostgreSQL

Question

We have created few reports in Pentaho with PostgreSQL as data source. We have implemented the authentication of pentaho to take from PostgreSQL database users and roles tables but in the db Passwords are stored as hash passwords. So when we try to login to Pentaho with the username and actual passwords, login is not working as we passed the hash passwords to the pentaho server while configuring the security.

So can someone let me know how to decrypt the hashed passwords while retrieving them from the DB with the below statement so that we can pass actual passwords to the Pentaho server while configuring authentication.

SELECT username, password, enabled FROM USERS ORDER BY username(In this statement password should be the decrypted passwords but in the db hash passwords are stored)

Thank you in advance.

techsolvency.com/passwords/dehashing-reversing-decrypting

jps
– jps

2020-05-21 09:04:12 +00:00
Commented May 21, 2020 at 9:04 — jps
– jps, Commented May 21, 2020 at 9:04

Thom Brown · Accepted Answer · 2020-05-21 08:47:06Z

1

If the passwords are hashed, then there is no way to "unhash" them. Hashing is a one-way process. If they were encrypted with a key, certificate, passphrase etc, it would be possible, but hashing is designed to be one-way. The only way to be certain of the passwords is to reset them to something else.

answered May 21, 2020 at 8:47

Thom Brown

2,0698 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Decrypt hashpasswords in PostgreSQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related