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

From: frank77-postgres(at)spamfreemail(dot)de
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Cannot authenticate: "SCRAM authentication requires libpq 10 or later"
Date: 2022-02-21 17:57:36
Message-ID: a6752769-697d-dbd0-a51b-a585c96e333a@spamfreemail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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: user(at)e(dot)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(at)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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2022-02-22 05:01:49 Re: Programmatic access to the SQL tab of pgadmin
Previous Message Ni Ne 2022-02-21 16:35:53 Re: Programmatic access to the SQL tab of pgadmin