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

From: frank77-postgres(at)spamfreemail(dot)de
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Cannot authenticate: "SCRAM authentication requires libpq 10 or later"
Date: 2022-02-22 19:21:32
Message-ID: ae4dd765-4d71-f087-c0c4-4819752367bb@spamfreemail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Am 22.02.22 um 10:25 schrieb Dave Page:<br>
<blockquote type="cite"
cite="mid:CA+OCxowJ0-bjct6y2HgDALaAwQHVC9o-48x6CnsfpZnSV0fijA(at)mail(dot)gmail(dot)com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hi</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, 21 Feb 2022 at
17:57, &lt;<a href="mailto:frank77-postgres(at)spamfreemail(dot)de"
moz-do-not-send="true" class="moz-txt-link-freetext">frank77-postgres(at)spamfreemail(dot)de</a>&gt;
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>
<p>Hello all,</p>
<p>I installed pgadmin4 using "pip install" on a 64bit
Raspbian system.</p>
<p>Everything worked well, except for the error message
when trying to authenticate to my Postgres server on the
same machine. <br>
(...) The app boots up fine, and I can access it using a
web browser, and log in fine. </p>
Only actually logging into a Postgres server fails. (...)
But I have libpq 14 installed and not libpq 10:
<p>pi(at)raspberry64 $ dpkg -l|grep libpq<br>
ii  libpq-dev                         
14.2-1.pgdg110+1                 arm64        header
files for libpq5 (PostgreSQL library)<br>
ii  <a moz-do-not-send="true">libpq5:arm64</a>                      
14.2-1.pgdg110+1                 arm64        PostgreSQL
C client library</p>
<p>What am I missing? And how can I fix this? (Except
changing the auth method serverside, which I would like
to avoid)</p>
</div>
</blockquote>
<div>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).</div>
<div><br>
</div>
<div>You could try "pip3 uninstall psycopg2-binary &amp;&amp;
pip3 install psycopg2"</div>
</div>
</div>
</blockquote>
<p>Hello Dave,</p>
<p>that was it! Thank you!!</p>
<p>Can I help document this somewhere?<br>
I didn't find any mention of this situation anywhere in the
existing documentation.<br>
</p>
<p>Regards<br>
Frank</p>
<p><br>
</p>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.9 KB

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2022-02-23 09:00:37 Re: Cannot authenticate: "SCRAM authentication requires libpq 10 or later"
Previous Message Dave Page 2022-02-22 09:25:53 Re: Cannot authenticate: "SCRAM authentication requires libpq 10 or later"