authentication problem with PostgreSQL

Google Groups archive
1

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.

orthanc.log (4.25 KB)

postgresql.json (1.05 KB)

2

Hello,

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

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-

3

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.

4

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-

5

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.

6

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.

7

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-