Mercurial > hg > orthanc-book

comparison Sphinx/source/plugins/postgresql.rst @ 531:fcf614950f31

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
disable scram
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Oct 2020 16:26:28 +0200
parents 2922fb1bd65e
children 5c0dfc863884
comparison
equal deleted inserted replaced
530:63d59fab98e2 531:fcf614950f31
266 Scalability 266 Scalability
267 ^^^^^^^^^^^ 267 ^^^^^^^^^^^
268 268
269 When configuring your PostgreSQL plugin, ensure you've read the :ref:`scalability section 269 When configuring your PostgreSQL plugin, ensure you've read the :ref:`scalability section
270 <scalability>` 270 <scalability>`
271
272
273 Troubleshooting
274 ---------------
275
276 SCRAM authentication
277 ^^^^^^^^^^^^^^^^^^^^
278
279 The precompiled binaries of the plugins use a stable version of the
280 PostgreSQL client (libpq 9.6.1, as of release 3.2). This makes these
281 binaries very portable, however they might not be compatible with more
282 recent features of PostgreSQL.
283
284 In particular, the precompiled binaries are not compatible with `SCRAM
285 authentication
286 <https://en.wikipedia.org/wiki/Salted_Challenge_Response_Authentication_Mechanism>`__
287 that is available since PostgreSQL 10. If you get the error ``psql:
288 authentication method 10 not supported``, this indicates that the
289 PostgreSQL plugins cannot connect to a PostgreSQL server because SCRAM
290 is enabled.
291
292 `Ian Smith
293 <https://groups.google.com/g/orthanc-users/c/4EH7HpcEnSA/m/a4x6oiucAgAJ>`__
294 has reported the following method to disable SCRAM:
295
296 1. Drop/delete the ``orthanc`` database and user in PostgreSQL.
297 2. Edit the files ``postgresql.conf`` and ``pg_hba.conf`` and change
298 ``scram-sha-256`` to ``md5`` in all cases.
299 3. Add the ``orthanc`` user and database in PostgreSQL again.
300 4. Restart Orthanc.