Cannot authenticate: "SCRAM authentication requires libpq 10 or later"

[frank77-postgres]

  
  
Hello all,
I installed pgadmin4 using "pip install" on a 64bit Raspbian
  system.
Everything worked well, except for the error message when trying
  to authenticate to my Postgres server on the same machine. 

Here are the steps I followed:
    sudo pip3 install pgadmin4
      sudo mkdir /var/log/pgadmin4 /var/lib/pgadmin4
      sudo adduser pgadmin --disabled-password
      sudo chown pgadmin:pgadmin /var/log/pgadmin4 /var/lib/pgadmin4
      sudo vim /etc/pgadmin/config_system.py        # set paths
  accordingly
      sudo su - pgadmin
      pgadmin$ python3
  /usr/local/lib/python3.9/dist-packages/pgadmin4/setup.py
      pgadmin$ pgadmin4 &

The app boots up fine, and I can access it using a web browser,
  and log in fine.
NOTE: Configuring authentication for SERVER mode.
  Enter the email address and password to use for the initial
  pgAdmin user account:
  Email address: u...@e.mail
  Password:
  Retype password:
  Starting pgAdmin 4. Please navigate to http://0.0.0.0:5050 in your
  browser.
  2022-02-20 23:28:30,069: WARNING    werkzeug:   WebSocket
  transport not available. Install simple-websocket for improved
  performance.
   * Serving Flask app 'pgadmin' (lazy loading)
   * Environment: production
     WARNING: This is a development server. Do not use it in a
  production deployment.
     Use a production WSGI server instead.
   * Debug mode: off
  2022-02-20 23:28:30,071: WARNING    werkzeug:    * Running
  on all addresses.
     WARNING: This is a development server. Do not use it in a
  production deployment.
  

Only actually logging into a Postgres server fails.

But I have libpq 14 installed and not libpq 10:
pi@raspberry64 $ dpkg -l|grep libpq
  ii  libpq-dev 
  14.2-1.pgdg110+1 arm64    header files for
  libpq5 (PostgreSQL library)
  ii  libpq5:arm64  
  14.2-1.pgdg110+1 arm64    PostgreSQL C client
  library
What am I missing? And how can I fix this? (Except changing the
  auth method serverside, which I would like to avoid)

Thanks for any help :-)
Regards
  

  

Re: Cannot authenticate: "SCRAM authentication requires libpq 10 or later"

[frank77-postgres]

  
  
Am 22.02.22 um 10:25 schrieb Dave Page:

  
  
Hi


  On Mon, 21 Feb 2022 at
17:57, 
wrote:
  
  

  Hello all,
  I installed pgadmin4 using "pip install" on a 64bit
Raspbian system.
  Everything worked well, except for the error message
when trying to authenticate to my Postgres server on the
same machine. 
(...) The app boots up fine, and I can access it using a
web browser, and log in fine. 
  Only actually logging into a Postgres server fails. (...)
  But I have libpq 14 installed and not libpq 10:
  pi@raspberry64 $ dpkg -l|grep libpq
ii  libpq-dev 
14.2-1.pgdg110+1 arm64    header
files for libpq5 (PostgreSQL library)
ii  libpq5:arm64  
14.2-1.pgdg110+1 arm64    PostgreSQL
C client library
  What am I missing? And how can I fix this? (Except
changing the auth method serverside, which I would like
to avoid)

  
  It sounds like psycopg2-binary on your machine is
including an older version of libpq - though on my rpi it
doesn't include any version which is quite odd (as that's
the whole point of the -binary version).
  
  
  You could try "pip3 uninstall psycopg2-binary &&
pip3 install psycopg2"

  

Hello Dave,
that was it! Thank you!!
Can I help document this somewhere?
  I didn't find any mention of this situation anywhere in the
  existing documentation.

Regards
  Frank