Page 1 of 1

Invalidation of md5-hashed Passwords

Posted: Tue 26 Apr 2022 05:06
by Ekki
Hello,

don't know or imply that this is actually a DevArt issue but I'm facing the problem (for the first time ever since 2013) that suddenly md5-hashed passwords don't work anymore and I need to re-enter them. They're then stored with SCRAM SHA 256 hash and all is fine again.

PostgreSQL 13.6 on Windows Server 2022

Thx IA

Re: Invalidation of md5-hashed Passwords

Posted: Tue 26 Apr 2022 06:17
by Ekki
just to be clear: I didn't change anything, neither updated something nor modified any configuration file. All I 'did' was calling pgAdmin for the first time for this specific installation (created a database and a schema, and created/assigned a few roles). Then the trouble began...

Re: Invalidation of md5-hashed Passwords

Posted: Thu 28 Apr 2022 12:29
by DmitryGm
Please clarify:
  1. The exact error message with full stack trace
  2. The code example and steps to reproduce.
  3. The version of dotConnect for MySQL
According to Revision History:
  • 7.19.1759 29-Oct-20 PostgreSQL 13 is supported
  • 7.20.1860 01-Apr-21 The bug with opening SSL connection to PostgreSQL Server 13 that uses password_encryption=scram-sha-256 is fixed
So we recommend using the latest version of dotConnect for PostgreSQL - 7.24.2066