Re: authentication fail

Hi,

On Tue, Feb 2, 2021 at 2:55 AM Michael Eschweiler <michael(dot)eschweiler(at)web(dot)de>
wrote:

> 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?
>
> We do not support OpenSuse. As an alternative, you can use other
distributions from https://www.pgadmin.org/download/ like Python package
or Docker Container.

Thanks,
Khushboo

>
> Thanks in advance,
> Michael
>
> >
> > Thanks,
> > Khushboo
> >
> >
> > On Sat, Jan 30, 2021 at 1:58 PM Michael Eschweiler
> > <michael(dot)eschweiler(at)web(dot)de <mailto:michael(dot)eschweiler(at)web(dot)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(dot)eschweiler(at)web(dot)de <mailto:michael(dot)eschweiler(at)web(dot)de>
> > <mailto:michael(dot)eschweiler(at)web(dot)de
> > <mailto:michael(dot)eschweiler(at)web(dot)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.)
> >
>