Invalidation of md5-hashed Passwords

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Ekki
Posts: 34
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany
Contact:

Invalidation of md5-hashed Passwords

Post by Ekki » Tue 26 Apr 2022 05:06

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

Ekki
Posts: 34
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany
Contact:

Re: Invalidation of md5-hashed Passwords

Post by Ekki » Tue 26 Apr 2022 06:17

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...

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Invalidation of md5-hashed Passwords

Post by DmitryGm » Thu 28 Apr 2022 12:29

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

Post Reply