It is currently 7 December 2021, 21:27 Advanced search

PostgreSQL 10+ SCRAM-SHA-256 Authentication

Questions and answers on how to best use Instant Developer

PostgreSQL 10+ SCRAM-SHA-256 Authentication

Postby ljwilson » 29 May 2021, 16:05

Starting with PostgreSQL 10, SCRAM-SHA-256 authentication was introduced.
As of PostgreSQL 13, SCRAM-SHA-256 is the default (instead of MD5).

As of InDE 21.0 r13, the .NET library used for c# apps to communicate with PostgreSQL is Npgsql.dll Version 3.2.6. This version does NOT support SCRAM-SHA-256.

Fortunately, the next version 3.2.7 does:
SASL/SCRAM-SHA-256 support for PostgreSQL 10 #1530
https://github.com/npgsql/npgsql/issues/1530

List of PostgreSQL drivers which support SCRAM-SHA-256:
https://wiki.postgresql.org/wiki/List_o ... rs#Drivers

For now I put the 3.2.7 Npgsql.dll in my custom\bin directory and reference it in FileList.txt, but it would be nice if InDe could include it (or a later version) instead.

I'll submit an improvement suggestion and reference this post.

In the meantime if anyone needs the file, you can download it from:
https://github.com/npgsql/npgsql/releases/tag/v3.2.7

Thanks...jack
ljwilson
 
Posts: 630
Joined: 26 November 2013, 14:15

Re: PostgreSQL 10+ SCRAM-SHA-256 Authentication

Postby lucabaldini » 31 May 2021, 7:24

Perfect! We'll fix it in the next InDE version.

Thanks! :-)))))))
User avatar
lucabaldini
Pro Gamma
Pro Gamma
 
Posts: 4801
Joined: 1 October 2010, 17:03
Location: Bologna

Re: PostgreSQL 10+ SCRAM-SHA-256 Authentication

Postby ljwilson » 1 June 2021, 12:19

Excellent--thank you!

...jack
ljwilson
 
Posts: 630
Joined: 26 November 2013, 14:15

Re: PostgreSQL 10+ SCRAM-SHA-256 Authentication

Postby lucabaldini » 22 September 2021, 9:38

L'attività NPQ05147 è stata completata e sarà disponibile nella versione Instant Developer 21.5. Clicca qui per leggere le note di rilascio.
User avatar
lucabaldini
Pro Gamma
Pro Gamma
 
Posts: 4801
Joined: 1 October 2010, 17:03
Location: Bologna

Re: PostgreSQL 10+ SCRAM-SHA-256 Authentication

Postby ljwilson » 22 September 2021, 17:50

Wonderful--thank you!

...jack
ljwilson
 
Posts: 630
Joined: 26 November 2013, 14:15


Return to Tips & Tricks

Who is online

Users browsing this forum: No registered users and 4 guests