authentication problem with PostgreSQL

[Ian Smith]

Hi,

I'm trying to use the PostgreSQL plugin for Orthanc but get the following

error message when trying to start the Orthanc server "authentication method 10 not supported".

I've attached a debug logfile and the configuration file. I'm using the

following:

Orthanc 1.7.4

Microsoft Server 2019

PostgreSQL 13

Any pointers would be very much appreciated Haven't been able to find

anything by searching about.

thanks in advance,

-ian.

Dr Ian C. Smith,

Advanced Research Computing,

University of Liverpool.

[Sébastien Jodogne]

Hello,

After a quick search on Internet, I found the following reference:

https://www.postgresql-archive.org/Authentication-MD5-to-SCRAM-SHA-256-error-td6111984.html

> However when I try to log in now, via command line, I receive the error:

> "psql: authentication method 10 not supported".

Your client (more precisely: it's libpq) is not ready for SCRAM.

I guess you're using an older (<10) client version? Mixed up

packages?"

Instead of using a precompiled version, you should build the PostgreSQL plugin from source (e.g. on Debian/Ubuntu), in order for it to use your system-wide "libpq" library that will be compatible with your version of PostgreSQL:

https://book.orthanc-server.com/plugins/postgresql.html#dynamic-linking-on-other-gnu-linux-distributions

HTH,

Sébastien-

[Ian Smith]

Hi Sebastian,

Thanks for the very quick response.  I’m using Windows Server 2019 rather than Linux so not quite sure how to fix the client ? Is the username/password passed via the shell (is this possible?) or is It via some sort of socket based connection. 

I’m think the PostgreSQL server log  may have some useful info but not sure where it’s located.

Many thanks,

-Ian.

On 19 Oct 2020, at 17:13, Sébastien Jodogne <s.jo...@gmail.com> wrote:



--
You received this message because you are subscribed to a topic in the Google Groups "Orthanc Users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orthanc-users/4EH7HpcEnSA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orthanc-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orthanc-users/eba56cba-53d7-47d3-af4b-5ccf6cc0b638o%40googlegroups.com.

[Sébastien Jodogne]

Hello,

It will be necessary to upgrade the source code of the PostgreSQL plugin to use a more recent version of the PostgreSQL library (aka. "libpq"), more precisely the following CMake file:

https://hg.orthanc-server.com/orthanc-databases/file/default/Resources/CMake/PostgreSQLConfiguration.cmake

As can be seen, 9.6.1 is currently used is static builds (such as for Microsoft Windows). Unfortunately, I don't have the time to do such a modification by myself right now. Stay tuned for future updates, but they might not come before several months.

In the meantime, as written above, I suggest you to use a free GNU/Linux system, as this comes with support of dynamic linking against recent versions of libpq at no price.

Regards,

Sébastien-

To unsubscribe from this group and all its topics, send an email to orthanc-users+unsubscribe@googlegroups.com.

[Sébastien Jodogne]

Complement: More simply, you might also be able to find a configuration option of PostgreSQL to switch off this "SCRAM authentication" stuff. I am not an expert in PostgreSQL configuration, so I can't provide further help on this topic.

[Ian Smith]

I turned the "SCRAM authentication" off and that it seemed to work after that. For the record here are the

steps I used:

1. Drop/delete the orthanc database and user in PostgreSQL

2. Edit the files postgresql.conf and pg_hba.conf and change 'scram-sha-256' to 'md5' in all cases.

3. Add the orthanc user and database in PostgreSQL again

4. Restart orthanc

regards,

-ian.

To unsubscribe from this group and all its topics, send an email to orthanc-user...@googlegroups.com.

[Sébastien Jodogne]

Hello,

Thanks for the feedback!

I have added this information to the Orthanc Book:

https://book.orthanc-server.com/plugins/postgresql.html#troubleshooting

Regards,

Sébastien-