From: Michael Eschweiler <michael.eschweiler@web.de>
To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: authentication fail
Date: Mon, 1 Feb 2021 22:25:48 +0100
Message-ID: <6c43d987-ae7d-bd1b-6760-ecdea3d25004@web.de> (raw)
In-Reply-To: <CAFOhELc-ibJYRxya=6qnmS+7U2dtcUNoqA2VRnfNJ82LwUOYFg@mail.gmail.com>
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>
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ür 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:
> >
> > Hi there,
> >
> > I am using postgresql 12 on Linux opensuse Leap 15.2.
> > In 'former times' with my postgresql-db I used pgadmin3. It
> was nice and
> > tiny, and I was happy.
> > Now, with pgadmin4 I am not able to connect to my server.
> There is no
> > problem with pgsql nor with knoda even from another computer
> but with
> > pgadmin4 I always get an authentication error. In pg_hba.conf
> I changed
> > all connections to 'trust' - but no way!
> > Is there a verbose-mode for pgadmin4 in order to 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 https://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.
> >
> >
> > Thanks in advance.
> > Best regards,
> > Michael
> >
> > By the way: Is there a way to get rid of this annoying nag screen
> > telling me every time I start pgadmin that there is a new
> version? My
> > version came with the distro
> >
> > You can disable the version check by setting UPGRADE_CHECK_ENABLED
> > parameter to False,
> > refer 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
> <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 after
> 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: ""
> Webapp path:
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py"
> NOTE: Configuring authentication for DESKTOP mode.
> pgAdmin 4 - Application Initialisation
> ======================================
>
> * Serving Flask app "pgadmin" (lazy loading)
> * Environment: production
> WARNING: Do not use the development server in a production
> environment.
> Use a production WSGI server instead.
> * 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 happened
> please revise the attached pdf. As you will see, my trial ended up with
> ... 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 how
> to interprete the messages in pgadmin4.log (attached) and if there is
> 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 all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 <http://127.0.0.1/32>
> md5
> host all username xxx.xxx.xx.0/24 trust
>
> (the last line I introduced so that my normal user can access the
> database remotely from different machines in my local network.)
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgadmin-support@postgresql.org
Cc: michael.eschweiler@web.de, khushboo.vashi@enterprisedb.com, pgadmin-support@lists.postgresql.org
Subject: Re: authentication fail
In-Reply-To: <6c43d987-ae7d-bd1b-6760-ecdea3d25004@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox