Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres + scram-sha-256 authentication #831

Closed
GeoJGH opened this issue Dec 21, 2019 · 5 comments
Closed

Postgres + scram-sha-256 authentication #831

GeoJGH opened this issue Dec 21, 2019 · 5 comments

Comments

@GeoJGH
Copy link

@GeoJGH GeoJGH commented Dec 21, 2019

Steps to reproduce this issue

  1. Get a Postgres server using scram-sha-256 authentication
  2. Try to connect using HeidiSQL

Current behavior

It cannot connect. Error message is "authentication method 10 not supported"

Expected behavior

Successful connection

Possible solution

Replace libpq.dll with one from Postgres 10 install (it does not work with one from a Postgres 12 install)

Environment

  • HeidiSQL version:
    Version 10.3.0.5771 (64 Bit)

  • Database system and version:

Server was Postgres 10.3 and 12.1
This authentication method was introduced in v10

  • Operating system:

Windows 10

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Jan 13, 2020

@maxs-s

This comment has been minimized.

Copy link

@maxs-s maxs-s commented Feb 3, 2020

I have managed to connect to PostgreSQL database via HeidiSQL on windows.
Steps that worked for me:

  1. Copy the libpq.dll from postgresql-12.1-3-windows-x64-binaries\pgsql\bin to HeidiSQL install folder.
  2. Dowload the latest (openssl-1.0.2q-x64_86-win64.zip) SSL DLLs (libeay32.dll and ssleay32.dll) from https://indy.fulgan.com/SSL/ and copy them to HeidiSQL install folder.
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Feb 3, 2020

Ok, thanks for testing. I will try out if the latest libeay32 and ssleay32 also work with the older libpq.dll, so I can provide both without separating the dependencies.

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Feb 3, 2020

Here's an overview for 32/64bit PG releases: https://www.postgresql.org/download/windows/

ansgarbecker added a commit that referenced this issue Feb 3, 2020
* add libpq.dll v10.0.11 32+64bit
* add libpq.dll v12.0.1 64bit
* add 2 new dependencies (each 32+64bit): libcrypto-1_1.dll and libssl-1_1.dll
* remove libpq.dll v9.5 32+64bit
* remove 2 no longer dependent files (each 32+64bit): libeay32.dll and ssleay32.dll
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Feb 3, 2020

Here we go: I just removed libpq.dll v9.5, and added 2 newer ones along with new dependencies: v10.0.11 32+64bit and v.12.0.1 64bit.

I found that both new versions don't use libeay32.dll and ssleay32.dll any longer. Instead, I had to add libcrypto-1_1.dll and libssl-1_1.dll.

Would be nice if someone out there could test the new nightly built installer from here: https://www.heidisql.com/download.php#r5859 (should be compiled in some minutes)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
You can’t perform that action at this time.