pg.ddx.io pgadmin-support@postgresql.org mailing list archive
help / color / mirror / Atom feedauthentication fail
9+ messages / 3 participants
[nested] [flat]
* authentication fail
@ 2021-01-11 19:08 Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
0 siblings, 1 reply; 9+ messages in thread
From: Michael Eschweiler @ 2021-01-11 19:08 UTC (permalink / raw)
To: pgadmin-support@lists.postgresql.org
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?
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
@ 2021-01-12 04:26 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
0 siblings, 1 reply; 9+ messages in thread
From: Khushboo Vashi @ 2021-01-12 04:26 UTC (permalink / raw)
To: Michael Eschweiler <michael.eschweiler@web.de>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi,
On Tue, Jan 12, 2021 at 12:39 AM Michael Eschweiler <
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 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 for the. same.
Thanks,
Khushboo
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
@ 2021-01-30 08:28 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
0 siblings, 1 reply; 9+ messages in thread
From: Michael Eschweiler @ 2021-01-30 08:28 UTC (permalink / raw)
To: khushboo.vashi@enterprisedb.com; +Cc: pgadmin-support@lists.postgresql.org
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>> 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; 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; 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
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 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.)
Attachments:
pgadmin_d.pdf (application/pdf, 908.7K) download
.pgAdmin4.startup.log (text/x-log, 1.4K) download
29.01.2021 16:18:20 Checking for system tray...
29.01.2021 16:18:20 Starting pgAdmin4 server...
29.01.2021 16:18:20 Creating server object, port:39765, key:a0c437af-059d-48e8-a19b-1b7270c69347, logfile:/home/me/.pgAdmin4.11250296771855179612.log
29.01.2021 16:18:20 Python Path: /usr/lib/python3.6/site-packages:/usr/lib64/python3.6/site-packages
29.01.2021 16:18:20 Python Home:
29.01.2021 16:18:20 Initializing Python...
29.01.2021 16:18:20 Python initialized.
29.01.2021 16:18:20 Adding new additional path elements
29.01.2021 16:18:20 Redirecting stderr...
29.01.2021 16:18:20 stderr redirected successfully.
29.01.2021 16:18:20 Initializing server...
29.01.2021 16:18:20 Webapp Path: /usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py
29.01.2021 16:18:20 Server initialized.
29.01.2021 16:18:20 Starting Server Thread...
29.01.2021 16:18:20 Open the application code and run it.
29.01.2021 16:18:20 Set the port number, key and force SERVER_MODE off
29.01.2021 16:18:20 PyRun_SimpleFile launching application server...
29.01.2021 16:18:21 Application Server URL: http://127.0.0.1:39765/?key=a0c437af-059d-48e8-a19b-1b7270c69347
29.01.2021 16:18:21 The server should be up, we'll attempt to connect and get a response. Ping the server
29.01.2021 16:19:02 Attempt to connect one more time in case of a long network timeout while looping
29.01.2021 16:19:02 Everything works fine, successfully started pgAdmin4.=
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
@ 2021-02-01 04:50 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
0 siblings, 1 reply; 9+ messages in thread
From: Khushboo Vashi @ 2021-02-01 04:50 UTC (permalink / raw)
To: Michael Eschweiler <michael.eschweiler@web.de>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi,
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.
Thanks,
Khushboo
On Sat, Jan 30, 2021 at 1:58 PM Michael Eschweiler <
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>> 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; 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; 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
> 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 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.)
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
@ 2021-02-01 21:25 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 22:40 ` Re: authentication fail Edson Richter <edsonrichter@hotmail.com>
2021-02-02 04:37 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
0 siblings, 2 replies; 9+ messages in thread
From: Michael Eschweiler @ 2021-02-01 21:25 UTC (permalink / raw)
To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
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.)
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
@ 2021-02-01 22:40 ` Edson Richter <edsonrichter@hotmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Edson Richter @ 2021-02-01 22:40 UTC (permalink / raw)
To: michael.eschweiler@web.de <michael.eschweiler@web.de>; +Cc: khushboo.vashi@enterprisedb.com <khushboo.vashi@enterprisedb.com>; pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
May I suggest you to use dockerized pgAdmin?
Edson Richter
Soli Deo Gloria
Em 1 de fev de 2021, em 18:26, Michael Eschweiler <michael.eschweiler@web.de<mailto:michael.eschweiler@web.de>> escreveu:
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<http://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<http://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; <http://127.0.0.1/32;
md5
host all username xxx.xxx<http://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.)
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
@ 2021-02-02 04:37 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-02 22:00 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
1 sibling, 1 reply; 9+ messages in thread
From: Khushboo Vashi @ 2021-02-02 04:37 UTC (permalink / raw)
To: Michael Eschweiler <michael.eschweiler@web.de>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi,
On Tue, Feb 2, 2021 at 2:55 AM Michael Eschweiler <michael.eschweiler@web.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.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.)
> >
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-02 04:37 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
@ 2021-02-02 22:00 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-03 04:53 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
0 siblings, 1 reply; 9+ messages in thread
From: Michael Eschweiler @ 2021-02-02 22:00 UTC (permalink / raw)
To: Khushboo Vashi <khushboo.vashi@enterprisedb.com>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi,
Am 02.02.21 um 05:37 schrieb Khushboo Vashi:
> Hi,
>
> On Tue, Feb 2, 2021 at 2:55 AM Michael Eschweiler
> <michael.eschweiler@web.de <mailto:michael.eschweiler@web.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
> <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/
> <https://www.pgadmin.org/download/> like Python package or Docker
> Container.
Thanks for the hints. I would like to try with the docker container.
Therefore I installed docker and started docker daemon.
Perhaps I am too simple-hearted: I than copied the command indicated at
the web site: docker pull dpage/pgadmin4
I got the message 'Got permission denied while trying to connect to the
Docker daemon socket at unix:///var/run/docker.sock: Post
"http://%2Fvar%2Frun%2Fdocker.sock/v1.40/images/create?fromImage=dpage%2Fpgadmin4&tag=latest";:
dial unix /var/run/docker.sock: connect: permission denied'
Do I have to register or do something else?
Thx in advance,
Michael
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: authentication fail
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-02-02 04:37 ` Re: authentication fail Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-02 22:00 ` Re: authentication fail Michael Eschweiler <michael.eschweiler@web.de>
@ 2021-02-03 04:53 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
0 siblings, 0 replies; 9+ messages in thread
From: Khushboo Vashi @ 2021-02-03 04:53 UTC (permalink / raw)
To: Michael Eschweiler <michael.eschweiler@web.de>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi,
On Wed, Feb 3, 2021 at 3:30 AM Michael Eschweiler <michael.eschweiler@web.de>
wrote:
> Hi,
>
> Am 02.02.21 um 05:37 schrieb Khushboo Vashi:
> > Hi,
> >
> > On Tue, Feb 2, 2021 at 2:55 AM Michael Eschweiler
> > <michael.eschweiler@web.de <mailto:michael.eschweiler@web.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
> > <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/
> > <https://www.pgadmin.org/download/; like Python package or Docker
> > Container.
>
> Thanks for the hints. I would like to try with the docker container.
> Therefore I installed docker and started docker daemon.
> Perhaps I am too simple-hearted: I than copied the command indicated at
> the web site: docker pull dpage/pgadmin4
> I got the message 'Got permission denied while trying to connect to the
> Docker daemon socket at unix:///var/run/docker.sock: Post
> "http://
> %2Fvar%2Frun%2Fdocker.sock/v1.40/images/create?fromImage=dpage%2Fpgadmin4&tag=latest":
> dial unix /var/run/docker.sock: connect: permission denied'
> Do I have to register or do something else?
>
> This is something related to your system. I googled the issue and found
this,
https://unix.stackexchange.com/questions/382262/cannot-start-docker-daemon-in-opensuse,
it may help you.
Thanks,
Khushboo
> Thx in advance,
> Michael
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2021-02-03 04:53 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-11 19:08 authentication fail Michael Eschweiler <michael.eschweiler@web.de>
2021-01-12 04:26 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-01-30 08:28 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 04:50 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-01 21:25 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-01 22:40 ` Edson Richter <edsonrichter@hotmail.com>
2021-02-02 04:37 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
2021-02-02 22:00 ` Michael Eschweiler <michael.eschweiler@web.de>
2021-02-03 04:53 ` Khushboo Vashi <khushboo.vashi@enterprisedb.com>
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