To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Cc: "pgadmin-support lists.postgresql.org"
 <pgadmin-support@lists.postgresql.org>
References: <caf86484-427d-5390-f369-78ff1c7b2ce0@web.de>
 <CAFOhELcTYdgLdDsHBQjcCYOUQFQo1eBT_+oytX9j36tr52nh+w@mail.gmail.com>
 <02ad2a84-76a8-255a-f366-aaa7ca72156d@web.de>
 <CAFOhELc-ibJYRxya=6qnmS+7U2dtcUNoqA2VRnfNJ82LwUOYFg@mail.gmail.com>
From: Michael Eschweiler <michael.eschweiler@web.de>
Subject: Re: authentication fail
Message-ID: <6c43d987-ae7d-bd1b-6760-ecdea3d25004@web.de>
Date: Mon, 1 Feb 2021 22:25:48 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.0
MIME-Version: 1.0
In-Reply-To: 
 <CAFOhELc-ibJYRxya=6qnmS+7U2dtcUNoqA2VRnfNJ82LwUOYFg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Hi,

Am 01.02.21 um 05:50 schrieb Khushboo Vashi:

>
> Looks like you are running pgAdmin 4 version 4.1 and the latest version
> is 4.30. Please upgrade the pgAdmin to the latest and your issue will be
> resolved.

Seems that I must be VERY patient. I am working with opensuse Leap 15.2.
The version of paAdmin4 which comes with the distro is this version
(4.1).  Even the rolling release distro (Tumbleweed) only offers the
version 4.29.
At:
https://ftp.postgresql.org/pub/pgadmin/pgadmin4
I found the rpm-Package f=C3=BCr Red Hat and Fedora. Do you have any
information if this works on opensuse too?


Thanks in advance,
Michael

>
> Thanks,
> Khushboo
>
>
> On Sat, Jan 30, 2021 at 1:58 PM Michael Eschweiler
> <michael.eschweiler@web.de <mailto:michael.eschweiler@web.de>> wrote:
>
>     Hi Khushboo,
>
>     Am 12.01.21 um 05:26 schrieb Khushboo Vashi:
>     > Hi,
>     >
>     > On Tue, Jan 12, 2021 at 12:39 AM Michael Eschweiler
>     > <michael.eschweiler@web.de <mailto:michael.eschweiler@web.de>
>     <mailto:michael.eschweiler@web.de
>     <mailto:michael.eschweiler@web.de>>> wrote:
>     >
>     >=C2=A0 =C2=A0 =C2=A0Hi there,
>     >
>     >=C2=A0 =C2=A0 =C2=A0I am using postgresql 12 on Linux opensuse Leap=
 15.2.
>     >=C2=A0 =C2=A0 =C2=A0In 'former times' with my postgresql-db I used =
pgadmin3. It
>     was nice and
>     >=C2=A0 =C2=A0 =C2=A0tiny, and I was happy.
>     >=C2=A0 =C2=A0 =C2=A0Now, with pgadmin4 I am not able to connect to =
my server.
>     There is no
>     >=C2=A0 =C2=A0 =C2=A0problem with pgsql nor with knoda even from ano=
ther computer
>     but with
>     >=C2=A0 =C2=A0 =C2=A0pgadmin4 I always get an authentication error. =
In pg_hba.conf
>     I changed
>     >=C2=A0 =C2=A0 =C2=A0all connections to 'trust' - but no way!
>     >=C2=A0 =C2=A0 =C2=A0Is there a verbose-mode for pgadmin4 in order t=
o see what is
>     happening?
>     >
>     > It should work with pgAdmin as you have no problem with psql.
>     > You can enable logging to check the issue, please
>     > refer=C2=A0https://www.pgadmin.org/faq/#8
>     <https://www.pgadmin.org/faq/#8> <https://www.pgadmin.org/faq/#8
>     <https://www.pgadmin.org/faq/#8>> to
>     > enable it.
>     > Also, you can provide the screen-shot of the error you are getting=
, so
>     > we can help you.
>     > =C2=A0
>     >
>     >=C2=A0 =C2=A0 =C2=A0Thanks in advance.
>     >=C2=A0 =C2=A0 =C2=A0Best regards,
>     >=C2=A0 =C2=A0 =C2=A0Michael
>     >
>     >=C2=A0 =C2=A0 =C2=A0By the way: Is there a way to get rid of this a=
nnoying nag screen
>     >=C2=A0 =C2=A0 =C2=A0telling me every time I start pgadmin that ther=
e is a new
>     version? My
>     >=C2=A0 =C2=A0 =C2=A0version came with the distro
>     >
>     > You can disable the version check by setting UPGRADE_CHECK_ENABLED
>     > parameter to False,
>     > refer=C2=A0https://www.pgadmin.org/docs/pgadmin4/4.29/config_py.ht=
ml
>     <https://www.pgadmin.org/docs/pgadmin4/4.29/config_py.html>
>     > <https://www.pgadmin.org/docs/pgadmin4/4.29/config_py.html
>     <https://www.pgadmin.org/docs/pgadmin4/4.29/config_py.html>> for
>     the. same.
>     >
>
>     Thanks for the hints and sorry for the delay. Here is what I did aft=
er
>     having deleted everything related to pgadmin in my user directory:
>     First I created the file config_local.py following the advice at
>     https://www.pgadmin.org/faq/#8 <https://www.pgadmin.org/faq/#8>
>     Then I started pgAdmin4 on a console. During the start I get this
>     message:
>     --- snip ---
>     Invalid MIT-MAGIC-COOKIE-1 keyPython path:
>     "/usr/lib/python3.6/site-packages:/usr/lib64/python3.6/site-packages=
"
>     Python Home:=C2=A0 ""
>     Webapp path:=C2=A0
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py"
>     NOTE: Configuring authentication for DESKTOP mode.
>     pgAdmin 4 - Application Initialisation
>     =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
>     =C2=A0* Serving Flask app "pgadmin" (lazy loading)
>     =C2=A0* Environment: production
>     =C2=A0 =C2=A0WARNING: Do not use the development server in a product=
ion
>     environment.
>     =C2=A0 =C2=A0Use a production WSGI server instead.
>     =C2=A0* Debug mode: off
>     Invalid MIT-MAGIC-COOKIE-1 keyInvalid MIT-MAGIC-COOKIE-1 keyInvalid
>     MIT-MAGIC-COOKIE-1 key
>     --- snip ---
>     (don't know if this is ok...)
>
>     The browser window with pgAdmin4 opened. In order to see what happen=
ed
>     please revise the attached pdf. As you will see, my trial ended up w=
ith
>     ... nothing.
>
>     Looking through the pgAdmin4.startup.log (attached) I didn't find
>     nothing special - this seems ok but I must confess that don't know h=
ow
>     to interprete the messages in pgadmin4.log (attached) and if there i=
s
>     any hint in order to see what went wrong.
>
>     I would appreciate any help in order to get pgAdmin4 working.
>
>     Best regards,
>     Michael
>
>     P.S.: The authentication configuring in pg_hba.conf:
>
>     # "local" is for Unix domain socket connections only
>     local=C2=A0 =C2=A0all=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0trust
>     # IPv4 local connections:
>     host=C2=A0 =C2=A0 all=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0127.0.0.1/32 <http://127.0.0.1/32>=C2=A0 =C2=A0
>     =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5
>     host=C2=A0 =C2=A0 all=C2=A0 =C2=A0username=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 xxx.xxx.xx.0/24=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0trust
>
>     (the last line I introduced so that my normal user can access the
>     database remotely from different machines in my local network.)
>