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

Hi

On Mon, 21 Feb 2022 at 17:57, <frank77-postgres(at)spamfreemail(dot)de> 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.
>
> 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)
>
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"

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com