# HG changeset patch # User Sebastien Jodogne # Date 1603203988 -7200 # Node ID fcf614950f31336b1bb15bea006f7061e0e081ab # Parent 63d59fab98e2804cbcec758c7b0c56e0644596b5 disable scram diff -r 63d59fab98e2 -r fcf614950f31 Sphinx/source/plugins/postgresql.rst --- a/Sphinx/source/plugins/postgresql.rst Mon Oct 19 18:17:34 2020 +0200 +++ b/Sphinx/source/plugins/postgresql.rst Tue Oct 20 16:26:28 2020 +0200 @@ -268,3 +268,33 @@ When configuring your PostgreSQL plugin, ensure you've read the :ref:`scalability section ` + + +Troubleshooting +--------------- + +SCRAM authentication +^^^^^^^^^^^^^^^^^^^^ + +The precompiled binaries of the plugins use a stable version of the +PostgreSQL client (libpq 9.6.1, as of release 3.2). This makes these +binaries very portable, however they might not be compatible with more +recent features of PostgreSQL. + +In particular, the precompiled binaries are not compatible with `SCRAM +authentication +`__ +that is available since PostgreSQL 10. If you get the error ``psql: +authentication method 10 not supported``, this indicates that the +PostgreSQL plugins cannot connect to a PostgreSQL server because SCRAM +is enabled. + +`Ian Smith +`__ +has reported the following method to disable SCRAM: + +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.