ThinkGeo.com    |     Documentation    |     Premium Support

PostgreSQL connection 14.x failed

#1

Hi,
I tried to connect to PostgreSqlFeatureLayer on PostgreSQL 14.x after updating RDBMS from 10.5.
The connect failed = Authentication method not supported {Received: 10}

What’s wrong ?

Regards
Hardy

#2

hi @Hartwig,

I believe the issue has something to do with the old Npgsql, which does not supports authentication by “scram-sha-256”.

I guess you’re using Map Suite 10, right? ThinkGeo.MapSuite.Layers.PostgreSql depends on Npgsql 3.0, which is really out-of-date. You could upgrade your Npgsql to 4.0 via NuGet, the latest one doesn’t work with Map Suite 10, if you’re interested in the latest one, you could upgrade Map Suite to v13.

Thanks,
Leo

#3

Hi Leo,
I tried to upgrade Npgsql but that fails. There are several dependencies …
Upgrading to V13 is planned for end of 2023.

Ok
Thanks for your support. We will wait till end of '23.

Regards
Hardy

#4

You’re welcome. Let me know you if have other questions.

Thanks,
Leo